Skip to main content
Skip to main content
Microsoft 365

Announcing the general availability of the Microsoft Excel API to expand the power of Office 365

Today, we are pleased to announce the general availability of the Microsoft Excel REST API for Office 365—now developers can use Excel to power custom apps. Excel is an indispensable productivity tool; users across all industries and roles embrace it. It is used for everything from simple task tracking and data management, to complex calculations and professional reporting. With our new interface, Excel for Office 365 can extend the value of your data, calculations, reporting and dashboards.

The Excel REST API release is a continuation of our journey to make Office an open platform for developers. The Office developer framework uses modern web development standards, so developers can build smarter apps that operate as part of Office on mobile, web and desktop platforms. The new Excel interface is exposed through the Microsoft Graph to access to intelligence and insights from the Microsoft cloud.

Here are a few scenarios how developers can use the new Excel REST API:

Excel as a calculation service

Users love the ease with which they can perform deep and complex calculations within Excel. Developers can now access Excel’s powerful calculation engine with instant results. For example, a mortgage calculator can take advantage of the PMT function from Excel—using a simple API call including principal, rate and number of payments. Excel does all the heavy lifting and returns the monthly payment instantly. With more than 300 Excel worksheet functions available, you have full access to the breadth of formula supported by Excel today. Complex business models don’t need to be rebuilt repeatedly; developers can leverage Excel to perform those calculations instantly and retrieve the results with simple API calls.

Excel as a reporting service

Excel is a reporting hero, from simple data tables to professional dashboards. Today, we are giving developers full access to all of Excel’s reporting features—making Excel an online reporting service within Office 365. Imagine any of the reporting scenarios users rely on today pulled into a custom app to create professional charts or analyze large sets of data intelligently, seamlessly blending Excel into those customized experiences.

Excel as a data service

Excel is also a great tool to store and track data. If your information is stored in a workbook, that data is available to any app integrating with Office 365, making its contents available to read from custom solutions and enabling them to use Excel as the data storage.

We look forward to working with developers and partners to discover and build new places and scenarios where Excel will continue to enable people to be more productive. Companies are already taking advantage of our new Excel REST API, including:

zapierZapier lets users easily automate tedious tasks. Zapier recently announced a new Excel integration, powered by Excel REST API, with near-infinite use cases, like simplifying a data collection process. Users can now build zaps where data is automatically added into Excel from other services, like emails and surveys, making Excel the data repository for all your connected services.

sageSage is working on integrating Sage 50 accounting software with Office 365, leveraging Excel via the new Excel REST API to access and combine business data in Sage 50 with the productivity benefits of Office. With powerful interactive Microsoft Excel reporting and business performance dashboards, Sage has simplified how to interact with the data and enabled small and medium businesses to make sense of data quickly—and make faster, better decisions.

Want to build custom apps using Excel?

Excellent! Visit, where you’ll find documentation and code samples to help you get started. It only takes a few lines of code to set up a basic integration with our Excel to-do list. Once you jump in, tell us what you think. Give us your feedback on the API and documentation through GitHub and Stack Overflow, or make new feature suggestions on UserVoice.

—The Office Extensibility team

You may also like these articles

Image for: View live transcripts in Microsoft Teams meetings, track Excel changes, and increase hybrid work security—here’s what’s new to Microsoft 365
• 5 min read

View live transcripts in Microsoft Teams meetings, track Excel changes, and increase hybrid work security—here’s what’s new to Microsoft 365

This month, we're announcing some top requested features like tracking changes in Excel and live transcriptions in Teams, as well as some soon-to-be-favorites like meeting recaps, turning Word documents in presentations, and more.

Image for: Family hanging out at home baking holiday cookies using Lenovo Ideapad Flex 3 to make holiday cards
• 5 min read

New apps and features in Microsoft 365 for individuals and families this fall

Since we introduced Microsoft 365 to individuals and families earlier this year, we have continued to deliver new innovations across our apps and services to help you and your family save time and stay connected. See what’s new below. Locate your loved ones and build better driving habits with Microsoft Family Safety Stay connected even…

Image for: A man is using his Lenovo laptop like a tablet while sitting in a comfortable chair in a Modern office setting
• 6 min read

Microsoft Productivity Score and personalized experiences—here’s what’s new to Microsoft 365 in October

As I reflect on an action-packed few weeks, I’m struck by how much work has evolved in these past months. And I know our customers feel it too. After quickly moving to remote and hybrid work models this spring, organizations are now seeking sustainable ways to help people collaborate, be productive, and prioritize their wellbeing…