Chat

Creating and analysing Excel files

Create Excel files with real formulas and charts, analyse large spreadsheets and edit an attached file without breaking it.

The model creates Excel files with real formulas, analyses large spreadsheets and changes your own workbook without breaking its formulas and charts. A detailed example is in Spreadsheet analysis.

Only models with tools create and edit files. If the model info says "No web or brain search, and it creates no files.", pick another model.

Create a new Excel file

Start the request

In an empty chat, click Spreadsheet and complete the sentence, for example: "Create an Excel spreadsheet with a monthly budget for 2026: income, fixed and variable costs, total rows and a column chart of the costs."

Wait a moment

While the file is being made, you see Creating spreadsheet….

Download the file

The file card appears under the answer. Click it to download the file.

Totals are Excel formulas, not typed numbers, and every formula is checked before it goes into the file. The header row is frozen, dates are real Excel dates, and charts are native Excel charts. If your admin has set a company template as the default for new spreadsheets, the model starts from it, see Using company templates.

Analyse large spreadsheets

With a large Excel or CSV file, the model does not read every cell. It gets an overview of sheets, columns and values and fetches specific ranges or figures such as sum, count and average per group. Custodos computes these values, not the model. It does not count the sheet's own total rows such as "Total" twice.

The tools read Excel and CSV files up to 4 MB in full. From larger files Custodos reads at most 200,000 characters, and the model explicitly calls totals over them incomplete.

Ask in two steps: the analysis in the chat first, then the file. That way you check the figures before the file is made.

Have your own Excel file edited

Attach the workbook (.xlsx or .xlsm up to 4 MB) directly and describe the change, for example "Increase all hourly rates in column D by 3 percent". You see Editing Excel file… and get a new file, and your original stays in the chat.

The model can:

  • set values and formulas, including one formula down a whole column, and append rows at the end,
  • change number formats, bold, cell and font colours and column widths,
  • highlight rows that meet a rule (red, yellow or green) and freeze the header row,
  • remove duplicate rows, with totals and references moving along,
  • add a new sheet and charts.

It cannot insert rows in the middle of a table or set autofilters. As a check, the answer states what the changed formulas compute and whether a check cell no longer comes to zero. An Excel document from a brain goes back through the Changes for the Brain card, see Keeping a brain up to date.

Ask for a model review and the model examines how the workbook is built (Inspecting Excel model…): inconsistent formulas, numbers hidden in formulas, error values, circular references and external links.

Limits

New file: up to 5 sheets, 50 columns and 2,000 rows per sheet, plus up to 100,000 rows copied from attached spreadsheets, and up to 4 charts. Per editing step up to 500 cells and 200 new rows. Files at most 4 MB. All limits: Limits and formats.

Best practices

  • Say what must stay unchanged: "Only adjust the amounts in column D, nothing else."
  • Let Custodos analyse large data instead of pasting it into the composer.
  • Check the figures in the finished file. The check catches formula errors, not a wrongly chosen cell.

Frequently asked questions

Next steps

On this page