AI Spreadsheet Generator real .xlsx files, free
Free. Use your own Anthropic or OpenAI key.
Also from Innerscene: Circadian Lab, a free lighting calculator for room illuminance, melanopic EML, and glare.
An example spreadsheet made with AI
How it works
- 1. Describe the spreadsheetSay what the columns are, what the rows hold and what should be added up or worked out. Or open your own .xlsx or .csv to have it edited.
- 2. The AI builds and checks itThe AI writes the cells, formulas and formats, Innerscene saves a real Excel file, and the AI reads the result back and fixes what is wrong.
- 3. Refine and download the .xlsxThe spreadsheet opens in the viewer. Ask for changes in the chat, then download the .xlsx or a CSV.
Why make it with AI here
- Totals, averages and percentages are written as formulas, not typed-in numbers, so the sheet stays right when you change the figures in Excel, Google Sheets, LibreOffice or Numbers.
- When the AI edits your own workbook it patches the file in place: charts, pictures, pivot tables, conditional formatting, defined names and the sheets you did not mention come back exactly as they were.
- After each change the AI gets a report of every cell it wrote, with before and after, and a picture of the sheet as the viewer shows it, so mistakes are caught before you download.
What the spreadsheet engine writes
- Values and formulas
- Numbers, text, dates and true or false values, and formulas filled down a column with the references moved along, as when you drag a formula in Excel.
- Number formats and styling
- Currency, percentages, thousands separators and dates, bold and italic text, text and fill colours, borders, alignment and wrapped text.
- Layout
- Column widths that fit their contents, frozen header rows and columns, merged title cells and filter buttons on the header row.
- Rows, columns and sheets
- Insert, delete and sort rows, remove rows that match a test, add and remove columns, and add, rename and delete sheets. Formulas, named ranges and chart ranges that point at moved cells follow them.
- Editing your own workbook
- Only the sheets that change are written again. Charts, pictures, pivot tables, conditional formatting, data validation, comments, themes and macros are carried over untouched, and macros are never run.
- CSV and TSV files
- Edited as text with the file's own delimiter, quoting, encoding and line endings. Text that a spreadsheet app would run as a formula is marked as text, so a CSV made from outside data is safe to open.
Prompts to try
Click one to open it in the AI panel, then change the sizes to suit.
Getting the spreadsheet into Excel
- Download the .xlsx once the spreadsheet opens in the viewer. It opens in Microsoft Excel, Google Sheets, LibreOffice Calc and Apple Numbers.
- Download the sheet as a CSV instead when another program needs plain data.
- Open the file in your spreadsheet app. It recalculates every formula on opening, so results the AI could not work out in the browser fill in there.
The file is a standard Office Open XML workbook. Formulas are written with English function names, as every spreadsheet file stores them, and your app shows them in its own language. A CSV you edit keeps its delimiter, quoting, encoding and line endings.
Best export formats: XLSX, CSV
Good to know
The AI writes values, formulas, number formats, bold and colours, column widths, frozen panes, sorting, filter buttons and extra sheets. It does not draw charts or build pivot tables, though it keeps the ones a file already has. The browser works out common formulas itself; the rest show blank in the viewer until Excel opens the file and calculates them. Old .xls and .xlsb workbooks must be saved as .xlsx first. Check figures and formulas before you rely on them.
Cost and privacy
You use your own Anthropic or OpenAI API key. It is stored only in your browser and sent only to that provider, which bills you directly: a model typically costs $0.05 to $0.30 at Standard quality and up to about $1 at Detailed, and Innerscene charges nothing. Your key and prompts are not sent to Innerscene; we record anonymous usage statistics such as the steps used, the model chosen, token counts, a cost estimate and whether a model was made.