> ## Documentation Index > Fetch the complete documentation index at: https://nango-wari-migrated-bigcommerce-docs.mintlify.site/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. In Nango ([free signup](https://app.nango.dev)), go to [Integrations](https://app.nango.dev/dev/integrations) -> *Configure New Integration* -> *Microsoft Excel (Client Credentials)*. 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. 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): ```bash theme={null} curl "https://api.nango.dev/proxy/v1.0/sites?search=*" \ -H "Authorization: Bearer " \ -H "Provider-Config-Key: " \ -H "Connection-Id: " ``` 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: '' }); const res = await nango.get({ endpoint: '/v1.0/sites', params: { search: '*' }, providerConfigKey: '', connectionId: '' }); console.log(res.data); ``` Or fetch credentials with the [Node SDK](/reference/sdks/node#get-a-connection-with-credentials) or [API](/reference/api/connection/get). ✅ You're connected! Check the [Logs](https://app.nango.dev/dev/logs) tab in Nango to inspect requests. Follow our [Auth implementation guide](/guides/primitives/auth) to integrate Nango in your app. To obtain your own production 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?](/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 & actions for Microsoft Excel (Client Credentials) Enable them in your dashboard. Extend and customize to fit your needs. ### Others | Function name | Description | Type | Source code | | --------------------- | ---------------------------------------------------------------------------------------------- | ---------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------- | | `add-chart` | Create a chart on a worksheet from a data range. | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/add-chart.ts) | | `add-defined-name` | Create a workbook-level defined name (named range or formula). | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/add-defined-name.ts) | | `add-table-rows` | Append one or more rows to a table. | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/add-table-rows.ts) | | `add-table` | Create a table from an existing range. | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/add-table.ts) | | `add-worksheet` | Add a new worksheet to a workbook. | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/add-worksheet.ts) | | `calculate-workbook` | Force recalculation of all formulas in the workbook. | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/calculate-workbook.ts) | | `create-workbook` | Upload a new .xlsx workbook to a drive folder. | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/create-workbook.ts) | | `delete-defined-name` | Delete a workbook-level defined name. | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/delete-defined-name.ts) | | `delete-table` | Delete a table (converts it back to a normal range; does not delete the underlying cell data). | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/delete-table.ts) | | `delete-workbook` | Delete a workbook file. | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/delete-workbook.ts) | | `delete-worksheet` | Delete a worksheet from a workbook. | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/delete-worksheet.ts) | | `get-chart-image` | Render a chart as an image. | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/get-chart-image.ts) | | `get-range` | Read cell values from a specific range on a worksheet. | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/get-range.ts) | | `get-site-drive` | Get the default document library (drive) for a SharePoint site. | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/get-site-drive.ts) | | `get-used-range` | Read all non-empty cells on a worksheet. | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/get-used-range.ts) | | `get-user-drive` | Get a user's personal OneDrive (drive). | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/get-user-drive.ts) | | `get-workbook` | Retrieve driveItem metadata for a workbook. | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/get-workbook.ts) | | `list-defined-names` | List workbook-level defined names. | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/list-defined-names.ts) | | `list-sites` | Search and list SharePoint sites accessible to the app. | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/list-sites.ts) | | `list-table-columns` | List the columns of a table | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/list-table-columns.ts) | | `list-table-rows` | List the data rows of a table. | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/list-table-rows.ts) | | `list-tables` | List tables in a workbook. | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/list-tables.ts) | | `list-users` | List/search tenant users, to resolve a user id for personal OneDrive access. | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/list-users.ts) | | `list-workbooks` | List and search .xlsx files within a drive. | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/list-workbooks.ts) | | `list-worksheets` | List worksheets in a workbook. | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/list-worksheets.ts) | | `update-range` | Write cell values into a specific range on a worksheet | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/update-range.ts) | | `update-worksheet` | Rename a worksheet and/or change its tab position. | [Action](/guides/functions/action-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/actions/update-worksheet.ts) | | `workbooks` | Sync .xlsx files within a drive | [Sync](/guides/functions/syncs/sync-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/syncs/workbooks.ts) | | `worksheets` | Sync the worksheets within a specific workbook. | [Sync](/guides/functions/syncs/sync-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/microsoft-excel-oauth2-cc/syncs/worksheets.ts) | ## 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](/integrations/all/microsoft-excel) 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](/api-integrations/microsoft-excel-oauth2-cc/connect) for common permission names. ***