Microsoft Excel (Advanced)

Advanced automation and integration APIs for Microsoft Excel, enabling programmatic access to spreadsheet data, formulas, charts, and automation capabilities through Microsoft Graph, Office Scripts, JavaScript add-ins, custom functions, OneDrive REST endpoints, and Power Automate connectors.

Microsoft Excel (Advanced) publishes 9 APIs on the APIs.io network, including Charts API, Functions API, NamedItems API, and 6 more. Tagged areas include Automation, Business Intelligence, Data Analysis, Office, and Spreadsheets.

Microsoft Excel (Advanced)’s developer surface includes authentication, developer portal, and 9 more developer resources.

🌐 Visit website 📡 Source on GitHub

33.5/100 thin ▬ flat Agent 29/100 agent aware Full breakdown ↓
scored 2026-08-21 · rubric v0.12.0

AccessFreemiumSelf serve⚡ Free to try

14 APIs

Automation Business Intelligence Data Analysis Office Spreadsheets

Kin Score

Kin Score How this is scored →
scored 2026-08-21 · rubric v0.12.0

Composite quality — 33.5/100 · thin

Contract Quality 12.9 / 25

Developer Ergonomics 5.7 / 20

Access Clarity 7.4 / 20

Operational Transparency 1.0 / 13

Contract Governance 0.0 / 12

Discoverability 6.5 / 10

Agent readiness — 29/100 · agent aware

Machine-Readable Contract 18 / 18

Agentic Access Contract 10 / 10

Documented Reversibility 0 / 6

MCP Server 0 / 12

Machine-Readable Auth 10 / 10

Idempotency 0 / 9

Stable Error Semantics 0 / 8

Request/Response Examples 0 / 7

Rate-Limit Signaling 7 / 7

Typed Event Surface 0 / 6

Agent Skills 0 / 5

Well-Known Catalog 0 / 4

Consent & Bot Identity 0 / 3

A2A Agent Card 0 / 8

Dry-Run / Simulate Mode 0 / 4

Improve this rating by publishing the missing artifacts — every area above can be raised, and the full rubric is at apis.io/rating/. This rating is computed from github.com/api-evangelist/microsoft-excel-advanced: open an issue to ask a question, or submit a pull request to add artifacts. Want it done for you? Prioritized profiling — $2,500 →

APIs 14

Individual APIs this provider publishes, each with its own machine-readable definition.

Open Collections 11

Open, tool-agnostic API collections (OpenAPI-derived and Bruno).

Rate Limits 1

Documented rate limits and quota policies.

Microsoft Excel Advanced Rate Limits

5 limits

RATE LIMITS

FinOps 1

Cost, billing, and metering signals for API financial operations.

Scopes 1

OAuth scopes governing access to this provider's APIs.

Microsoft Excel Advanced Scopes

4 scopes · authorizationCode

4 scopes

SCOPES

Get Started 1

Portal, sign-up, and the first successful call

Portal

Portal

Documentation 1

Reference material describing how the API behaves

Authentication Guide

Authentication Guide

Agent Surfaces 1

MCP servers, agent skills, and machine-readable catalogs

AgenticAccess

AgenticAccess

Build 1

SDKs, sample code, and the tooling you integrate with

SDKs

SDKs

Access & Security 4

Authentication, authorization, and security posture

VulnerabilityDisclosure

VulnerabilityDisclosure

DomainSecurity

DomainSecurity

Authentication

Authentication

OAuthScopes

OAuthScopes

Operate 1

Status, limits, changes, and where to get help

StatusPage

StatusPage

Commercial 2

Pricing, plans, and the legal terms of use

TermsOfService

TermsOfService

PrivacyPolicy

PrivacyPolicy

Source (apis.yml)

aid: microsoft-excel-advanced
name: Microsoft Excel (Advanced)
description: Advanced automation and integration APIs for Microsoft Excel, enabling programmatic access to spreadsheet data,
  formulas, charts, and automation capabilities through Microsoft Graph, Office Scripts, JavaScript add-ins, custom functions,
  OneDrive REST endpoints, and Power Automate connectors.
type: Index
accessModel:
  pricing: freemium
  onboarding: self-serve
  trial: false
  try_now: true
  public: false
  label: Freemium · Self-serve signup
  confidence: high
  source:
  - plans
  - authentication
  generated: '2026-07-22'
  method: derived
image: https://kinlane-images.s3.amazonaws.com/shared/apis-json/icons/microsoft-excel-advanced.png
tags:
- Automation
- Business Intelligence
- Data Analysis
- Office
- Spreadsheets
created: '2024-01-01'
modified: '2026-04-28'
url: https://raw.githubusercontent.com/api-evangelist/microsoft-excel-advanced/refs/heads/main/apis.yml
specificationVersion: '0.23'
apis:
- name: Office Scripts API
  description: TypeScript-based automation API for Excel on the web and desktop.
  humanURL: https://learn.microsoft.com/en-us/office/dev/scripts/
  baseURL: https://script.office.com
  tags:
  - Automation
  - Power Automate
  - Scripting
  - TypeScript
  tags_raw:
  - Automation
  - Power-Automate
  - Scripting
  - Typescript
  properties:
  - type: Documentation
    url: https://learn.microsoft.com/en-us/office/dev/scripts/overview/excel
  - type: Samples
    url: https://learn.microsoft.com/en-us/office/dev/scripts/resources/samples/
  - type: APIReference
    url: https://learn.microsoft.com/en-us/javascript/api/office-scripts/overview
  - type: Tutorials
    url: https://learn.microsoft.com/en-us/office/dev/scripts/tutorials/excel-tutorial
- name: Excel JavaScript API
  description: JavaScript API for building Excel add-ins and extensions.
  humanURL: https://learn.microsoft.com/en-us/office/dev/add-ins/reference/overview/excel-add-ins-reference-overview
  baseURL: https://appsforoffice.microsoft.com
  tags:
  - Add-Ins
  - Extensions
  - JavaScript
  - Office-Js
  tags_raw:
  - Add-Ins
  - Extensions
  - Javascript
  - Office-Js
  properties:
  - type: Documentation
    url: https://learn.microsoft.com/en-us/office/dev/add-ins/excel/
  - type: APIReference
    url: https://learn.microsoft.com/en-us/javascript/api/excel
  - type: Samples
    url: https://github.com/OfficeDev/Office-Add-in-samples
  - type: GettingStarted
    url: https://learn.microsoft.com/en-us/office/dev/add-ins/quickstarts/excel-quickstart-jquery
  - type: CDN
    url: https://appsforoffice.microsoft.com/lib/1/hosted/office.js
- name: Excel Custom Functions API
  description: API for creating custom functions in Excel using JavaScript.
  humanURL: https://learn.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-overview
  tags:
  - Calculations
  - Custom-Functions
  - Formulas
  - Udf
  properties:
  - type: Documentation
    url: https://learn.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-overview
  - type: Tutorial
    url: https://learn.microsoft.com/en-us/office/dev/add-ins/tutorials/excel-tutorial-create-custom-functions
  - type: Best Practices
    url: https://learn.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-best-practices
- name: Excel REST API (OneDrive)
  description: REST API for accessing Excel files stored in OneDrive and SharePoint.
  humanURL: https://learn.microsoft.com/en-us/onedrive/developer/rest-api/
  baseURL: https://graph.microsoft.com/v1.0/me/drive
  tags:
  - Cloud Storage
  - OneDrive
  - REST
  - SharePoint
  tags_raw:
  - Cloud-Storage
  - Onedrive
  - REST
  - Sharepoint
  properties:
  - type: Documentation
    url: https://learn.microsoft.com/en-us/onedrive/developer/rest-api/api/driveitem_get
  - type: APIReference
    url: https://learn.microsoft.com/en-us/graph/api/resources/driveitem
- name: Power Automate Excel Connector
  description: Pre-built connector for automating Excel workflows in Power Automate.
  humanURL: https://learn.microsoft.com/en-us/connectors/excelonlinebusiness/
  tags:
  - Connector
  - Low-Code
  - Power Automate
  - Workflows
  tags_raw:
  - Connector
  - Low-Code
  - Power-Automate
  - Workflow
  properties:
  - type: Documentation
    url: https://learn.microsoft.com/en-us/connectors/excelonlinebusiness/
  - type: Actions Reference
    url: https://learn.microsoft.com/en-us/connectors/excelonlinebusiness/#actions
  - type: Triggers Reference
    url: https://learn.microsoft.com/en-us/connectors/excelonlinebusiness/#triggers
- aid: microsoft-excel-advanced:microsoft-excel-advanced-charts-api
  name: Microsoft Excel (Advanced) Charts API
  description: Chart operations
  humanURL: https://learn.microsoft.com/en-us/graph/api/resources/excel
  baseURL: https://graph.microsoft.com/v1.0
  tags:
  - Charts
  properties:
  - type: OpenAPI
    url: openapi/microsoft-excel-advanced-charts-api-openapi.yml
  - type: Documentation
    url: https://learn.microsoft.com/en-us/graph/api/resources/excel
  - type: Authentication
    url: https://learn.microsoft.com/en-us/graph/auth/
  - type: GettingStarted
    url: https://learn.microsoft.com/en-us/graph/api/resources/excel#get-started
- aid: microsoft-excel-advanced:microsoft-excel-advanced-functions-api
  name: Microsoft Excel (Advanced) Functions API
  description: Workbook function calls
  humanURL: https://learn.microsoft.com/en-us/graph/api/resources/excel
  baseURL: https://graph.microsoft.com/v1.0
  tags:
  - Functions
  properties:
  - type: OpenAPI
    url: openapi/microsoft-excel-advanced-functions-api-openapi.yml
  - type: Documentation
    url: https://learn.microsoft.com/en-us/graph/api/resources/excel
  - type: Authentication
    url: https://learn.microsoft.com/en-us/graph/auth/
  - type: GettingStarted
    url: https://learn.microsoft.com/en-us/graph/api/resources/excel#get-started
- aid: microsoft-excel-advanced:microsoft-excel-advanced-nameditems-api
  name: Microsoft Excel (Advanced) NamedItems API
  description: Named item operations
  humanURL: https://learn.microsoft.com/en-us/graph/api/resources/excel
  baseURL: https://graph.microsoft.com/v1.0
  tags:
  - Named Items
  tags_raw:
  - NamedItems
  properties:
  - type: OpenAPI
    url: openapi/microsoft-excel-advanced-nameditems-api-openapi.yml
  - type: Documentation
    url: https://learn.microsoft.com/en-us/graph/api/resources/excel
  - type: Authentication
    url: https://learn.microsoft.com/en-us/graph/auth/
  - type: GettingStarted
    url: https://learn.microsoft.com/en-us/graph/api/resources/excel#get-started
- aid: microsoft-excel-advanced:microsoft-excel-advanced-range-api
  name: Microsoft Excel (Advanced) Range API
  description: Range cell operations
  humanURL: https://learn.microsoft.com/en-us/graph/api/resources/excel
  baseURL: https://graph.microsoft.com/v1.0
  tags:
  - Range
  properties:
  - type: OpenAPI
    url: openapi/microsoft-excel-advanced-range-api-openapi.yml
  - type: Documentation
    url: https://learn.microsoft.com/en-us/graph/api/resources/excel
  - type: Authentication
    url: https://learn.microsoft.com/en-us/graph/auth/
  - type: GettingStarted
    url: https://learn.microsoft.com/en-us/graph/api/resources/excel#get-started
- aid: microsoft-excel-advanced:microsoft-excel-advanced-sessions-api
  name: Microsoft Excel (Advanced) Sessions API
  description: Workbook session management
  humanURL: https://learn.microsoft.com/en-us/graph/api/resources/excel
  baseURL: https://graph.microsoft.com/v1.0
  tags:
  - Sessions
  properties:
  - type: OpenAPI
    url: openapi/microsoft-excel-advanced-sessions-api-openapi.yml
  - type: Documentation
    url: https://learn.microsoft.com/en-us/graph/api/resources/excel
  - type: Authentication
    url: https://learn.microsoft.com/en-us/graph/auth/
  - type: GettingStarted
    url: https://learn.microsoft.com/en-us/graph/api/resources/excel#get-started
- aid: microsoft-excel-advanced:microsoft-excel-advanced-tablecolumns-api
  name: Microsoft Excel (Advanced) TableColumns API
  description: Operations on table columns
  humanURL: https://learn.microsoft.com/en-us/graph/api/resources/excel
  baseURL: https://graph.microsoft.com/v1.0
  tags:
  - Table Columns
  tags_raw:
  - TableColumns
  properties:
  - type: OpenAPI
    url: openapi/microsoft-excel-advanced-tablecolumns-api-openapi.yml
  - type: Documentation
    url: https://learn.microsoft.com/en-us/graph/api/resources/excel
  - type: Authentication
    url: https://learn.microsoft.com/en-us/graph/auth/
  - type: GettingStarted
    url: https://learn.microsoft.com/en-us/graph/api/resources/excel#get-started
- aid: microsoft-excel-advanced:microsoft-excel-advanced-tablerows-api
  name: Microsoft Excel (Advanced) TableRows API
  description: Operations on table rows
  humanURL: https://learn.microsoft.com/en-us/graph/api/resources/excel
  baseURL: https://graph.microsoft.com/v1.0
  tags:
  - Table Rows
  tags_raw:
  - TableRows
  properties:
  - type: OpenAPI
    url: openapi/microsoft-excel-advanced-tablerows-api-openapi.yml
  - type: Documentation
    url: https://learn.microsoft.com/en-us/graph/api/resources/excel
  - type: Authentication
    url: https://learn.microsoft.com/en-us/graph/auth/
  - type: GettingStarted
    url: https://learn.microsoft.com/en-us/graph/api/resources/excel#get-started
- aid: microsoft-excel-advanced:microsoft-excel-advanced-tables-api
  name: Microsoft Excel (Advanced) Tables API
  description: Excel table operations
  humanURL: https://learn.microsoft.com/en-us/graph/api/resources/excel
  baseURL: https://graph.microsoft.com/v1.0
  tags:
  - Tables
  properties:
  - type: OpenAPI
    url: openapi/microsoft-excel-advanced-tables-api-openapi.yml
  - type: Documentation
    url: https://learn.microsoft.com/en-us/graph/api/resources/excel
  - type: Authentication
    url: https://learn.microsoft.com/en-us/graph/auth/
  - type: GettingStarted
    url: https://learn.microsoft.com/en-us/graph/api/resources/excel#get-started
- aid: microsoft-excel-advanced:microsoft-excel-advanced-worksheets-api
  name: Microsoft Excel (Advanced) Worksheets API
  description: Worksheet operations
  humanURL: https://learn.microsoft.com/en-us/graph/api/resources/excel
  baseURL: https://graph.microsoft.com/v1.0
  tags:
  - Worksheets
  properties:
  - type: OpenAPI
    url: openapi/microsoft-excel-advanced-worksheets-api-openapi.yml
  - type: Documentation
    url: https://learn.microsoft.com/en-us/graph/api/resources/excel
  - type: Authentication
    url: https://learn.microsoft.com/en-us/graph/auth/
  - type: GettingStarted
    url: https://learn.microsoft.com/en-us/graph/api/resources/excel#get-started
common:
- type: AgenticAccess
  url: agentic-access/microsoft-excel-advanced-agentic-access.yml
- type: VulnerabilityDisclosure
  url: security/microsoft-excel-advanced-vulnerability-disclosure.yml
- type: DomainSecurity
  url: security/microsoft-excel-advanced-domain-security.yml
- type: Authentication
  url: authentication/microsoft-excel-advanced-authentication.yml
- type: OAuthScopes
  url: scopes/microsoft-excel-advanced-scopes.yml
- type: Portal
  url: https://developer.microsoft.com/en-us/microsoft-365
- type: Authentication Guide
  url: https://learn.microsoft.com/en-us/azure/active-directory/develop/
- type: SDKs
  url: https://learn.microsoft.com/en-us/graph/sdks/sdks-overview
- type: StatusPage
  url: https://status.cloud.microsoft/
- type: TermsOfService
  url: https://www.microsoft.com/en-us/legal/terms-of-use
- type: PrivacyPolicy
  url: https://privacy.microsoft.com/
maintainers:
- FN: Kin Lane
  email: kin@apievangelist.com

Work with this as data

Every provider here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for providers

9 MCP tools reach this

find_providersBrowse and filter every provider in the catalog.
get_provider_artifactsEvery artifact this provider publishes, grouped by type.
get_provider_operationsEvery operation across all of their OpenAPIs — one call instead of parsing every spec.
get_provider_toolsEvery MCP tool they ship, with the operation each wraps.
get_provider_evidenceHow each part of their score was established. Free — the basis for a claim should not sit behind it.
get_provider_ratingPRO — composite, band, trend and facet scores.
apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
resolveTurn a domain, URL or GitHub org into the provider it belongs to.
find_cohortsEvery scored population of providers in the catalog.

All 92 tools

Call it yourself

curl for this page

This provider

curl "https://apis.io/api/v1/providers/microsoft-excel-advanced"

All providers

curl "https://apis.io/api/v1/providers?limit=25"

Every operation they expose

curl "https://apis.io/api/v1/providers/microsoft-excel-advanced/operations?limit=25"

How their score was established

curl "https://apis.io/api/v1/providers/microsoft-excel-advanced/evidence"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no email required.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.