Connect Excel to Your AI Agent

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

31 tools OAuth

Try a Excel Task

Copy a prompt into your agent with the oo Skill installed. Add your page links and source notes before running it.

oo Skill Excel

Analyze a Worksheet Range

Read a selected range and summarize its data using the column meanings.

/oo Excel: Read Excel workbook [item ID] in [drive ID], worksheet [name], range A1:F100. Summarize [analysis question] using the headers and identify missing values.

Add Rows to a Table

Insert supplied row values into an existing Excel table.

/oo Excel: Add these rows [values in column order] to table [table name or ID] in Excel workbook [item ID], drive [drive ID]. Append them after existing rows.

Update a Selected Range

Write values to specific cells in your workbook.

/oo Excel: Set worksheet [name], range D2:D4 in Excel workbook [item ID] to [three status values]. Keep other cells unchanged.

Add Calculation Formulas

Write formulas into the cells where you need calculations.

/oo Excel: In Excel workbook [item ID], worksheet [name], set E2:E10 to formulas multiplying the B and D values in each row.

Start Working with Excel

  1. Install OOMOL

    Set up oo CLI and the oo Skill in your agent.

    Install OOMOL →
  2. Connect Excel

    Authorize your Microsoft account to access Excel files.

    Connect Excel →
  3. Give Your Agent a Task

    Use /oo with the pages to read, the changes to make, and where to save the result.

    Connection Guide →

Choose Your Agent

  • Access to the workbook in OneDrive or a specified drive, with edit access for writes.
  • Identify the workbook drive item, worksheet, and exact range. Workbook sessions can persist changes or keep them temporary.

Excel Tools

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.

31 tools

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

Frequently Asked Questions

What do I provide for a cell task?

Provide the workbook item ID, drive if needed, worksheet name or ID, and an A1-style range such as A1:F100.

Can I write formulas?

Yes. Range updates support values and formulas. Explain which cells should contain formulas and which should contain plain values.

Can I experiment without saving changes?

Create a non-persistent workbook session and use it for subsequent operations when you want changes to remain temporary.

Connect Excel

About Excel ↗