Skip to main content

Microsoft 365 Excel

The Microsoft 365 Excel modules enable you to monitor workbooks and rows or retrieve, add, update, or delete worksheets, rows, and tables in your Microsoft 365 Excel account.

To get started with Microsoft 365 Excel app, create an account at office.com.

Refer to the Microsoft Graph REST API documentation for the list of available endpoints.

Connect Microsoft 365 Excel to Make

To connect to the Excel app:

  1. Log in to your Make account, add any Microsoft 365 Excel module scenario, and click the Add button next to the Connection field.

    microsoft-excel-1.png

  2. Optional: In the Connection name field, enter a name in the connection.

  3. Optional: Click Show advanced settings to enter your custom app client credentials and add additional scopes as needed.

    For more information about the permissions, see the Microsoft Graph permissions reference.

  4. Click Save.

  5. If prompted, log in to your Microsoft account and confirm the access.

You have successfully connected the app and can now build scenarios.

Build Microsoft 365 Excel Scenarios

After connecting the app, you can perform the following actions:

Workbook

Keyword Query Language

Use Keyword Query Language (KQL) search syntax to build your search queries in Microsoft modules. For more information, see Microsoft Graph help.

  • Watch Workbooks

    Required Permissions: offline_access, User.Read, Files.Read.All

  • Search Workbooks

    Required Permissions: offline_access, User.Read, Files.Read.All

  • Download a Workbook

    Required Permissions: offline_access, User.Read, Files.ReadWrite, Files.Read.All

Worksheet

  • Watch Worksheet Rows

    Required Permissions: offline_access, User.Read, Files.ReadWrite, Files.Read.All

  • List Worksheets

    Required Permissions: offline_access, User.Read, Files.ReadWrite, Files.Read.All

  • List Worksheet Rows

    Required Permissions: offline_access, User.Read, Files.ReadWrite, Files.Read.All

  • Add a Worksheet

    Required Permissions: offline_access, User.Read, Files.ReadWrite, Files.Read.All

  • Add a Worksheet Row

    Required Permissions: offline_access, User.Read, Files.ReadWrite, Files.Read.All

  • Update a Worksheet Row

    Required Permissions: offline_access, User.Read, Files.ReadWrite, Files.Read.All

  • Delete a Worksheet Row

    Required Permissions: offline_access, User.Read, Files.ReadWrite, Files.Read.All

Table

  • Watch Table Rows

    Required Permissions: offline_access, User.Read, Files.ReadWrite, Files.Read.All

  • List Tables

    Required Permissions: offline_access, User.Read, Files.ReadWrite, Files.Read.All

  • List Table Rows

    Required Permissions: offline_access, User.Read, Files.ReadWrite, Files.Read.All

  • Get a Table

    Required Permissions: offline_access, User.Read, Files.ReadWrite, Files.Read.All

  • Add a Table

    To use tables, see Add a Table

  • Add a Table Row

    Required Permissions: offline_access, User.Read, Files.ReadWrite, Files.Read.All

  • Add a Table Column

    Required Permissions: offline_access, User.Read, Files.ReadWrite, Files.Read.All

  • Update a Table

    Required Permissions: offline_access, User.Read, Files.ReadWrite, Files.Read.All

  • Update a Table Column

    Required Permissions: offline_access, User.Read, Files.ReadWrite, Files.Read.All

  • Delete a Table

    Required Permissions: offline_access, User.Read, Files.ReadWrite, Files.Read.All

Other

Note

When using these modules in the Microsoft 365 Excel integration, there is a maximum limit of 3300 records per request. This limit is set to prevent service interruptions and ensure optimal performance during data retrieval operations.

  • Retrieve Data

    Required Permissions: offline_access, User.Read, Files.ReadWrite, Files.Read.All

  • Make an API Call

    Required Permissions: offline_access, User.Read

Table

The table here refers to the embedded table element in the Workbook. Not the entire table (workbook/worksheet).

61d6a5c5dee7b.png

Add a Table

Adds a new table.

Required Permissions: Files.ReadWrite, Files.Read.All

Connection

Establish a connection to your Microsoft 365 account.

Update a Table

Select the option to choose the

Workbook ID

Enter the Workbook ID to whose worksheet you want to add a table.

Workbook

Select or map the workbook you want to use.

Worksheet

Select the Excel sheet you want to add a table to.

Has Headers

If you select this checkbox, the first defined row will be used as the table headers.

61d6a5c6eb16c.png

Address

Set the size of the table. For example, A1:C10 will create a table with 3 columns and 10 rows.

In this section: