How to Import a Bank Statement Into Excel, Without the Cleanup Pass

By Tarun Vashishth · Published 2026-08-25

Getting bank statement data into Excel usually goes one of two ways: either it lands as clean, typed data ready for a pivot table, or it lands as text that looks right but breaks the moment you try to sum it. The difference comes down to how the file was generated, not how it looks.

The CSV import trap

Double-clicking a CSV or importing it via Excel's Data → From Text/CSV usually works — until you try to sum the amount column and get 0, or a date column sorts alphabetically instead of chronologically. Both symptoms have the same cause: Excel imported the value as text, not as a number or date, because the CSV itself is just plain text with no type information attached. A "-45.00" in a CSV is indistinguishable, to Excel's importer, from any other string that happens to look like a negative number — sometimes it guesses right, sometimes it doesn't, especially with a leading currency symbol, a parenthesized negative, or a locale where the decimal separator differs.

The fix: use a format that carries types, not just text

An .xlsx file avoids the guessing entirely, because the file format itself specifies each cell's type — a date cell is stored as a date, a number cell as a number, independent of how it displays. This converter's Excel export writes the Date column as real Excel date cells (formatted yyyy-mm-dd), Amount and Balance as numbers formatted to two decimals, and Description as text — so SUM(), sorting, and pivot tables work immediately with no "convert to number" cleanup step first. If you're going to work with the data rather than just glance at it, exporting directly as Excel avoids the CSV round-trip entirely. See the Excel export page for exactly what the output file contains.

Building a simple pivot table from the export

Once you have the typed export: select the data range, Insert → PivotTable, and because Amount is signed (negative for debits, positive for credits) rather than split across separate debit/credit columns, a straightforward Sum of Amount by month or by description gives net change directly — no formula needed to combine two columns first.

If you already have a CSV and need to fix it

Select the Date column, use Data → Text to Columns with Date selected as the column type to force a real conversion, and for a numeric column that's landed as text, multiply by 1 in a helper column (or use Paste Special → Multiply after copying a cell containing the number 1) to coerce it to a true number Excel can sum. Both are reliable, if slightly manual, workarounds — the export-as-Excel path skips needing them at all.

Before you build anything on top of it

Whatever the source, verify the numbers first: sum the Amount column, add it to the statement's printed opening balance, and check it against the printed closing balance. A pivot table or budget built on top of a silently missing row will look completely normal and be wrong. See theverification guide for the full check — this converter runs it automatically before you ever get to the export step.