Create a spreadsheet
create_workbookBuild Excel workbooks with data, live formulas, charts, PivotTables, formatting and conditional rules, then export as xlsx, csv, json, html or pdf.
Instructions
Build an Excel workbook with GridCraft (an Excel-class spreadsheet app): sheets of data and live formulas (500+ Excel functions, dynamic arrays), header styling, tables with filter buttons, totals rows, number formats, fonts, colours, borders, merged cells, conditional formatting (highlights, data bars, colour scales, icon sets), drop-down lists, notes, charts (17 types), PivotTables, frozen panes and print setup. Saves xlsx, csv, tsv, json, html or pdf and returns the computed values of the first rows of every sheet (and any formula errors) to check the result. Or start from a sample: budget, sales, grades.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | No | File name without extension. | workbook |
| theme | No | ||
| title | No | Document title (properties). | |
| author | No | ||
| pivots | No | PivotTables, made after the sheets. | |
| sample | No | Start from a built-in sample workbook instead of a blank one. | |
| sheets | No | ||
| formats | No | Outputs: xlsx (Excel, every sheet, formulas, styles, tables, charts), csv / tsv (values of one sheet), json, html and pdf (one sheet, print layout). | |
| overwrite | No | Replace existing outputs. | |
| all_sheets | No | csv / tsv / pdf: write every sheet as its own file (<name>_<sheet>.csv) instead of only the first sheet. | |
| output_dir | No | Absolute output folder (default: next to the input; required for new files). | |
| output_path | No | Absolute output file for the first format (its extension must match). |