Microsoft Excel
APIs for automating, integrating, and extending Microsoft Excel functionality including workbook management, data manipulation, charting, and formula execution through Microsoft Graph REST APIs.
Microsoft Excel publishes 9 APIs on the APIs.io network, including Charts API, Functions API, Named Items API, and 6 more. Tagged areas include Automation, Data Analysis, Microsoft, Microsoft 365, and Office.
The Microsoft Excel catalog on APIs.io includes 1 JSON-LD context and 2 Spectral governance rulesets.
Microsoft Excel’s developer surface includes authentication, changelog, CLI, sandbox, support, pricing, engineering blog, and 35 more developer resources.
Kin Score
APIs 11
Individual APIs this provider publishes, each with its own machine-readable definition.
Excel JavaScript API
Office Add-ins API for building custom functionality within Excel using JavaScript and TypeScript.
Office Scripts API
TypeScript-based automation for Excel on the web, enabling Power Automate integration for business process automation.
Microsoft Excel Charts API
Operations for managing charts within worksheets.
Microsoft Excel Functions API
Workbook function operations.
Microsoft Excel Named Items API
Operations for managing named ranges and values.
Microsoft Excel Ranges API
Operations for reading and writing cell ranges.
Microsoft Excel Sessions API
Workbook session management operations.
Microsoft Excel Table Columns API
Operations for managing table columns.
Microsoft Excel Table Rows API
Operations for managing table row data.
Microsoft Excel Tables API
Operations for managing tables within worksheets.
Microsoft Excel Worksheets API
Operations for managing worksheets within a workbook.
Scroll for all 11
Postman Collections 9
Ready-to-run Postman collections for exercising this provider's APIs.
Scroll for all 9
Arazzo Workflows 12
Multi-step API workflows described with the Arazzo specification.
Microsoft Excel Append a Row to a Table
Resolve a table on a worksheet, confirm its column shape, append a row, and read it back.
ARAZZOMicrosoft Excel Build a Chart from a Data Range
Verify a source range has data, create a chart over it, and confirm the chart exists.
ARAZZOMicrosoft Excel Flatten a Table into a Plain Range
Snapshot a table's rows and columns, convert it to a static range, and read the flattened cells.
ARAZZOMicrosoft Excel Create a Worksheet and Seed It with Data
Add a new worksheet to a workbook, write a header and data block into it, and read it back.
ARAZZOMicrosoft Excel Discover Workbook Structure
Open a session and inventory a workbook's worksheets, tables, named items, and charts.
ARAZZOMicrosoft Excel Write Through a Named Range
Resolve a workbook's named items, read the range a name points at, and write values through it.
ARAZZOMicrosoft Excel Sort, Filter, and Total a Table for Reporting
Resolve a table's columns, sort it, filter a column, and switch on the totals row.
ARAZZOMicrosoft Excel Delete a Table Row by Index
Read a table's rows, delete one by its zero-based index, and confirm the removal.
ARAZZOMicrosoft Excel Read, Write, and Verify a Cell Range
Open a persisting session, read a range, write new values, and read the range back.
ARAZZOMicrosoft Excel Add and Retire a Table Column
Inspect a table's columns, insert a new column at a position, verify it, then remove it.
ARAZZOMicrosoft Excel Calculate with a Workbook Function and Write the Result
Read input cells, invoke an Excel function as a calculation engine, and write the result back.
ARAZZOMicrosoft Excel Scratch Worksheet Lifecycle
Create a temporary worksheet, read it, rename and reposition it, then delete it.
ARAZZOScroll for all 12
MCP Servers 1
Model Context Protocol servers that expose these APIs to AI agents.
microsoft-excel-mcp.yml
MCP SERVERPricing Plans 1
Published pricing tiers and plan structures.
Rate Limits 1
Documented rate limits and quota policies.
Microsoft Excel Rate Limits
RATE LIMITSFinOps 1
Cost, billing, and metering signals for API financial operations.
Microsoft Excel Finops
FINOPSFeatures 6
Notable capabilities this provider offers.
Workbook Sessions
Persistent and non-persistent sessions for efficient API operations.
Cell Range Operations
Read, write, and format individual cells or ranges of cells.
Table Management
Create, update, sort, and filter structured tables.
Chart Generation
Create and manage charts with customizable source data.
Workbook Functions
Invoke Excel functions programmatically via the API.
Named Ranges
Define and manage named ranges for reusable cell references.
Semantic Vocabularies 1
JSON-LD contexts and semantic vocabularies used across these APIs.
Spectral Rules 2
Spectral governance rulesets for linting and validating these APIs.
Microsoft Excel API Rules
SPECTRALMicrosoft Excel API Rules
SPECTRALJSON Schema 7
Standalone JSON Schema definitions for this provider's data models.
Chart
JSON SCHEMANamedItem
JSON SCHEMARange
JSON SCHEMATableColumn
JSON SCHEMATableRow
JSON SCHEMATable
JSON SCHEMAWorksheet
JSON SCHEMAScroll for all 7
JSON Structure 7
JSON Structure definitions describing this provider's data shapes.
Excel Graph Api Chart Structure
JSON STRUCTUREExcel Graph Api Named Item Structure
JSON STRUCTUREExcel Graph Api Range Structure
JSON STRUCTUREExcel Graph Api Table Column Structure
JSON STRUCTUREExcel Graph Api Table Row Structure
JSON STRUCTUREExcel Graph Api Table Structure
JSON STRUCTUREExcel Graph Api Worksheet Structure
JSON STRUCTUREScroll for all 7
Examples 7
Example request and response payloads for these APIs.
Scroll for all 7
Security Posture 4
Authentication, domain security, vulnerability disclosure, and trust-center signals.
Microsoft Excel Trust Center
SOC 1, SOC 2, SOC 3, ISO 27001, ISO 27017, ISO 27018, ISO 27701, PCI DSS, HIPAA / HITRUST, FedRAMP, GDPR, CSA STAR
SECURITYScopes 1
OAuth scopes governing access to this provider's APIs.
Agentic Access 1
Recommended x-agentic-access execution contracts for AI agents.
Use Cases 4
What developers build with this provider.
Automated Reporting
Generate and update Excel reports from external data sources.
Data Entry Automation
Programmatically insert and update data in spreadsheets.
Financial Modeling
Use Excel functions API for financial calculations.
Dashboard Generation
Create charts and visualizations from data.
Resources
Get Started 2
Portal, sign-up, and the first successful call
Agent Surfaces 4
MCP servers, agent skills, and machine-readable catalogs
Design & Contract 19
Pagination, idempotency, versioning, errors, and events
Scroll for all 19
Build 4
SDKs, sample code, and the tooling you integrate with
Access & Security 6
Authentication, authorization, and security posture
Operate 2
Status, limits, changes, and where to get help
Commercial 3
Pricing, plans, and the legal terms of use
Company 1
The organization behind the API
Other 1
Properties that don't map to a standard resource type