Microsoft Excel
Connect to your users' Microsoft Excel accounts
You can find your Microsoft Excel application credentials by visiting your Microsoft Azure Portal.
You'll need the following information to set up your Microsoft Excel app with Paragon Connect:
- Client ID
- Client Secret
- Scopes Requested
Paragon provides a redirect URL to send information to your app. To add the redirect URL to your Microsoft Excel app:
1. Copy the link under "Redirect URL" in your integration settings in Paragon. The Redirect URL is:
https://passport.useparagon.com/oauth
3. Navigate to All Services > App Registrations and select your application.
4. Select Authentication from the sidebar.
5. Under Platform configurations, press the "Add a platform" button.
6. Select the Web platform.
7. Paste the Redirect URL from Step 1 under Redirect URIs.
8. Press the Save button at the top of the page.
Since Microsoft Excel does not automatically provide you with a Client Secret for your application, we'll need to make one. To get your Client Secret:
1. Navigate to Manage > Certificates & secrets in the sidebar.
2. Under Client Secrets, press the + New client secret button.
3. Name your client credentials and select an expiry that works best for your application. Press Add to create your credentials.
4. Copy the displayed Client Secret under the Value column.
Note: You will need to periodically create new and update your Client Secret as they expire for all Microsoft integrations.
1. Select Microsoft Excel from the Integrations Catalog.
2. Under Integrations > Connected Integrations > {YOUR_APP} > Settings, fill out your credentials from the end of Step 1 in their respective sections:
- Client ID: Found under Essentials > Application (client) ID on your Microsoft Azure Portal app page.
- Client Secret:
- 1.
- 2.Navigate to Manage > Certificates & secrets in the sidebar.
- 3.Under Client Secrets, press the + New client secret button.
- 4.Name your client credentials and select an expiry that works best for your application.
- 5.Press Add to create your credentials.
- 6.Copy the displayed Client Secret under the Value column.
- Permissions: Select the scopes you've requested for your application.
Press the blue "Connect" button to save your credentials.
Note: You should only add the scopes you've requested in your application page to Paragon.

Once your users have connected their Microsoft Excel account, you can use the Paragon SDK to access the Microsoft Excel API on behalf of connected users.
Any Microsoft ExcelExcel API endpoints can be accessed with the Paragon SDK as shown in this example:
// You can find your project ID in the Overview tab of any Integration
// Authenticate the user
paragon.authenticate(<ProjectId>, <UserToken>);
// Get Spreadsheet
await paragon.request('excel', '<workbook id>/workbook/worksheets/<worksheet name>', {
method: 'GET'
});
// Query Spreadsheet data
await paragon.request('excel', '[relative URL]', {
method: 'GET'
});
Once your Microsoft Excel account is connected, you use the Microsoft Excel Request step to access any of Microsoft Excel's API endpoints without the authentication piece.
When creating or updating records in Microsoft Excel, you can reference data from previous steps by typing
{{
to invoke the variable menu.Last modified 2mo ago