Email and docs

Put your super employee to work in Excel

Reads and updates your workbooks, adds rows to tables and starts work when a row changes.

What it can do in Excel

Every tool your super employee can use there, straight from the product.

It makes these when a job calls for them. You can set any of them to ask you first.

Update Excel Range Write rows of values or formulas into a worksheet, starting at one cell.
Append Excel Table Rows Add rows to the end of a table by column name.
Update Excel Table Row Change some columns of one table row.
Delete Excel Table Row Delete one row from a table; the rows below it move up.
Create Excel Table Turn a worksheet range into a table, so its rows can be read, added and changed by column name.
Add Excel Worksheet Add a worksheet (tab) to a workbook.

Show 1 more

Create Excel Workbook Create a new, empty Excel workbook in OneDrive. A file of that name already there fails.

It checks these whenever a job needs them.

Search Excel Workbooks Find Excel workbooks in your OneDrive and the ones shared with you by words in their name or content. Pass nextLink to continue.
Get Excel Workbook List a workbook's worksheets and the tables on each.
Read Excel Range Read the cells of a worksheet range, or of everything the sheet uses.
Read Excel Table Rows Read a table's rows as objects keyed by its column names.