Excel Tools
Create, read & modify Excel
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
- To build from scratch, call create_spreadsheet with a sheets array defining your data, headers, and formulas.
- To understand an existing file, call read_spreadsheet with the file URL and set include_formulas or include_formatting as needed.
- 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.
Build a complete Excel workbook in one call — multiple sheets, headers…
Download an Excel file from a URL and extract all data as structured…
Apply 30+ batch operations to an existing Excel file: write data…
Build a complete Excel workbook in one call — multiple sheets, headers, formulas, rich formatting, merged cells, data validations, conditional formatting, hyperlinks, comments, named ranges, tables, pivot tables, sheet protection, freeze panes, and print setup. Returns a .xlsx file.
Download an Excel file from a URL and extract all data as structured JSON — sheet names, headers, cell values, merged cells, tables, and print settings. Optionally includes formulas, comments, hyperlinks, data validations, and per-cell formatting. Use this to inspect a file before modifying it.
Apply 30+ batch operations to an existing Excel file: write data, formulas, formatting, merges, sheets, rows/cols, tables, pivots, validations, conditional formats, hyperlinks, comments, protection, and print setup. Returns the modified .xlsx file.
- Added data validations, conditional formatting, hyperlinks, comments, named ranges, tables, pivot tables
- Added copy_range, delete_range, clear_range, find_replace, sort_data operations
- Added sheet protection, print setup, tab colors, row heights
- Read now extracts formulas, comments, hyperlinks, data validations, formatting per cell
- Changed pricing to paid
- Initial release with create, read, and modify skills
Related
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.