Bank statements

ING statement to CSV: export, clean up and import without scrambled columns

Turn an ING statement into a clean CSV: export or convert, fix decimal commas and dates, check totals, then import. Includes a working Excel formula.

Editorial illustration for ING statement to CSV: export, clean up and import without scrambled columns

Download the transaction history in CSV or Excel form from the bank, if it offers one, to get a statement into CSV cleanly. If you only have a PDF, you can convert it in a spreadsheet, but you then need to fix decimal separators, date order and stray header rows before the file is usable.

Which route should I try first?

  1. Look in the transaction history for a download option in CSV or Excel form. We cannot describe the bank's own screens, so check them yourself.
  2. If only PDF is available, open it and try selecting the table and pasting it into a sheet.
  3. In recent Excel 365 versions, Data, then Get Data, then From File, then From PDF can read tables from a PDF. Check that your version has it.
  4. As a last resort, type a small statement in by hand rather than importing garbled data.

What usually breaks?

  • Decimal commas: 1.234,56 means one thousand two hundred thirty-four and fifty-six hundredths in some European formats
  • Dates in day-month-year order that a sheet reads as month-day-year
  • Header lines and page footers repeated in the middle of the data
  • Credits and debits in one column, or two separate columns
  • Text that looks like a number but is stored as text

How do I fix decimal commas in Excel?

If a value such as 1.234,56 sits in cell B2 as text, this formula removes the thousands dot and swaps the comma for a point: =VALUE(SUBSTITUTE(SUBSTITUTE(B2,".",""),",",".")). It works when your computer uses a decimal point. If your system already uses a decimal comma, adjust the replacement accordingly and test on one cell first.

Original textAfter formulaCheck
1.234,561234.56Thousands dot removed
89,9089.9Comma became a point
12,0512.05Leading digits kept

Add those three: 1,234.56 + 89.90 + 12.05 = 1,336.51. Your cleaned column should total the same as the same lines on the statement.

How do I check the CSV before importing?

  1. Sort by date and look for impossible dates such as the 31st of a short month.
  2. Add the amounts and compare with the printed total.
  3. Count the rows against the number of lines on the statement.
  4. Save as CSV, then reopen it to confirm nothing shifted.

Can I import the CSV into an expense tracker?

In SpendixAI, pick the account first, upload the CSV or Excel file, and review the rows before saving. Choose the base currency before you import, because it cannot be changed once transactions exist. we cannot promise every layout reads perfectly, so check the review screen.

What do I do with credits and debits in separate columns?

Combine them into one signed amount so that spending is negative and money in is positive. If debits sit in column C and credits in column D, a helper column with =D2-C2 gives one number per row. Fill it down the range, then compare the sum of that column with the difference between the opening and closing balances on the statement. If they agree, you have not lost or double-counted a row.

What if the file opens in one column?

A CSV that appears as one long column usually has the wrong separator for your sheet. Instead of double-clicking, import it through the data import option in your spreadsheet and choose the separator the file uses, which may be a comma or a semicolon. Check that the amount column came in as numbers, not text, by adding it up.

Final checklist

  • Original saved
  • Decimal commas and dates fixed
  • Total and row count match the statement
  • Account chosen before import
  • Rows reviewed before saving
SPENDIXAI JOURNAL

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

Explore your reports