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.
