> ## Documentation Index
> Fetch the complete documentation index at: https://nango.dev/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Microsoft Excel (Client Credentials)

> Integrate your application with the Microsoft Excel API via Microsoft Graph, using an app-only (client credentials) token

## 🚀 Quickstart

Connect to Microsoft Excel with Nango and see data flow in 2 minutes.

**1. Create the integration**

In Nango ([free signup](https://app.nango.dev)), go to [Integrations](https://app.nango.dev/dev/integrations) -> *Configure New Integration* -> *Microsoft Excel (Client Credentials)*.

**2. Connect Microsoft Excel**

Go to [Connections](https://app.nango.dev/dev/connections) -> *Add Test Connection* -> *Connect*, then enter your **Tenant ID**, **Client ID**, and **Client Secret**. Later, you'll let your users do the same directly from your app.

**3. Call the Microsoft Excel API**

Let's make your first request to the Microsoft Graph API (list SharePoint sites). Replace the placeholders below with your [API key](https://app.nango.dev/dev/environment-settings), [integration ID](https://app.nango.dev/dev/integrations), and [connection ID](https://app.nango.dev/dev/connections):

> [tab] cURL
>
> ```bash theme={null}
> curl "https://api.nango.dev/proxy/v1.0/sites?search=*" \
>   -H "Authorization: Bearer <NANGO-API-KEY>" \
>   -H "Provider-Config-Key: <INTEGRATION-ID>" \
>   -H "Connection-Id: <CONNECTION-ID>"
> ```

> [tab] Node
>
> Install Nango's backend SDK with `npm i @nangohq/node`. Then run:
>
> ```typescript theme={null}
> import { Nango } from '@nangohq/node';
>
> const nango = new Nango({ apiKey: '<NANGO-API-KEY>' });
>
> const res = await nango.get({
>     endpoint: '/v1.0/sites',
>     params: { search: '*' },
>     providerConfigKey: '<INTEGRATION-ID>',
>     connectionId: '<CONNECTION-ID>'
> });
>
> console.log(res.data);
> ```

Or fetch credentials with the [Node SDK](https://nango.dev/docs/reference/backend/backend-sdk/node.md#get-a-connection-with-credentials) or [API](https://nango.dev/docs/reference/backend/http-api/connections/get.md).

✅ You're connected! Check the [Logs](https://app.nango.dev/dev/logs) tab in Nango to inspect requests.

**4. Implement Nango in your app**

Follow our [Auth implementation guide](https://nango.dev/docs/guides/primitives/auth.md) to integrate Nango in your app.

To obtain your own credentials, follow the setup guide linked below.

## 📚 Microsoft Excel (Client Credentials) integration guides

Nango-maintained guides for common use cases.

* [How do I link my account?](https://nango.dev/docs/api-integrations/microsoft-excel-oauth2-cc/connect)
  Connect using an Entra ID app with application permissions and client credentials

Official docs: [Microsoft Graph API for Excel](https://learn.microsoft.com/en-us/graph/api/resources/excel)

## 🧩 Pre-built syncs & tools for Microsoft Excel (Client Credentials)

Explore Nango-provided tools in your dashboard. Extend and customize them to fit your needs.

### Others

| Function name | Description | Type |
| - | - | - |
| `add-chart` | Create a chart on a worksheet from a data range. | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `add-defined-name` | Create a workbook-level defined name (named range or formula). | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `add-table-rows` | Append one or more rows to a table. | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `add-table` | Create a table from an existing range. | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `add-worksheet` | Add a new worksheet to a workbook. | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `calculate-workbook` | Force recalculation of all formulas in the workbook. | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `create-workbook` | Upload a new .xlsx workbook to a drive folder. | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `delete-defined-name` | Delete a workbook-level defined name. | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `delete-table` | Delete a table (converts it back to a normal range; does not delete the underlying cell data). | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `delete-workbook` | Delete a workbook file. | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `delete-worksheet` | Delete a worksheet from a workbook. | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `get-chart-image` | Render a chart as an image. | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `get-range` | Read cell values from a specific range on a worksheet. | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `get-site-drive` | Get the default document library (drive) for a SharePoint site. | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `get-used-range` | Read all non-empty cells on a worksheet. | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `get-user-drive` | Get a user's personal OneDrive (drive). | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `get-workbook` | Retrieve driveItem metadata for a workbook. | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `list-defined-names` | List workbook-level defined names. | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `list-sites` | Search and list SharePoint sites accessible to the app. | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `list-table-columns` | List the columns of a table | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `list-table-rows` | List the data rows of a table. | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `list-tables` | List tables in a workbook. | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `list-users` | List/search tenant users, to resolve a user id for personal OneDrive access. | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `list-workbooks` | List and search .xlsx files within a drive. | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `list-worksheets` | List worksheets in a workbook. | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `update-range` | Write cell values into a specific range on a worksheet | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `update-worksheet` | Rename a worksheet and/or change its tab position. | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `workbooks` | Sync .xlsx files within a drive | [Sync](https://nango.dev/docs/guides/functions/syncs/sync-functions.md) |
| `worksheets` | Sync the worksheets within a specific workbook. | [Sync](https://nango.dev/docs/guides/functions/syncs/sync-functions.md) |

## API gotchas

* With an app-only token there's no signed-in user, so `/me/...` endpoints don't work.
* The Excel workbook API (`/workbook/...` under `/v1.0/sites/{site-id}/drive/items/{fileId}` or `/v1.0/users/{id}/drive/...`) does not support application permissions — Microsoft Graph requires a signed-in user for these endpoints. If you need workbook access (worksheets, ranges, tables), use the [delegated Microsoft Excel integration](https://nango.dev/docs/integrations/all/microsoft-excel.md) instead. This client-credentials integration only works for app-only-compatible Graph endpoints (e.g. site/drive metadata), not workbook content.
* Application permissions (not delegated) must be granted and admin-consented in Entra ID — see the [connect guide](https://nango.dev/docs/api-integrations/microsoft-excel-oauth2-cc/connect) for common permission names.

***


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.