Articles in this section

Set up a connection to Microsoft Excel Online

Tanisha Ray
Updated

Microsoft Excel Online is a free, web-based version of Microsoft Excel that you can use in your web browser. It allows you to create and edit Excel spreadsheets online, and includes many of the same features as the desktop version of Excel. With Excel Online, you can create and edit spreadsheets, perform calculations, and create charts and graphs, all within your web browser.

Set up a connection

This video demonstrates creating a Microsoft Excel Online connection.

After you start the connection , configure it in the Create connection panel and complete all of the required * authentication settings:

Setting

Instructions

Name your connection * 

Enter a clear and distinguishable name.

Throughout integrator.io imports and exports, you will have the option to choose this new connection. A unique identifier will prove helpful later when selecting it from a list of the connections in your account.

Tenant ID * 

Enter your Microsoft Excel Online account tenant ID.

Fetch data {//theme.zdassets.com/theme_assets/1098969/5157503509223f89f9b3e7578d2ca78ce882fc18.svg}How to retrieve tenant ID  

OAuth 2.0 client * 

Select the OAuth 2.0 client that stores the client ID and client secret provided to you by Microsoft Excel Online.

To add an OAuth 2.0 client and configure your credentials, click the plus ( + ) button. Click the edit ( edit.svg ) button to modify a selected OAuth 2.0 client. For more information, see  Create an OAuth 2.0 iClient resource

Fetch data {//theme.zdassets.com/theme_assets/1098969/5157503509223f89f9b3e7578d2ca78ce882fc18.svg}How to retrieve client ID and client secret 

Scopes * 

Scopes are OAuth 2.0 permissions that Microsoft Excel Online defines to limit access to your account.

Fetch data {//theme.zdassets.com/theme_assets/1098969/5157503509223f89f9b3e7578d2ca78ce882fc18.svg}How to configure scopes 

Tip

This connector documentation describes only the settings shown for the Simple view. For the corresponding HTTP settings, see  OAuth 2.0 auth universal connector documentation.

How to retrieve tenant ID

 

  1. Sign in to your Azure portal.

  2. Navigate to Azure services > App registrations.

  3. Select the application which you will be using for Microsoft Excel Online.

  4. Navigate to the Overview tab.

  5. Copy Directory (tenant) ID .

tenant id.png

How to retrieve the client ID and client secret

 

  1. Sign in to your Azure portal.

  2. Navigate to Azure services > App registrations .

  3. Select the application you will be using for Microsoft Power Automate.

  4. Copy Application (client) ID.

  5. Navigate to Certificates and secrets.

  6. Click on New client secret.

  7. Give a secret description and expiry duration and click Add.

  8. Copy Client secret.

    Note

    Your client secret will be visible under the Value section.

How to configure scopes

 

  1. Click Scope.

  2. To access all of the scopes in the API, click the » button.

    – or – 

    Check the scopes you want to add and click the > button.

  3. Click Save.

Additional references