Spreadsheet analysis
Ask questions about an Excel or CSV file, have unusual entries found and formulas and charts written into your file, then recalculate in Excel.
Custodos reads Excel and CSV files, answers questions about them and, if you ask, writes formulas, formatting and charts straight into your Excel file. The example: Lea Keller analyses "Stundenrapport Q3 2026.xlsx", with the sheets "Rapport" (date, employee, client, activity, hours) and "Tarife" (hourly rates per activity). What Custodos can do with Excel in general is in Creating and analysing Excel files.
How it works
Prepare the table
One header row with unambiguous column names, one table per sheet, no subtotals in the middle of the data. Remove columns the question does not need beforehand, especially pay or personnel data.
Attach the file and ask
Attach the file via Add and ask:
How many hours fall on each client? As a table, sorted in descending order, with the number of entries per client. Which entries stand out, such as more than 10 hours in a day, a missing client or an activity missing from the "Tarife" sheet? Give the row number. Do not invent values.
For large tables Custodos computes totals, averages and counts itself across all rows instead of letting the model estimate. The number of entries makes checking easier: if it matches Excel, the total usually does too.
Have formulas written into the file
In the "Rapport" sheet, enter the fee in column F: the heading "Honorar" in F1, from F2 a formula for hours times the activity's hourly rate from "Tarife". Format column F as CHF with two decimal places. Change nothing else.
Custodos checks every formula before writing it. The edited file appears below the answer; your original stays unchanged.
Format and tidy up
Custodos can colour cells, highlight headers, mark rows by a rule and freeze the header row:
Colour the header row grey and freeze it, and mark every row with more than 10 hours in red. Remove duplicate entries with the same date, employee and client.
The answer says in how many rows the rule applies and which rows were removed as duplicates.
Check in Excel
Recalculate three rows by hand, including the last one. Watch for error values such as #N/A, for example for an activity without a rate. The check before writing prevents broken formulas, but not a valid formula that calculates the wrong thing.
More options
- A chart in your file: "Add a column chart of hours per client." Custodos inserts real Excel charts.
- A new analysis as its own file: Custodos copies your rows into a data sheet and calculates the overview with formulas on it. Every figure can be traced back to its source.
- A new sheet in the existing file, for a monthly overview, for example.
Custodos does not insert rows in the middle of a table and does not set autofilters. Do both in Excel. Limits per step are in Creating and analysing Excel files.
Personal data in tables
A table is checked with the same protection level as your message. Under Standard, names stay readable. The simplest way is to delete columns the question does not need: a payroll list needs no names for an analysis by department. See Data protection in daily work.
Best practices
- Figures in the chat are an overview, figures in Excel are the result.
- Describe formulas in words and name the sheet and column.
- Write "Change nothing else" when only one area should be affected.
Frequently asked questions
Often the model understood the question differently, for example chose a filter or a column differently. Ask how the figure was calculated, and have important totals written into the file as formulas. The figure in Excel counts.
No. Custodos changes only what you ask for. Other sheets, pivot tables and charts stay as they were.
Next steps
Reviewing contracts
Upload a Word contract, have it checked against your checklist and get the corrections back as tracked changes in the original document.
Email and calendar
Connect Outlook under Connectors, have an email thread summarised, a reply prepared as a draft and a meeting proposed that you confirm yourself.