AI Spreadsheet Generator real .xlsx files, free

Describe the spreadsheet you need in plain words, with what each column holds and what should be worked out, and the AI builds it as an Excel workbook in the free Innerscene viewer. Totals and percentages are real formulas, numbers carry real number formats, and the header row is bold and frozen. The AI reads the result back after every change and fixes what it finds. Open an .xlsx or .csv of your own and the AI can edit that too, changing only the cells you ask about.

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

Download the XLSX file

How it works

  1. 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. 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. 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

  1. Download the .xlsx once the spreadsheet opens in the viewer. It opens in Microsoft Excel, Google Sheets, LibreOffice Calc and Apple Numbers.
  2. Download the sheet as a CSV instead when another program needs plain data.
  3. 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

Open Excel files in the free Excel viewer

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.

How to get an Anthropic or OpenAI API key

Read the full guide: API keys, refining and exporting

Questions

▶Is the AI spreadsheet generator free?
The tool is free and Innerscene charges nothing. Your own Anthropic or OpenAI key pays for the AI, usually about $0.03 to $0.30 per spreadsheet at Standard quality, depending on its size.
▶Can the AI edit an Excel file I already have?
Yes. Open the .xlsx, .xlsm or .csv in the viewer, choose Edit with AI, and say what to change. The AI reads the sheets, changes only the cells involved and leaves the rest of the workbook as it was, including charts, pictures and pivot tables.
▶Are the formulas real?
Yes. A total is written as a SUM formula and a percentage as a division, so the numbers update when you edit the data. The viewer shows the results the AI could work out in the browser, and your spreadsheet app recalculates everything when it opens the file.
▶Is my spreadsheet uploaded anywhere?
The file is read and written in your browser, and Innerscene never receives it. The parts of it the AI needs (headers, sample rows and the cells it asks to read) go to the AI provider you chose, with your own key.

What it can make

Floor plans and layouts

Molecules, proteins and crystals

Make a model for any format

Make a model for your app

More ways to use it

AI Generator