Skip to main content

Celonis Product Documentation

Microsoft 365 Excel (Action Flow)


Any references to third-party products or services do not constitute Celonis Product Documentation nor do they create any contractual obligations. This material is for informational purposes only and is subject to change without notice.

Celonis does not warrant the availability, accuracy, reliability, completeness, or usefulness of any information regarding the subject of third-party services or systems.

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

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

Connect Microsoft 365 Excel to Celonis platform

To connect to the Excel app:

  1. Log in to your Celonis platform account, add any Microsoft 365 Excel module Action Flow, and click the Add button next to the Connection field.

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

  3. Click Save.

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

You have successfully connected the app and can now build Action Flows.

Build Microsoft 365 Excel Action Flows

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


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

  • Search Workbooks

  • Download a Workbook


  • Watch Worksheet Rows

  • List Worksheets

  • List Worksheet Rows

  • Add a Worksheet

  • Add a Worksheet Row

  • Update a Worksheet Row

  • Delete a Worksheet Row


  • Watch Table Rows

  • List Tables

  • List Table Rows

  • Get a Table

  • Add a Table

    To use tables, see Add a Table

  • Add a Table Row

  • Add a Table Column

  • Update a Table

  • Update a Table Column

  • Delete a Table


  • Retrieve Data

  • Make an API Call


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


Adds a new table.

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


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.


Select or map the workbook you want to use.


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.



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

  • Add a Table - Files.ReadWrite, Files.Read.All

  • Add a Table Row - Files.ReadWrite, Files.Read.All

  • Add a Worksheet - Files.ReadWrite, Files.Read.All

  • Add a Worksheet Row - Files.ReadWrite, Files.Read.All

  • Add/Update a Worksheet Row (Advanced) - Files.ReadWrite

  • Delete a Table - Files.ReadWrite, Files.Read.All

  • Delete a Worksheet Row - Files.ReadWrite, Files.Read.All

  • Download a Workbook - Files.ReadWrite, Files.Read.All

  • Get a Table - Files.ReadWrite, Files.Read.All

  • List Table Rows - Files.ReadWrite, Files.Read.All

  • List Tables - Files.ReadWrite, Files.Read.All

  • List Worksheet Rows - Files.ReadWrite, Files.Read.All

  • List Worksheets - Files.ReadWrite, Files.Read.All

  • Retrieve Data - Files.ReadWrite, Files.Read.All

  • Search Workbooks - Files.Read.All

  • Update a Table - Files.ReadWrite, Files.Read.All

  • Update a Worksheet Row - Files.ReadWrite, Files.Read.All

  • Watch Workbooks - Files.Read.All

  • Watch Worksheet Rows - Files.ReadWrite, Files.Read.All