Prepare the file
- Save it as a
.csvfile of up to 500 MB. One row can hold up to 16 MiB; a quote that opens a field and never closes makes its row run to the end of the file, and the load fails. - Give every record the same number of fields as the line of column names. A quoted field may hold line breaks.
- Separate fields with commas, semicolons, or tabs; cfo.ai reads which separator the file uses.
- Report title lines above the table are skipped, because cfo.ai reads the file to find where its table starts and ends. A line that totals a list of records, such as the Grand Total under a payroll or invoice report, is skipped too, while the total row of an account schedule or a financial statement loads as one of its rows. If a file still does not load, delete those lines, or attach the file to a chat instead; Ari cleans up a copy and loads that. A file can also load with fewer rows than it holds when the table cfo.ai located ends early; Ari’s load note counts the records loaded against the records in the file.
- Leave codes as they are. On its first load, a column of account numbers, card suffixes, or IDs with a leading zero, such as
00123, or with more than 15 digits loads as text, so no zero or digit is lost. A later upload keeps each column’s stored type, so a column that first loaded as numbers stays numbers; see How columns become Variables and Dimensions. - Name a date column with the word “date”, such as
Posting Dateorinvoice_date, when the file writes dates as eight digits like20260105and every value that is not empty is a real calendar date. cfo.ai then loads the column as dates instead of numbers on its first load; a later upload keeps a column that first loaded as numbers. See Dates in CSV files.
Upload the file
- Ask Ari
- By hand
Attach the CSV to a chat message. The file’s tile shows Data source and Chat only. A CSV starts on Data source, which imports it into cfo.ai as a data source when you send. Say what the file holds and which column dates the rows:
This is our bank transactions export for 2026. Load it as a data source. The Posted Date column dates each row.Ari tells you when the rows are in. Choose Chat only instead when you want Ari to read or summarize the file without loading it.
Replace the file with a newer version
Select the file’s row in the sidebar to open its page, and select Update file. Update CSV file opens; choose the new file. Its rows replace the old ones. When the columns keep their names, your tables and formulas keep reading the same Variables. You can also attach a file with the same name to a chat. Ari asks before it replaces the existing data source.Use a CSV from another chat
Ari can load a CSV you attached in any of your chats in this workspace. Name the file. If more than one of your chats holds a file with that name, Ari asks which one you mean.Excel workbooks and PDFs
The Upload button takes CSV files only.- To load one sheet of an Excel workbook as data, attach the workbook to a chat and ask Ari to load that sheet as a data source. You can also save the sheet as a CSV and upload it.
- To rebuild a whole workbook model, see Import an existing spreadsheet model.
- To keep a workbook in sync, store it in Google Drive and connect it.
- To use a PDF, such as a bank statement, attach it to a chat and ask Ari to turn its table into a data source. Check the totals Ari reports against the statement.