Microsoft Excel

Microsoft Excel is the world’s most popular spreadsheet tool for organizing, analyzing, and visualizing data. The Microsoft Excel integration enables you to programmatically read from and write to Excel workbooks as part of your automation workflows, with easy selection of sheets and cell ranges.

With Microsoft Excel integration, you can:

• Read data from specific sheets: Extract table data, lists, records, or custom ranges from any sheet in your Excel files for use in downstream workflow steps.
• Write and update data: Programmatically update cells, insert new rows, or modify existing records in chosen sheets, without ever opening the file manually.
• Select cell ranges: Specify exact ranges (e.g., A1:D10) to target for read and write operations, allowing fine-grained data manipulation.
• Automate calculations and reporting: Pull in live data, perform calculations, and produce custom Excel reports automatically.
• Centralize spreadsheet tasks: Remove manual copy-pasting—the workflow can update Excel files, capture new submissions, or sync data between systems.
• Integrate seamlessly with Microsoft 365: Access and modify cloud-hosted spreadsheets, whether for finance, sales, operations, or analytics.

Excel’s integration empowers every type of user—from analysts to managers—to automate their data collection, enrich reporting, trigger actions from sheet updates, and keep important data always up-to-date.

Connect Microsoft Excel to your automations to streamline data management, reporting, and collaboration within your workflows.

Usage Instructions

Integrate Microsoft Excel into the workflow with explicit sheet selection. Can read and write data in specific sheets.

Actions

microsoft_excel_read

Read data from a specific sheet in a Microsoft Excel spreadsheet

Input

Output

microsoft_excel_write

Write data to a specific sheet in a Microsoft Excel spreadsheet

Input

Output

microsoft_excel_clear_range

Clear the values and/or formatting of a range in a Microsoft Excel worksheet

Input

Output

microsoft_excel_format_range

Apply fill color and/or font formatting to a range in a Microsoft Excel worksheet

Input

Output

microsoft_excel_create_table

Create a new table over a range of cells in a Microsoft Excel workbook

Input

Output

microsoft_excel_delete_worksheet

Delete a worksheet (sheet) from a Microsoft Excel workbook

Input

Output

microsoft_excel_sort_range

Sort a range or table by a column in a Microsoft Excel worksheet

Input

Output