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.
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.
|
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 (
|
Scopes * |
Scopes are OAuth 2.0 permissions that Microsoft Excel Online defines to limit access to your account.
|
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.
-
Sign in to your Azure portal.
-
Navigate to Azure services > App registrations.
-
Select the application which you will be using for Microsoft Excel Online.
-
Navigate to the Overview tab.
-
Copy Directory (tenant) ID .
-
Sign in to your Azure portal.
-
Navigate to Azure services > App registrations .
-
Select the application you will be using for Microsoft Power Automate.
-
Copy Application (client) ID.
-
Navigate to Certificates and secrets.
-
Click on New client secret.
-
Give a secret description and expiry duration and click Add.
-
Copy Client secret.
Note
Your client secret will be visible under the Value section.
-
Click Scope.
-
To access all of the scopes in the API, click the » button.
– or –
Check the scopes you want to add and click the > button.
-
Click Save.