Microsoft Graph Excel API

aid: spreadsheets:microsoft-graph-excel-api
name: Microsoft Graph Excel API
description: The Microsoft Graph Excel API enables reading and writing Excel workbooks (.xlsx format)
  stored in OneDrive for Business, SharePoint, or Group drives via the Microsoft Graph REST API. Supports
  worksheets, ranges, tables, charts, named items, and Excel worksheet functions. Uses session-based access
  for efficient multi-step operations. Authentication requires Microsoft identity platform (OAuth 2.0)
  with Files.Read or Files.ReadWrite scopes.
humanURL: https://learn.microsoft.com/en-us/graph/api/resources/excel
baseURL: https://graph.microsoft.com/v1.0
tags:
- Excel
- Microsoft Graph
- Microsoft 365
- Spreadsheets
- OneDrive
properties:
- type: Documentation
  url: https://learn.microsoft.com/en-us/graph/api/resources/excel
- type: Reference
  url: https://learn.microsoft.com/en-us/graph/api/resources/excel
- type: Getting Started
  url: https://learn.microsoft.com/en-us/graph/excel-use-functions
features:
- type: WorkbookAccess
  description: Read and modify .xlsx workbooks stored in OneDrive for Business and SharePoint
- type: Sessions
  description: Persistent and non-persistent session management for efficient operations
- type: WorksheetManagement
  description: Create, rename, delete, and reorder worksheets within a workbook
- type: RangeOperations
  description: Read, write, format, and sort cell ranges using A1-style addressing
- type: TableOperations
  description: Create tables, manage rows/columns, sort, filter, and convert to range
- type: ChartOperations
  description: Create, update, and retrieve chart images from workbooks
- type: NamedItems
  description: Work with named ranges and named expressions
- type: WorkbookFunctions
  description: Execute Excel worksheet functions (PMT, SUM, VLOOKUP, etc.) via API