Microsoft Excel (Client Credentials)

🚀 Quickstart

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

Create the integration

In Nango (free signup), go to Integrations -> Configure New Integration -> Microsoft Excel (Client Credentials).

Connect Microsoft Excel

Go to 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.

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, integration ID, and connection ID:

cURL
Node

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>"

Install Nango’s backend SDK with npm i @nangohq/node. Then run:

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 or API.✅ You’re connected! Check the Logs tab in Nango to inspect requests.

Implement Nango in your app

Follow our Auth implementation guide to integrate Nango in your app.To obtain your own production credentials, follow the setup guide linked below.

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 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 for common permission names.

Overview

800+ APIs & Integrations

Microsoft Excel (Client Credentials)

🚀 Quickstart