Microsoft Excel icon

Microsoft Excel

Read and write workbook data in Microsoft Excel.

20 searches20 actionsPollingAuth: OAuth

AI-assisted documentation10 min read

This documentation is compiled from our integration source code, internal specs for Microsoft Excel, its official API documentation and anonymized requests logs we collect from our support team[2].

Open Microsoft Excel on WEXTL →

Before you set up the credential, make sure you have an active Microsoft Excel account and OAuth client credentials, granted by signing in with your account ready.[3]

Credential type option 1

Microsoft Excel - Secondary

You’ll be redirected to sign in and approve access — your password is never shared with WEXTL.

  • Microsoft - TenantselectRequired

    Go to https://entra.microsoft.com and copy your tennat ID or select any of the following`

    [1]
  • Microsoft - Client IDtextRequired

    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

    [1]
  • Microsoft - Client SecretpasswordRequired

    Copy you client Secret from the previously created app

    [1]
  • Excel Sheet IDtextRequired

    The workbook's drive item ID: in Graph Explorer run GET /me/drive/root:/path/to/file.xlsx and copy id (starts with 01...).

    [1]
Integration requests 7 permissions:
Files.ReadFiles.Read.AllFiles.ReadWriteFiles.ReadWrite.AllSites.ReadWrite.AllUser.Readoffline_access
Credential type option 2

Microsoft Excel - Primary

You’ll be redirected to sign in and approve access — your password is never shared with WEXTL.

  • Microsoft - TenanttextRequired

    Directory (tenant) ID or verified domain, e.g. contoso.onmicrosoft.com. common/organizations/consumers are not valid for app-only.

    [1]
  • Microsoft - Client IDtextRequired

    Register your application in the Microsoft Entra admin center, then copy the Application (client) ID from the app's Overview page

    [1]
  • Microsoft - Client SecretpasswordRequired

    In your app registration, go to Certificates & secrets → Client secrets, create a new client secret, and copy its value immediately after it's generated.

    [1]
  • Excel Sheet IDtextRequired

    The workbook's drive item ID: in Graph Explorer run GET /me/drive/root:/path/to/file.xlsx and copy id (starts with 01...).

    [1]
  • Email or User IDtextRequired

    Go to Microsoft Entra admin center → Users → select the user → Overview, then copy the Object ID, or enter The email of the user.

    [1]
Integration requests 5 permissions:
Files.ReadFiles.Read.AllFiles.ReadWriteFiles.ReadWrite.AllSites.ReadWrite.All
  1. Log in to your WEXTL account, add the Microsoft Excel node module to your workflow, and click Create new credential.
  2. Optional: In the Credential name field, enter a name for the credential.
  3. Enter the authentication credentials you copied from your Microsoft Excel account, or follow the on-screen instructions to create the credential.
  4. If prompted, authenticate your account and confirm access.
  5. If you want to make changes to your credential in the future, follow the steps in Manage credentials →

Notes

Credentials are org-scoped; share them with teammates from the Credentials picker on any of its nodes.For detailed information on connecting an application, see Connect an application →

List Table ColumnsSearch
Input fields[3]
FieldType
Table ID or NameRequired
choice
Limitnumber
Output fields[3]
FieldType
IDtext
Nametext
Indexnumber
Valuestext
List Table RowsSearch
Input fields[3]
FieldType
Table ID or NameRequired
choice
Limitnumber
Output fields[3]
FieldType
IDtext
Nametext
Positionnumber
Visibilitytext
List TablesSearch
Input fields[3]
FieldType
Limitnumber
Output fields[3]
FieldType
Highlight first columnboolean
Highlight last columnboolean
IDtext
Nametext
Show banded columnsboolean
Show banded rowsboolean
Show filter buttonboolean
Show headersboolean
Show totalsboolean
Styletext
Legacy IDtext
List WorksheetSearch
Input fields[3]
FieldType
Limitnumber
Output fields[3]
FieldType
IDtext
Nametext
Positionnumber
Visibilitytext
List Worksheet NamesSearch
Input fields[3]
FieldType
Worksheet ID or NameRequired
choice
Limitnumber
Output fields[3]
FieldType
Nametext
Commenttext
Scopetext
Typetext
Valueobject
@odata typetext
Visibleboolean
List Worksheet TablesSearch
Input fields[3]
FieldType
Worksheet ID or NameRequired
choice
Limitnumber
Output fields[3]
FieldType
IDtext
Nametext
Show headersboolean
Show totalsboolean
Styletext
Retrieve a Header Row RangeAction
Input fields[3]
FieldType
Table ID or NameRequired
choice
Output fields[3]
FieldType
Addresstext
Address localtext
Cell countnumber
Column countnumber
Column indexnumber
Value typestext
Retrieve a TableAction
Input fields[3]
FieldType
Table ID or NameRequired
choice
Output fields[3]
FieldType
IDtext
Nametext
Show headersboolean
Show totalsboolean
Styletext
Retrieve a Table ColumnAction
Input fields[3]
FieldType
Table ID or NameRequired
choice
Output fields[3]
FieldType
IDtext
Nametext
Indexnumber
Valuestext
Retrieve a Table Column Body RangeAction
Input fields[3]
FieldType
Table ID or NameRequired
choice
Output fields[3]
FieldType
Addresstext
Address localtext
Cell countnumber
Column countnumber
Column indexnumber
Value typestext
Retrieve a Table Column ItemAction
Input fields[3]
FieldType
Table ID or NameRequired
choice
Output fields[3]
FieldType
IDtext
Nametext
Indexnumber
Valuestext
Retrieve a Table Column RangeAction
Input fields[3]
FieldType
Table ID or NameRequired
choice
Output fields[3]
FieldType
Addresstext
Address localtext
Cell countnumber
Column countnumber
Column indexnumber
Value typestext
Retrieve a Table RowAction
Input fields[3]
FieldType
Table ID or NameRequired
choice
Output fields[3]
FieldType
Indexnumber
Valuestext
Retrieve a Table Row ItemAction
Input fields[3]
FieldType
Table ID or NameRequired
choice
Output fields[3]
FieldType
Indexnumber
Valuestext
Retrieve a Table Row RangeAction
Input fields[3]
FieldType
Table ID or NameRequired
choice
Output fields[3]
FieldType
Addresstext
Address localtext
Cell countnumber
Column countnumber
Column indexnumber
Value typestext
Retrieve a Table SortAction
Input fields[3]
FieldType
Table ID or NameRequired
choice
Output fields[3]
FieldType
Match caseboolean
Methodtext
Fieldsarray
Retrieve a Total Row RangeAction
Input fields[3]
FieldType
Table ID or NameRequired
choice
Output fields[3]
FieldType
Addresstext
Address localtext
Cell countnumber
Column countnumber
Column indexnumber
Value typestext
Retrieve a WorksheetAction
Input fields[3]
FieldType
ID or NameRequired
choice
Output fields[3]
FieldType
IDtext
Positionnumber
Nametext
Visibilitytext
Retrieve a Worksheet CellAction
Input fields[3]
FieldType
ID or NameRequired
choice
RowRequired
number
ColumnRequired
number
Output fields[3]
FieldType
Addresstext
Address localtext
Cell countnumber
Column countnumber
Column indexnumber
Value typestext
Retrieve a Worksheet RangeAction
Input fields[3]
FieldType
ID or NameRequired
choice
Output fields[3]
FieldType
Addresstext
Address localtext
Cell countnumber
Column countnumber
Column indexnumber
Value typestext
Add a Table ColumnAction
Input fields[3]
FieldType
Table ID or NameRequired
choice
Output fields[3]
FieldType
IDtext
Nametext
Indexnumber
Valuestext
Add a Table RowAction
Input fields[3]
FieldType
Table ID or NameRequired
choice
Output fields[3]
FieldType
Indexnumber
Valuestext
Apply a Table SortAction
Input fields[3]
FieldType
Table ID or NameRequired
choice
Fieldsarray
Match Caseboolean
Methodchoice
Output fields[3]
FieldType
Match caseboolean
Methodtext
Fieldsarray
Clear a Table SortAction
Input fields[3]
FieldType
Table ID or NameRequired
choice
Close a Workbook SessionAction

No fields documented.

Create a TableAction
Input fields[3]
FieldType
AddressRequired
text
Has HeadersRequired
boolean
Output fields[3]
FieldType
IDtext
Nametext
Show headersboolean
Show totalsboolean
Styletext
Create a Workbook SessionAction
Input fields[3]
FieldType
Persist Changesboolean
Output fields[3]
FieldType
IDtext
Persist changesboolean
Create a WorksheetAction
Input fields[3]
FieldType
Worksheet NameRequired
text
Output fields[3]
FieldType
IDtext
Positionnumber
Nametext
Visibilitytext
Create a Worksheet TableAction
Input fields[3]
FieldType
ID or NameRequired
choice
Addresstext
Has Headersboolean
Output fields[3]
FieldType
IDtext
Nametext
Show headersboolean
Show totalsboolean
Styletext
Delete a TableAction
Input fields[3]
FieldType
Table ID or NameRequired
choice
Delete a Table ColumnAction
Input fields[3]
FieldType
Table ID or NameRequired
choice
Delete a Table RowAction
Input fields[3]
FieldType
Table ID or NameRequired
choice
Delete a WorksheetAction
Input fields[3]
FieldType
ID or NameRequired
choice
Make an API Calluniversal
Input fields[3]
FieldType
MethodRequired
choice
Headersarray
Headerobject
Query Stringarray
Parameterobject
Bodytext
Output fields[3]
FieldType
Bodytext
Headersobject
Status codenumber
Re-Apply a Table SortAction
Input fields[3]
FieldType
Table ID or NameRequired
choice
Output fields[3]
FieldType
Match caseboolean
Methodtext
Fieldsarray
Refresh a Workbook SessionAction

No fields documented.

Update a TableAction
Input fields[3]
FieldType
Table ID or NameRequired
choice
Table Nametext
Show Headersboolean
Show Totalsboolean
Table Stylechoice
Output fields[3]
FieldType
IDtext
Nametext
Show headersboolean
Show totalsboolean
Styletext
Update a Table ColumnAction
Input fields[3]
FieldType
Table ID or NameRequired
choice
Output fields[3]
FieldType
IDtext
Nametext
Indexnumber
Valuestext
Update a Table RowAction
Input fields[3]
FieldType
Table ID or NameRequired
choice
Output fields[3]
FieldType
Indexnumber
Valuestext
Update a WorksheetAction
Input fields[3]
FieldType
ID or NameRequired
choice
Visibilitychoice
Nametext
Positionnumber
Output fields[3]
FieldType
IDtext
Positionnumber
Nametext
Visibilitytext

Look for Microsoft Excel templates in the WEXTL template library.

Browse templates →
  1. WEXTL® Microsoft Excel Source Code connector implementation.
  2. Our users use cases and automations.
  3. Official API Documentation for Microsoft Excel.
  4. WEXTL® visual workflow builder data.

Last updated: Aug 15, 2026 01:41