How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Microsoft Excel Tables API

Operations for managing tables within worksheets.

Microsoft Excel Tables API is one of 11 APIs that Microsoft Excel publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

This API exposes 8 JSON Schema definitions.

Tagged areas include Tables. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, authentication docs, an API reference, a JSON-LD context, and 8 JSON Schemas.

This API exposes 5 operations across 5 paths, and defines 3 schemas. It is described by OpenAPI 3.2.0, at version 1.0.0.

Requests are made against a single base URL, https://graph.microsoft.com/v1.0.

5 operations 5 paths 3 schemas 1 GET1 PATCH3 POST

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.2.0
API Version
1.0.0
Base URL
https://graph.microsoft.com/v1.0
Authentication
OAuth 2.0
Resource Areas
1

Authentication & Security 1

Microsoft Excel Tables API declares 1 security scheme for authenticating requests. It supports OAuth 2.0 (oauth2) using the authorizationCode flow, exposing 2 scopes. By default, every request must be authenticated.

  • oauth2 — OAuth 2.0 authorization using Microsoft Identity Platform

Paths & Operations 5

Across 5 paths, the API surfaces 5 operations — 1 GET, 1 PATCH, 3 POST. Each is listed below with its method, path, parameters, and response codes.

Tables 5

Operations for managing tables within worksheets.

GET
/me/drive/items/{item-id}/workbook/worksheets/{worksheet-id-or-name}/tables
Microsoft Excel List Tables
listTables 3 params → 200401404
PATCH
/me/drive/items/{item-id}/workbook/tables/{table-id}
Microsoft Excel Update Table
updateTable 3 params body → 200400401404
POST
/me/drive/items/{item-id}/workbook/tables/{table-id}/convertToRange
Microsoft Excel Convert Table to Range
convertTableToRange 3 params → 200401404
POST
/me/drive/items/{item-id}/workbook/worksheets/{worksheet-id-or-name}/tables/{table-id}/sort/apply
Microsoft Excel Sort Table
sortTable 4 params body → 204401
POST
/me/drive/items/{item-id}/workbook/worksheets/{worksheet-id-or-name}/tables/{table-id}/columns({column-id})/filter/apply
Microsoft Excel Apply Table Filter
applyTableFilter 5 params body → 204401

Schemas 3

The contract defines 3 schemas that model the data the API accepts and returns. The most detailed are Range (13 properties), Table (5 properties), TableCollection (1 property). Each schema is shown below with its type and property counts.

Range
object
Represents a cell range in a worksheet.
13 properties
TableCollection
object
Collection of tables.
1 property
Table
object
Represents an Excel table.
5 properties

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

microsoft-excel-tables-api-openapi.yml Raw ↑

Other APIs Microsoft Excel publishes across the network.

Excel JavaScript API
Office Scripts API
Microsoft Excel Charts API
Microsoft Excel Functions API
Microsoft Excel Named Items API
Microsoft Excel Ranges API
Microsoft Excel Sessions API
Microsoft Excel Table Columns API
Microsoft Excel Table Rows API
Microsoft Excel Worksheets API
Where this information came from

This is an independent, third-party profile of Microsoft Excel Tables API, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.

The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.

Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.

info@apievangelist.com · Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.