Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

API Docs

Automation Platforms

Triggers

New Row

Triggers when a new row is added to a worksheet in a spreadsheet.

Zapier

New Row in Table

Triggers when a new row is added to a table in a spreadsheet.

Zapier

New Worksheet

Triggers when a new worksheet is added to a spreadsheet.

Zapier

Updated Row

Triggers when a row is added or updated in a worksheet.

Zapier

Watch Table Rows

Triggers when a new row is added to a table.

Make

Watch Workbooks

Triggers when a workbook is created.

Make

Watch Worksheet Rows

Triggers when a new row is added to a worksheet.

Make

Actions

Add Row

Adds a new row to the end of a worksheet.

Zapier

Add Row to Table

Adds a new row to the end of a specific table.

Zapier

Create Spreadsheet

Creates a new spreadsheet

Zapier

Find or Create Row

Finds or creates a specific find row.

Zapier

Update Row

Updates a row in a specific worksheet.

Zapier

Add a Table

Adds a new table.

Make

Add a Table Column

Adds a new table column.

Make

Add a Table Row

Adds a new table row.

Make

Add a Worksheet

Adds a new worksheet to a workbook.

Make

Add a Worksheet Row

Adds a new worksheet row.

Make

Delete a Table

Deletes a table.

Make

Delete a Worksheet Row

Deletes a worksheet row.

Make

Download a Workbook

Downloads the content of a specified Excel workbook.

Make

Get a Table

Gets the metadata of a specified table.

Make

Make an API Call

Performs an arbitrary authorized API call.

Make

Update a Table

Updates an existing table.

Make

Update a Table Column

Updates an existing table column.

Make

Update a Worksheet Row

Updates an existing worksheet row.

Make

Add a table

Add a table in Microsoft Excel

Workato

Add a worksheet

Add a worksheet in Microsoft Excel

Workato

Add rows in batch

Add rows in batch in Microsoft Excel

Workato

Custom action

Custom action in Excel (Custom)

Workato

Delete a row

Delete a row in Microsoft Excel

Workato

Get cells

Get cells from range in Microsoft Excel

Workato

Get rows

Get rows from table in Microsoft Excel

Workato

List tables

List tables in Microsoft Excel

Workato

List worksheets

List worksheets in Microsoft Excel

Workato

Search workbooks

Search workbooks in Microsoft Excel

Workato

Update a row

Update row in Microsoft Excel

Workato

Add a key column to a table

Add a key column to an Excel table. The new column will be appended to the right. The new key column must be unique in the table.

Power Automate

Add a row into a table

Add a new row into the Excel table.

Power Automate

Add a row into a table [DEPRECATED]

This action has been deprecated. Please use Add a row into a table instead. Add a new row into the Excel table.

Power Automate

Create table

Create a new table in the Excel workbook.

Power Automate

Create worksheet

Create a new worksheet in the Excel workbook.

Power Automate

Delete a row

Delete a row using a key column.

Power Automate

Get a row

Get a row using a key column. This action will retrieve all the values of the specified row given a column and key column.

Power Automate

Get tables

Get a list of tables in the Excel workbook.

Power Automate

Get worksheets

Get a list of worksheets in the Excel workbook.

Power Automate

List rows present in a table

List rows present in a table.

Power Automate

Update a row

Update a row using a key column. The input value will overwrite the specified cells and columns left blank will not be updated. In order to append (instead of overwrite) a value, use the "Get a row" action to retrieve the content first.

Power Automate

Searches

Find Row

Finds a row by a column and value. Returns the entire row if one is found.

Zapier

List Table Rows

Retrieves a list of all table rows in a workbook.

Make

List Tables

Retrieves a list of all table objects.

Make

List Worksheet Rows

Retrieves a list of worksheet rows.

Make

List Worksheets

Retrieves a list of worksheet objects.

Make

Retrieve Data

Retrieves data for a given range.

Make

Search Workbooks

Searches for Excel workbooks.

Make