> This page is for Workforce.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://docs.merge.dev/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.merge.dev/_mcp/server.

# Microsoft Excel

**Authentication:** OAuth or access token. See [Magic Link](/merge-agent-handler/features/magic-link) for the runtime auth flow, or [Application credentials](/merge-agent-handler/admin-setup/add-oauth-credentials) to bring your own OAuth app.

## Sample use cases

* Read the `Pipeline` worksheet from a shared workbook and total deal value by stage.
* Append this week's signups to the `Growth Metrics` workbook in SharePoint.
* Update the forecast tab with the latest actuals and recalculate variance.

## Available Tools

#### list_charts

List charts in a worksheet

#### add_chart

Add a chart to a worksheet from a data range

#### get_chart_image

Get a base64-encoded PNG image of a chart

#### list_named_items

List named items (named ranges and constants) defined in a workbook

#### get_named_item

Get a single named item by name

#### get_range

Get a cell range's values, text, and formulas by address (e.g

#### get_used_range

Get the used range of a worksheet (the smallest range covering all cells with data)

#### update_range

Write values, formulas, or number formats to a bounded range (e.g

#### clear_range

Clear a range's contents, formats, or both

#### list_tables

List all tables in a workbook

#### get_table

Get a table by name or ID

#### add_table

Create a table over a range, e.g

#### update_table

Update a table's name, header/totals visibility, or style

#### delete_table

Delete a table (the underlying cells remain)

#### list_table_rows

List data rows of a table

#### add_table_row

Add one or more rows to a table

#### delete_table_row

Delete a table row by zero-based index

#### list_table_columns

List columns of a table, including their values

#### add_table_column

Add a column to a table

#### sort_table

Sort a table by one or more columns

#### list_workbooks

List Excel (.xlsx) workbooks in the user's OneDrive/SharePoint

#### create_workbook

Create a new, empty Excel (.xlsx) workbook in OneDrive and return its driveItem ID (use it as item_id in other tools)

#### delete_workbook

Delete an Excel workbook from OneDrive/SharePoint by its driveItem ID

#### create_session

Create an Excel workbook session and return a session_id

#### close_session

Close an Excel workbook session created with create_session

#### list_worksheets

List worksheets in a workbook

#### get_worksheet

Get a worksheet by name or ID

#### add_worksheet

Add a new worksheet to a workbook

#### update_worksheet

Update a worksheet's name, position, or visibility

#### delete_worksheet

Delete a worksheet by name or ID