Spreadsheets

Save a cleaned statement as XLSX or CSV: what each one keeps

XLSX or CSV for bank statement data? A side-by-side look at what each keeps, from formulas and dates to leading zeros, and when to use which.

Editorial illustration for Save a cleaned statement as XLSX or CSV: what each one keeps

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?

ItemXLSXCSV
FormulasKept as formulasSaved as their current results only
Colours, column widths, number formatsKeptLost
Several sheetsKeptOnly the active sheet is saved
DatesKept as true datesSaved as text exactly as displayed
Leading zerosKept if the cell is TextWritten out, but lost again when a program reopens it as a number
Long reference numbersKept if TextWritten as displayed, so 1.23E+11 stays 1.23E+11
Rupee symbol and accentsKeptKept only in CSV UTF-8
File sizeLargerSmall

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?

  1. Keep the raw download untouched in a folder of originals.
  2. Clean and categorise in an XLSX, with formulas and notes.
  3. When you need to hand data to another tool, save a CSV UTF-8 copy from the finished sheet.
  4. 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

  1. Save the CSV, then close it.
  2. Open it in Notepad and read the first three lines.
  3. Look at the date format, the narration with commas inside quotation marks, and the amount without a currency symbol or thousands separator.
  4. 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.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports