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.
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.
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.
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
Custodos does not store every formula with its result, and after values change Excel recalculates all formulas on opening. In Excel, all values are there.
The model sees an overview and the ranges it asks for. When data protection is on, they go to the model pseudonymised, and Custodos writes the real values into the file. See Protecting personal data in chat.
Next steps
Document beside chat
Open a document beside the chat, edit it yourself or with AI, restore earlier versions and export it as Word, PDF or Markdown.
Presentations
Create PowerPoint presentations with action titles, source lines and speaker notes, take on a reference deck's style and edit your own slides.