Skip to content
ToolRouter
Excel Tools icon

Excel Tools

Create, read & modify Excel

ProductivityFrom $0.01

Use it in
Add to Claude
Create an Excel spreadsheet tracking topic, e.g. monthly budget / sales pipeline / project tasks with headers, totals formulas, and conditional formatting to highlight important values.
Claude

On it. Running Excel Tools now and I'll bring the results straight back here.

Try asking

About

Excel Tools creates, reads, and modifies Excel workbooks without needing Excel installed. Build complete spreadsheets with formulas, formatting, pivot tables, and data validations from scratch, or apply targeted edits to files you already have.

It handles the full Excel feature set: multiple sheets, conditional formatting with color scales and rules, dropdown validations, named ranges, table objects, freeze panes, merged cells, hyperlinks, comments, print setup, and sheet protection. The read skill parses any .xlsx into structured JSON including formulas, formatting, and comments. The modify skill applies a sequence of 30+ operations to an existing file.

What you can do

  • create_spreadsheet — build a complete workbook from scratch with data, formulas, formatting, validations, and pivot tables
  • read_spreadsheet — parse any .xlsx file into structured JSON with optional formula, comment, and formatting extraction
  • modify_spreadsheet — apply a batch of operations to an existing spreadsheet URL

Who it's for

Analysts, operations teams, developers, and anyone who needs to generate Excel reports programmatically or clean up existing spreadsheets without manual work.

How to use it

  1. To build from scratch, call create_spreadsheet with a sheets array defining your data, headers, and formulas.
  2. To understand an existing file, call read_spreadsheet with the file URL and set include_formulas or include_formatting as needed.
  3. To modify an existing file, call modify_spreadsheet with the file URL and an operations array — operations are applied in order.

Getting started

Call create_spreadsheet with a sheets array to generate your first workbook. The result is a downloadable .xlsx file.

Create Spreadsheet

Build a complete Excel workbook in one call — multiple sheets, headers…

Read Spreadsheet

Download an Excel file from a URL and extract all data as structured…

Modify Spreadsheet

Apply 30+ batch operations to an existing Excel file: write data…

Questions

Can I build a workbook from scratch?

Yes. `create_spreadsheet` can generate a complete .xlsx file with multiple sheets, formulas, formatting, validations, pivot tables, merged cells, and print setup.

Can I read an existing spreadsheet into JSON?

`read_spreadsheet` extracts sheet data, cell values, and optional metadata such as formulas, comments, hyperlinks, validations, formatting, merged cells, and defined names.

Can I modify a workbook without recreating it?

Yes. `modify_spreadsheet` applies batch edits to an existing file URL, including formulas, formatting, tables, pivots, comments, protection, and print settings.

What Excel features are supported?

The tool covers the common power-user pieces: dropdown validations, conditional formatting, named ranges, freeze panes, tab colors, sheet protection, and structured tables.