How to Import a Bank Statement Into Google Sheets

By Tarun Vashishth · Published 2026-08-25

Google Sheets handles a bank statement CSV a little differently than Excel does, and the traps aren't quite the same ones. Here's what actually works.

Two ways in

You can either open the CSV directly (File → Import → Upload, choosing "Insert new sheet" or "Replace current sheet"), or, if you exported an .xlsx from this tool, upload it directly and Sheets will convert it on open, generally preserving the cell types (dates as dates, numbers as numbers) more reliably than a CSV import does — because, same as with Excel, the .xlsx format carries type information the CSV format doesn't.

The date-format trap

Google Sheets' date parsing during CSV import is locale-dependent: a spreadsheet set to a US locale expectsMM/DD/YYYY and one set to most other locales expects DD/MM/YYYY. A CSV exported with dates in one convention, opened in a spreadsheet configured for the other, either misparses ambiguous dates silently (01/02/2026 becomes February 1st instead of January 2nd) or fails to recognize the column as a date at all and leaves it as text. This converter's CSV export writes dates asyyyy-mm-dd — ISO 8601 — specifically because that format is unambiguous regardless of locale; Sheets reads it correctly either way. If you're combining data from multiple sources, check that every source uses the same date convention before you merge them.

Checking that amounts imported as numbers, not text

After import, select the Amount column and check the sum shown in the status bar at the bottom-right of the Sheets window. If it shows a number, the column imported correctly. If it's blank or shows "0," at least some cells landed as text — usually caused by a currency symbol or thousands separator in the source data that Sheets' importer didn't strip. The fix: select the column, Format → Number → Number, which coerces numeric-looking text into real numbers Sheets can sum. This converter's CSV export writes bare numbers with no currency symbol or thousands separator for exactly this reason.

Building a quick summary

With Date, Description, Amount, and Balance columns imported correctly, a=SUMIF(A:A,">="&DATE(2026,1,1),C:C)-style formula against the Amount column gives spending or income for a date range with no pivot table required, and because Amount is signed, a plain=SUM(C:C) gives the net change for the whole statement — which should match the difference between the statement's printed opening and closing balances.

Verify before you build on it

As with any spreadsheet workflow, confirm the imported total actually matches the statement's printed numbers before building anything on top of it — a silently missing or misparsed row won't announce itself. See the verification guide for the full check, which this tool runs automatically before export.