Save as XLSX when you want to keep working: it keeps formulas, formatting, several sheets and true dates. Save as CSV UTF-8 when you want to share or re-import plain data: it keeps only the values, one sheet and the text as displayed. Many people keep both, an XLSX to work in and a CSV copy for hand-offs.
What does each format keep?
| Item | XLSX | CSV |
|---|---|---|
| Formulas | Kept as formulas | Saved as their current results only |
| Colours, column widths, number formats | Kept | Lost |
| Several sheets | Kept | Only the active sheet is saved |
| Dates | Kept as true dates | Saved as text exactly as displayed |
| Leading zeros | Kept if the cell is Text | Written out, but lost again when a program reopens it as a number |
| Long reference numbers | Kept if Text | Written as displayed, so 1.23E+11 stays 1.23E+11 |
| Rupee symbol and accents | Kept | Kept only in CSV UTF-8 |
| File size | Larger | Small |
Why does a CSV lose so much?
A CSV is just lines of text with a separator. There is no place to store a formula, a colour or a second sheet. Excel writes each cell as it appears on screen, which has two nasty consequences. A date shown as 05-Jan-26 is saved with its two-digit year, and a number shown in scientific notation is saved that way. Fix the display before you save, not after.
Which should you use for which job?
- Archiving a cleaned month: XLSX, so formulas and notes stay with the data.
- Sending rows to a tool that expects a table: CSV UTF-8.
- Re-importing into a tracker or another sheet: CSV UTF-8, with dates in an unambiguous order.
- Handing a record to someone else: a PDF or XLSX of results, not your working file with raw account details.
Is CSV or CSV UTF-8 the right Save As option?
Excel offers CSV (Comma delimited) and CSV UTF-8 (Comma delimited). The plain version writes in a legacy code page, so a rupee sign can become a question mark. Choose CSV UTF-8 whenever the file contains the rupee symbol, accents or non-English merchant names. Google Sheets downloads CSV through File > Download > Comma Separated Values, and only the current tab is saved.
How do the two formats fit into a monthly routine?
- Keep the raw download untouched in a folder of originals.
- Clean and categorise in an XLSX, with formulas and notes.
- When you need to hand data to another tool, save a CSV UTF-8 copy from the finished sheet.
- At the end of the April to March year, archive that year's XLSX and start a new one.
Say a cheque number 000123 sits in a Text cell. The CSV file will hold 000123, but a double-click reopen makes it 123. The XLSX keeps the Text cell as it is. This is why the XLSX is your working file and the CSV is a delivery copy.
If you only keep one file, keep the XLSX, because you can always produce a CSV from it, but a CSV can never give back your formulas and formatting. If space is no problem, keep the XLSX as the working record and the CSV UTF-8 as the plain-data copy.
A small test before you trust a CSV
- Save the CSV, then close it.
- Open it in Notepad and read the first three lines.
- Look at the date format, the narration with commas inside quotation marks, and the amount without a currency symbol or thousands separator.
- Reopen through Data > From Text/CSV and make sure everything lines up.
If you want to keep statement history in one place instead of a folder of files, SpendixAI imports PDF, CSV or Excel statements, and its reports can be downloaded as CSV. Keep your own untouched copy of the original download too.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


