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.

3 APIs 6 Features

AutomationData AnalysisMicrosoftMicrosoft 365OfficeSpreadsheets

APIs

Microsoft Graph Excel API

REST API for accessing and manipulating Excel workbooks stored in OneDrive for Business, SharePoint sites, or Group drives through Microsoft Graph. Supports worksheet, table, ch...

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.

Features

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.

Use Cases

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.

Semantic Vocabularies

Microsoft Excel Graph Api Context

9 classes · 20 properties

JSON-LD

API Governance Rules

Microsoft Excel API Rules

24 rules · 16 errors 6 warnings 2 info

SPECTRAL

Resources

GitHubOrganization

Sources

aid: microsoft-excel
name: Microsoft Excel
description: APIs for automating, integrating, and extending Microsoft Excel functionality including workbook management,
  data manipulation, charting, and formula execution through Microsoft Graph REST APIs.
image: https://learn.microsoft.com/en-us/graph/images/excel-logo.png
url: https://raw.githubusercontent.com/api-evangelist/microsoft-excel/refs/heads/main/apis.yml
humanURL: https://www.microsoft.com/excel
created: '2024'
modified: '2026-05-19'
specificationVersion: '0.19'
type: Index
tags:
- Automation
- Data Analysis
- Microsoft
- Microsoft 365
- Office
- Spreadsheets
apis:
- name: Microsoft Graph Excel API
  description: REST API for accessing and manipulating Excel workbooks stored in OneDrive for Business, SharePoint sites,
    or Group drives through Microsoft Graph. Supports worksheet, table, chart, range, named item, and function operations.
  humanURL: https://learn.microsoft.com/en-us/graph/api/resources/excel
  baseURL: https://graph.microsoft.com/v1.0
  tags:
  - Cloud
  - Microsoft Graph
  - OneDrive
  - REST API
  - SharePoint
  properties:
  - type: Documentation
    url: https://learn.microsoft.com/en-us/graph/api/resources/excel
  - type: OpenAPI
    url: openapi/microsoft-excel-graph-api.yaml
  - type: Authentication
    url: https://learn.microsoft.com/en-us/graph/auth/
  - type: APIReference
    url: https://learn.microsoft.com/en-us/graph/api/resources/excel
  - type: SDK
    url: https://learn.microsoft.com/en-us/graph/sdks/sdks-overview
  - type: JSONSchema
    url: json-schema/excel-graph-api-worksheet-schema.json
  - type: JSONSchema
    url: json-schema/excel-graph-api-table-schema.json
  - type: JSONSchema
    url: json-schema/excel-graph-api-table-row-schema.json
  - type: JSONSchema
    url: json-schema/excel-graph-api-table-column-schema.json
  - type: JSONSchema
    url: json-schema/excel-graph-api-chart-schema.json
  - type: JSONSchema
    url: json-schema/excel-graph-api-range-schema.json
  - type: JSONSchema
    url: json-schema/excel-graph-api-named-item-schema.json
  - type: JSONStructure
    url: json-structure/excel-graph-api-worksheet-structure.json
  - type: JSONLD
    url: json-ld/microsoft-excel-graph-api-context.jsonld
  - type: Example
    url: examples/excel-graph-api-worksheet-example.json
  - type: Example
    url: examples/excel-graph-api-table-example.json
  - type: Example
    url: examples/excel-graph-api-range-example.json
  - type: NaftikoCapability
    url: capabilities/graph-charts.yaml
  - type: NaftikoCapability
    url: capabilities/graph-functions.yaml
  - type: NaftikoCapability
    url: capabilities/graph-named-items.yaml
  - type: NaftikoCapability
    url: capabilities/graph-ranges.yaml
  - type: NaftikoCapability
    url: capabilities/graph-sessions.yaml
  - type: NaftikoCapability
    url: capabilities/graph-table-columns.yaml
  - type: NaftikoCapability
    url: capabilities/graph-table-rows.yaml
  - type: NaftikoCapability
    url: capabilities/graph-tables.yaml
  - type: NaftikoCapability
    url: capabilities/graph-worksheets.yaml
- name: Excel JavaScript API
  description: Office Add-ins API for building custom functionality within Excel using JavaScript and TypeScript.
  humanURL: https://learn.microsoft.com/en-us/office/dev/add-ins/reference/overview/excel-add-ins-reference-overview
  baseURL: https://excel.office.com
  tags:
  - Client-Side
  - JavaScript
  - Office Add-Ins
  properties:
  - type: Documentation
    url: https://learn.microsoft.com/en-us/javascript/api/excel
  - type: GettingStarted
    url: https://learn.microsoft.com/en-us/office/dev/add-ins/quickstarts/excel-quickstart-jquery
- name: Office Scripts API
  description: TypeScript-based automation for Excel on the web, enabling Power Automate integration for business process
    automation.
  humanURL: https://learn.microsoft.com/en-us/office/dev/scripts/overview/excel
  baseURL: https://excel.office.com
  tags:
  - Automation
  - Excel Online
  - Power Automate
  - TypeScript
  properties:
  - type: Documentation
    url: https://learn.microsoft.com/en-us/office/dev/scripts/develop/scripting-fundamentals
  - type: CodeExamples
    url: https://learn.microsoft.com/en-us/office/dev/scripts/resources/samples/samples-overview
  - type: Tutorials
    url: https://learn.microsoft.com/en-us/office/dev/scripts/tutorials/excel-tutorial
common:
- type: DeveloperPortal
  url: https://developer.microsoft.com/en-us/microsoft-365
- type: Support
  url: https://support.microsoft.com/excel
- type: TermsOfService
  url: https://www.microsoft.com/en-us/legal/terms-of-use
- type: PrivacyPolicy
  url: https://privacy.microsoft.com/
- type: Pricing
  url: https://www.microsoft.com/en-us/microsoft-365/excel
- type: Blog
  url: https://techcommunity.microsoft.com/t5/excel-blog/bg-p/ExcelBlog
- type: GitHubOrganization
  url: https://github.com/OfficeDev
- type: SpectralRules
  url: rules/microsoft-excel-spectral-rules.yml
- type: Vocabulary
  url: vocabulary/microsoft-excel-vocabulary.yaml
- type: Features
  data:
  - name: Workbook Sessions
    description: Persistent and non-persistent sessions for efficient API operations.
  - name: Cell Range Operations
    description: Read, write, and format individual cells or ranges of cells.
  - name: Table Management
    description: Create, update, sort, and filter structured tables.
  - name: Chart Generation
    description: Create and manage charts with customizable source data.
  - name: Workbook Functions
    description: Invoke Excel functions programmatically via the API.
  - name: Named Ranges
    description: Define and manage named ranges for reusable cell references.
- type: UseCases
  data:
  - name: Automated Reporting
    description: Generate and update Excel reports from external data sources.
  - name: Data Entry Automation
    description: Programmatically insert and update data in spreadsheets.
  - name: Financial Modeling
    description: Use Excel functions API for financial calculations.
  - name: Dashboard Generation
    description: Create charts and visualizations from data.
- type: Integrations
  data:
  - name: Microsoft Power Automate
    description: Automate Excel workflows using Power Automate connectors.
  - name: SharePoint
    description: Access and modify Excel files stored in SharePoint sites.
  - name: OneDrive
    description: Work with Excel workbooks stored in OneDrive for Business.
  - name: Microsoft Teams
    description: Share and collaborate on Excel workbooks within Teams.
- type: Integrations
  url: https://www.microsoft.com/en-us/marketplace
integrations:
- name: Microsoft
- name: Two people looking at a computer.
- name: This is placeholder text for
- name: IDC
- name: Nationwide
- name: RSA company
- name: Teleperformance
- name: A woman smiling at a laptop
- name: A man holding a laptop.
maintainers:
- FN: Kin Lane
  email: [email protected]