# Connect Excel with Open Flow

Source: https://openflow.run/en/integrations/excel/

[All integrations](https://openflow.run/en/integrations/)

Provide a workbook, worksheet, and range so the assistant can read data or make the changes you specify.

*   [31 actions](https://openflow.run/en/integrations/excel/#integration-actions)
*   OAuth 2.0
*   Productivity
*   Data & analytics

[Connect Excel](https://console.openflow.run/connections/excel)

20,000 free app calls per month (paid services billed separately)

## What you can do

The connection uses Microsoft Graph to work with Excel workbooks, worksheets, ranges, and tables. It can create XLSX workbooks, read cells, and update data or formatting.

### Read Workbooks and Ranges

Find workbooks, list worksheets, and read selected or used cell ranges.

### Update Cells and Tables

Write values or formulas to ranges, create tables, and add rows.

## Templates using Excel

![Import Excel Contacts to Salesforce workflow in Open Flow](https://openflow.run/template-previews/import-excel-contacts-to-salesforce/light-cover.webp)

Sales

### [Import Excel Contacts to Salesforce](https://openflow.run/en/templates/import-excel-contacts-to-salesforce/)

Find or create Salesforce accounts and upsert workbook contacts by email.

![Email Hacker News Headlines as a Spreadsheet workflow in Open Flow](https://openflow.run/template-previews/email-hacker-news-headlines-as-a-spreadsheet/light-cover.webp)

Productivity

### [Email Hacker News Headlines as a Spreadsheet](https://openflow.run/en/templates/email-hacker-news-headlines-as-a-spreadsheet/)

Email the current Hacker News front-page titles and links in a spreadsheet attachment.

![Search OneDrive for Excel Workbooks workflow in Open Flow](https://openflow.run/template-previews/search-onedrive-for-excel-workbooks/light-cover.webp)

Productivity

### [Search OneDrive for Excel Workbooks](https://openflow.run/en/templates/search-onedrive-for-excel-workbooks/)

Search the current user’s OneDrive for the text .xlsx and return the first page of results.

## All actions

31 actions

### Create Workbook

Create a new .xlsx workbook file and optionally populate worksheets and data.

`excel.create_workbook`

### Search Files

Search workbook files in the current OneDrive drive and return matching drive items.

`excel.search_files`

### List Drive Item Children

List direct child drive items for a folder or the drive root.

`excel.list_drive_item_children`

### Create Session

Create an Excel workbook session for subsequent workbook operations.

`excel.create_session`

### Get Workbook

Read workbook metadata and optionally expand related workbook resources.

`excel.get_workbook`

### List Worksheets

List worksheets in a workbook.

`excel.list_worksheets`

### Get Worksheet

Read a single worksheet by worksheet name or worksheet ID.

`excel.get_worksheet`

### Add Worksheet

Add a new worksheet to a workbook.

`excel.add_worksheet`

### Update Worksheet

Update worksheet metadata such as the name, position, or visibility.

`excel.update_worksheet`

### Delete Worksheet

Delete one worksheet from a workbook.

`excel.delete_worksheet`

### Get Range

Read one worksheet range by A1-style address.

`excel.get_range`

### Get Worksheet Used Range

Read the used range for one worksheet.

`excel.get_worksheet_used_range`

### Update Range

Update one worksheet range with values, formulas, formats, or visibility flags.

`excel.update_range`

### Clear Range

Clear one worksheet range.

`excel.clear_range`

### Insert Range

Insert one worksheet range and shift existing cells to make space.

`excel.insert_range`

### Merge Cells

Merge cells inside one worksheet range.

`excel.merge_cells`

### Sort Range

Apply a Microsoft Graph sort definition to one worksheet range.

`excel.sort_range`

### List Tables

List workbook tables, optionally restricted to one worksheet.

`excel.list_tables`

### Add Table

Create a new workbook table from an address range.

`excel.add_table`

### Update Table

Update table metadata such as the name, style, or header flags.

`excel.update_table`

### Convert Table To Range

Convert a workbook table back into a plain worksheet range.

`excel.convert_table_to_range`

### List Table Rows

List rows for one workbook table.

`excel.list_table_rows`

### Add Table Row

Add one or more rows to a workbook table.

`excel.add_table_row`

### Delete Table Row

Delete one row from a workbook table by row index.

`excel.delete_table_row`

### List Table Columns

List columns for one workbook table.

`excel.list_table_columns`

### Get Table Column

Read one workbook table column by column name or column ID.

`excel.get_table_column`

### Add Table Column

Add one column to a workbook table.

`excel.add_table_column`

### Delete Table Column

Delete one column from a workbook table.

`excel.delete_table_column`

### Apply Table Filter

Apply a Microsoft Graph filter criteria object to one table column.

`excel.apply_table_filter`

### Clear Table Filter

Clear the current Microsoft Graph filter on one table column.

`excel.clear_table_filter`

### Apply Table Sort

Apply a Microsoft Graph sort definition to one workbook table.

`excel.apply_table_sort`

No actions match your search.

## Connect Excel with Open Flow

[Connect Excel](https://console.openflow.run/connections/excel)

20,000 free app calls per month (paid services billed separately)
