# Microsoft Excel setup for PopMCP

You register an app in the Microsoft Entra admin center, copy its Application (client) ID and a client secret Value into PopMCP, then sign in with your work or school Microsoft account and approve access to your workbooks.

- Auth: OAuth authorization
- Setup time: 5 min
- API base URL: https://graph.microsoft.com/v1.0
- Credentials screen: https://entra.microsoft.com/#view/Microsoft_AAD_RegisteredApps/ApplicationsListBlade
- Provider docs: https://learn.microsoft.com/en-us/graph/excel-concept-overview

## Approval required before this works

Microsoft reviews nothing: an app you register in the Microsoft Entra admin center can sign in straight away. Your organization is the gate. Workbooks on your own OneDrive need no administrator unless your organization only lets admins approve apps. SharePoint and files shared with me adds Files.Read.All and Files.ReadWrite.All, and since 2025 Microsoft's default consent settings make an administrator approve those once.

- Typical wait: None for workbooks on your own OneDrive. SharePoint and files shared with me waits until a Microsoft 365 administrator approves the app once, unless your organization lets people approve these permissions.
- Cost: Free. Registering an app and the calls PopMCP makes as you cost nothing. It needs a work or school account on Microsoft 365 with a license that includes OneDrive or SharePoint; Microsoft's Excel service does not open workbooks on personal OneDrive.
- Blocked until approved: Only the extra option: Microsoft stops the whole sign-in with Need admin approval while SharePoint and files shared with me waits. Without that option everything works on your own OneDrive.
- Works meanwhile: Register the app, add PopMCP's Redirect URI, create the client secret and connect without SharePoint and files shared with me. Reconnect with it ticked once the admin approves.

## Before you begin

- A work or school Microsoft account on Microsoft 365 with a license that includes OneDrive or SharePoint. Personal Microsoft accounts do not work: Microsoft's Excel service does not open workbooks stored on personal OneDrive.
- Workbooks saved as .xlsx. Older .xls files must be saved as .xlsx first.
- A Microsoft Entra tenant you can register apps in: your organization's (members can register apps unless an admin turned that off, and the Application Developer role always can).
- PopMCP's Redirect URI from the connect form: https://app.popmcp.com/api/providers/microsoft/callback
- Only for workbooks in SharePoint, Teams or someone else's OneDrive: in most organizations an administrator approves the extra permission once. Your own OneDrive needs no administrator by Microsoft's rules.

## Get your credentials

### 1. Open App registrations

Go to entra.microsoft.com and sign in. If you belong to several tenants, use the Settings icon in the top bar to switch to the one that should own the app. Open Entra ID > App registrations and select New registration.

Screen: https://entra.microsoft.com/#view/Microsoft_AAD_RegisteredApps/ApplicationsListBlade

### 2. Register the app

Enter a Name people will recognize, such as `PopMCP`: Microsoft shows it when asking for access. Under Supported account types pick Multiple Entra ID tenants, then select Register. Microsoft's Excel service works only with work or school accounts, so personal accounts are not needed. Single tenant only works too for your own organization, but then the app's Directory (tenant) ID goes into PopMCP as well.

Screen: https://entra.microsoft.com/#view/Microsoft_AAD_RegisteredApps/ApplicationsListBlade

### 3. Add PopMCP's Redirect URI

On the new app, open Authentication under Manage. On the Redirect URI configuration tab select Add Redirect URI, choose the Web tile, enter `https://app.popmcp.com/api/providers/microsoft/callback` exactly as PopMCP shows it, and select Configure.

### 4. Create a client secret

Open Certificates & secrets, stay on Client secrets and select New client secret. Enter a description such as `PopMCP`, choose when it expires (24 months at most; Microsoft recommends less than 12) and select Add. Copy the Value column straight away: Microsoft never shows it again. The Secret ID beside it is not the secret.

### 5. Copy the Application (client) ID

Open Overview and copy the Application (client) ID. You only need the Directory (tenant) ID if you chose Single tenant only.

### 6. Get an administrator's approval (only for SharePoint)

Workbooks on your own OneDrive need no administrator, so skip this step if that is where yours are. SharePoint and files shared with me adds `Files.Read.All` and `Files.ReadWrite.All`, and since 2025 Microsoft's default consent settings make an administrator approve those two in most organizations. An administrator (Global Administrator or Cloud Application Administrator) opens API permissions on the app, selects Add a permission > Microsoft Graph > Delegated permissions, adds both and selects Grant admin consent for the organization.

### 7. Fill in PopMCP and sign in

In PopMCP put the ID in Application (client) ID and the secret's Value in Client secret Value (the Directory (tenant) ID under More options only for a Single tenant only app). For workbooks in SharePoint or Teams, tick SharePoint and files shared with me under More options. Select Sign in with Microsoft, pick your work or school account and select Accept. If Microsoft says Need admin approval, untick that option and sign in again, or ask your administrator first.

## Fields PopMCP asks for

- Application (client) ID (clientId) [required]: Only for your own app. In the Microsoft Entra admin center (entra.microsoft.com) open Entra ID, App registrations, New registration, pick Multiple Entra ID tenants under Supported account types (or Single tenant only, and fill in the Directory (tenant) ID below) and select Register, then copy the Application (client) ID from Overview.
- Client secret Value (clientSecret) [required]: In the app registration open Certificates & secrets, Client secrets, New client secret, then Add, and copy the Value column right away (it is shown once). Stored encrypted and used only on our server.
- Directory (tenant) ID (tenant): Only for an app registered as Single tenant only. Copy it from the app's Overview page.
- Extra access (extraAccess): 

## Callback URL to register

https://app.popmcp.com/api/providers/microsoft/callback

## Scopes requested

- User.Read
- Files.ReadWrite
- offline_access
- openid
- profile
- email

## Verify

PopMCP shows Microsoft Excel as Connected under your sign-in address, and excel_find_workbooks lists your .xlsx files.

## Troubleshooting

### "The app's redirect URI does not match"

Cause: Microsoft answered AADSTS50011: PopMCP's callback is not registered as a Web redirect URI on the app, or differs by a character.

Fix: Open **Authentication**, select **Add Redirect URI**, choose **Web**, enter `https://app.popmcp.com/api/providers/microsoft/callback` and select **Configure**, then connect again.

### "Microsoft did not accept the app's client secret"

Cause: The **Secret ID** was pasted instead of the secret's **Value** (AADSTS7000215), or the Value was cut short when copying.

Fix: Under **Certificates & secrets** create a new client secret, copy its **Value** right away and paste it into PopMCP.

### "The app's client secret has expired"

Cause: Client secrets last at most 24 months (AADSTS7000222).

Fix: Create a new client secret under **Certificates & secrets** and reconnect Microsoft Excel with its Value.

### "Your app is registered for one organization only"

Cause: A Single tenant only app was used without its tenant (AADSTS50194).

Fix: Copy the **Directory (tenant) ID** from the app's **Overview**, enter it under **More options** in PopMCP and connect again.

### "Microsoft Excel works with work or school accounts only"

Cause: You signed in with a personal Microsoft account (Outlook.com, Hotmail, Live). Microsoft's Excel service does not open workbooks on personal OneDrive.

Fix: Connect again and sign in with a work or school account. To read a personal file, the OneDrive connector can return its text.

### "This account has no OneDrive yet"

Cause: A work account's OneDrive does not exist until it is opened once, or the account has no license that includes it.

Fix: Open **office.com** and select **OneDrive** once, then connect again. If your workbooks are only in SharePoint, connect with **SharePoint and files shared with me** ticked.

### Microsoft says **Need admin approval**

Cause: **SharePoint and files shared with me** asks for permissions most organizations reserve for administrators, or your organization lets only admins approve apps.

Fix: Untick that option and connect again for your own OneDrive, or ask an administrator to select **Grant admin consent** on the app.

### "Microsoft could not open this file as a workbook"

Cause: The file is not .xlsx, is damaged, or has a feature Microsoft's Excel service does not support.

Fix: Open it in Excel for the web. Save an old .xls file as .xlsx, then try again.

### "Another person or app has this workbook locked"

Cause: Someone or something is editing the workbook in a way that conflicts with the request.

Fix: Wait a moment and try again. Close other tools that write to the same workbook.

### A workbook in SharePoint is not found

Cause: The connection reaches only your own OneDrive until the extra access is approved.

Fix: Reconnect with **SharePoint and files shared with me** ticked under **More options**, then search again with excel_find_workbooks.

### 429 Too Many Requests

Cause: Microsoft limits requests by how much work they cause in the workbook, and calls sent side by side are the usual reason.

Fix: Wait as long as the answer says, then send one call at a time. For several calls on one workbook, start a session with excel_create_session.

---

Source: https://www.docs.popmcp.com/docs/integrations/microsoft-excel/