Microsoft 365 Excel API Documentation

This is the complete API documentation for connecting to the Microsoft 365 Excel API using MindCloud's Universal API. If you are new to MindCloud, start with the Introduction to see how one API can sit in front of many different apps.

MindCloud is an integration company that offers one normalized API to access 3,100+ apps from a single place. It cleans up provider-specific quirks, keeps requests and responses consistent, and centralizes authentication so you do not need to manage separate flows for every app. Browse other apps.

Meet Microsoft 365 Excel: Access Microsoft 365 Excel workbook files through Microsoft Graph, including OneDrive-backed workbook, worksheet, and range operations. Keep reading to get started.

Quickstart

Before you run your first Microsoft 365 Excel request, you need three things:

1. A MindCloud account — sign in or create an account at MindCloud.
2. A MindCloud API Key — create one in API Keys. Keep it on your server.
3. At least one Microsoft 365 Excel connection — create or choose one in Connections. Note its connectionId.

Every Microsoft 365 Excel action uses the same URL pattern:

https://connect.mindcloud.co/v1/universal/microsoft365Excel/latest/actions/{actionSlug}

You need a MindCloud API Key and a Microsoft 365 Excel connection. Then call an action such as Get Chart Image:

curl --request GET \
  --url "https://connect.mindcloud.co/v1/universal/microsoft365Excel/latest/actions/get-chart-image" \
  --header "Authorization: Bearer $MINDCLOUD_API_KEY" \
  --get \
  --data-urlencode "connectionId=$CONNECTION_ID"

Every response comes back in the same envelope, with your rows in a data array:

{
  "success": true,
  "data": [
    { "id": "1042", "name": "Ava" }
  ],
  "meta": {}
}

After your first request works, use Shape your requests to control arguments, pagination, filtering, fields, and errors.

Authentication

Authentication has two layers. Your MindCloud API Key authenticates the request to MindCloud, sent as a Bearer token in the Authorization header. The connectionId selects the connected Microsoft 365 Excel account that should run the action. MindCloud stores and refreshes the Microsoft 365 Excel credentials behind that connection, so you never send provider tokens with your requests.

Pass connectionId in the query string for GET and DELETE actions, and in the JSON body for POST, PUT, and PATCH actions. Keep your MindCloud API Key on your server; do not ship it in browser code, mobile apps, public repositories, or logs.

Microsoft 365 Excel actions

All 23 published actions for this Microsoft 365 Excel version. Each page documents the endpoint, arguments, and response controls.

• POSTAdd Chart
• POSTAdd Table Rows
• PUTCalculate Workbook
• PUTClear Range
• POSTCreate Table
• POSTCreate Workbook Session
• POSTCreate Worksheet in Workbook
• DELETEDelete Worksheet
• GETGet Chart Image
• GETGet My Profile
• GETGet Range
• GETGet Used Range
• GETGet Workbook Application
• GETGet Worksheet
• GETList Charts
• GETList Table Rows
• GETList Tables
• GETList Workbook Tables
• GETList Worksheets
• PUTReplace Workbook Contents
• PUTUpdate Range Values
• PUTUpdate Worksheet
• POSTUpload Workbook

Related apps

More apps on the Universal API, behind the same REST shape. Or browse all apps.

Google SheetsGmailSlackGoogle CalendarGoogle DriveNotionHubSpotGoogle Forms