About this integration
Read and write workbook data in Microsoft Excel. This integration exposes its full API as workflow modules.
The integration includes 0 triggers, 20 search modules and 20 actions. Connections use oauth or oauth authentication.
How to connect
The credential form asks for Microsoft - Tenant, Microsoft - Client ID, Microsoft - Client Secret, and Excel Sheet ID.
OAuth asks you to approve Files.Read, Files.Read.All, and Files.ReadWrite before access is granted.
You’ll be redirected to sign in and approve access — your password is never shared with WEXTL.
| Field | Type | Help |
|---|---|---|
Microsoft - TenantRequired | select | Go to |
Microsoft - Client IDRequired | text | Go to the Microsoft Entra admin center → Entra ID → App registrations and select New registration. → enter a description and expiration → Add, then immediately copy your Client ID |
Microsoft - Client SecretRequired | password | Copy you client Secret from the previously created app |
Excel Sheet IDRequired | text | Open your Excel workbook in your browser. In the address bar, locate the 'docId' parameter in the URL (for example, 'docId=123456789'). Copy and paste the value after 'docId=' into this field. |
- Files.Read
- Files.Read.All
- Files.ReadWrite
- Files.ReadWrite.All
- Sites.ReadWrite.All
You’ll be redirected to sign in and approve access — your password is never shared with WEXTL.
| Field | Type | Help |
|---|---|---|
Microsoft - TenantRequired | select | Go to |
Microsoft - Client IDRequired | text | Register your application in the Microsoft Entra admin center, then copy the Application (client) ID from the app's Overview page |
Microsoft - Client SecretRequired | password | In your app registration, go to Certificates & secrets → Client secrets, create a new client secret, and copy its value immediately after it's generated. |
Excel Sheet IDRequired | text | Open your Excel workbook in your browser. In the address bar, locate the 'docId' parameter in the URL (for example, 'docId=123456789'). Copy and paste the value after 'docId=' into this field. |
Email or User IDRequired | text | Go to Microsoft Entra admin center → Users → select the user → Overview, then copy the Object ID, or enter The email of the user. |
- Files.Read
- Files.Read.All
- Files.ReadWrite
- Files.ReadWrite.All
- Sites.ReadWrite.All
Use it in workflow automation
Add Add a Table Column as a workflow step.
Triggers, searches and actions
Browse every Microsoft Excel module field below: 0 triggers, 20 searchs, and 20 actions you can drop onto the canvas.
Searches
Use any of 20 search modules to retrieve records without leaving the workflow canvas.
- List Table Columns
- List Table Rows
- List Tables
- List Worksheet
- List Worksheet Names
Actions
This integration includes 20 action modules — create, update, or delete records as part of any workflow.
- Add a Table Column
- Add a Table Row
- Apply a Table Sort
- Clear a Table Sort
- Close a Workbook Session
Explore the fields available for each Microsoft Excel trigger, search, and action.
Searches
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
Limit | number |
| Field | Type |
|---|---|
ID | text |
Name | text |
Index | number |
Values | text |
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
Limit | number |
| Field | Type |
|---|---|
ID | text |
Name | text |
Position | number |
Visibility | text |
| Field | Type |
|---|---|
Limit | number |
| Field | Type |
|---|---|
Highlight first column | boolean |
Highlight last column | boolean |
ID | text |
Name | text |
Show banded columns | boolean |
Show banded rows | boolean |
Show filter button | boolean |
Show headers | boolean |
Show totals | boolean |
Style | text |
Legacy ID | text |
| Field | Type |
|---|---|
Limit | number |
| Field | Type |
|---|---|
ID | text |
Name | text |
Position | number |
Visibility | text |
| Field | Type |
|---|---|
Worksheet ID or NameRequired | choice |
Limit | number |
| Field | Type |
|---|---|
Name | text |
Comment | text |
Scope | text |
Type | text |
Value | object |
@odata type | text |
Visible | boolean |
| Field | Type |
|---|---|
Worksheet ID or NameRequired | choice |
Limit | number |
| Field | Type |
|---|---|
ID | text |
Name | text |
Show headers | boolean |
Show totals | boolean |
Style | text |
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
| Field | Type |
|---|---|
Address | text |
Address local | text |
Cell count | number |
Column count | number |
Column index | number |
Value types | text |
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
| Field | Type |
|---|---|
ID | text |
Name | text |
Show headers | boolean |
Show totals | boolean |
Style | text |
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
| Field | Type |
|---|---|
ID | text |
Name | text |
Index | number |
Values | text |
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
| Field | Type |
|---|---|
Address | text |
Address local | text |
Cell count | number |
Column count | number |
Column index | number |
Value types | text |
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
| Field | Type |
|---|---|
ID | text |
Name | text |
Index | number |
Values | text |
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
| Field | Type |
|---|---|
Address | text |
Address local | text |
Cell count | number |
Column count | number |
Column index | number |
Value types | text |
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
| Field | Type |
|---|---|
Index | number |
Values | text |
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
| Field | Type |
|---|---|
Index | number |
Values | text |
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
| Field | Type |
|---|---|
Address | text |
Address local | text |
Cell count | number |
Column count | number |
Column index | number |
Value types | text |
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
| Field | Type |
|---|---|
Match case | boolean |
Method | text |
Fields | array |
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
| Field | Type |
|---|---|
Address | text |
Address local | text |
Cell count | number |
Column count | number |
Column index | number |
Value types | text |
| Field | Type |
|---|---|
ID or NameRequired | choice |
| Field | Type |
|---|---|
ID | text |
Position | number |
Name | text |
Visibility | text |
| Field | Type |
|---|---|
ID or NameRequired | choice |
RowRequired | number |
ColumnRequired | number |
| Field | Type |
|---|---|
Address | text |
Address local | text |
Cell count | number |
Column count | number |
Column index | number |
Value types | text |
| Field | Type |
|---|---|
ID or NameRequired | choice |
| Field | Type |
|---|---|
Address | text |
Address local | text |
Cell count | number |
Column count | number |
Column index | number |
Value types | text |
Actions
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
| Field | Type |
|---|---|
ID | text |
Name | text |
Index | number |
Values | text |
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
| Field | Type |
|---|---|
Index | number |
Values | text |
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
Fields | array |
Match Case | boolean |
Method | choice |
| Field | Type |
|---|---|
Match case | boolean |
Method | text |
Fields | array |
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
No fields documented.
| Field | Type |
|---|---|
AddressRequired | text |
Has HeadersRequired | boolean |
| Field | Type |
|---|---|
ID | text |
Name | text |
Show headers | boolean |
Show totals | boolean |
Style | text |
| Field | Type |
|---|---|
Persist Changes | boolean |
| Field | Type |
|---|---|
ID | text |
Persist changes | boolean |
| Field | Type |
|---|---|
Worksheet NameRequired | text |
| Field | Type |
|---|---|
ID | text |
Position | number |
Name | text |
Visibility | text |
| Field | Type |
|---|---|
ID or NameRequired | choice |
Address | text |
Has Headers | boolean |
| Field | Type |
|---|---|
ID | text |
Name | text |
Show headers | boolean |
Show totals | boolean |
Style | text |
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
| Field | Type |
|---|---|
ID or NameRequired | choice |
| Field | Type |
|---|---|
MethodRequired | choice |
Headers | array |
Header | object |
Query String | array |
Parameter | object |
Body | text |
| Field | Type |
|---|---|
Body | text |
Headers | object |
Status code | number |
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
| Field | Type |
|---|---|
Match case | boolean |
Method | text |
Fields | array |
No fields documented.
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
Table Name | text |
Show Headers | boolean |
Show Totals | boolean |
Table Style | choice |
| Field | Type |
|---|---|
ID | text |
Name | text |
Show headers | boolean |
Show totals | boolean |
Style | text |
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
| Field | Type |
|---|---|
ID | text |
Name | text |
Index | number |
Values | text |
| Field | Type |
|---|---|
Table ID or NameRequired | choice |
| Field | Type |
|---|---|
Index | number |
Values | text |
| Field | Type |
|---|---|
ID or NameRequired | choice |
Visibility | choice |
Name | text |
Position | number |
| Field | Type |
|---|---|
ID | text |
Position | number |
Name | text |
Visibility | text |