Bank statement to Google Sheets
Google Sheets imports CSV and Excel files directly. Upload your statement, keep CSV as the output, and the file arrives with a date, a description, and an amount per row — so the import lands in columns instead of in one cell.
Upload a file
What the file contains
- A header row, then one row per transaction
- Date, description, and amount in their own comma-separated fields
- Quotes around any description containing a comma, so the columns hold
- Plain UTF-8 text, which Google Sheets imports without conversion
Importing it into Google Sheets
In Google Sheets open File, then Import, then Upload, and pick the CSV. Sheets asks whether to replace the current sheet or add a new one, and whether to convert text to numbers and dates — “detect automatically” is usually the right answer.
The Excel output imports the same way if you would rather work in a formatted workbook; both files carry the same rows.
How to convert
Upload your statement
Drop in the PDF you downloaded from your bank, or a scan of a paper statement.
Choose CSV
CSV is preselected on this page and is what Sheets imports most reliably.
Import it in Sheets
File → Import → Upload, then choose the sheet to put it in.
Statements it handles
Layouts differ from bank to bank, so nothing is matched against a fixed template. An unusual statement still produces a table you can check before exporting — which is what makes it usable for bookkeepers and accountants who receive statements from every client.
PDF statements and CSV exports
A statement downloaded from your bank, or the CSV your bank lets you export. Both arrive as the same clean table.
Multi-page statements, read as one table
A statement that runs over several pages — or several statements uploaded together — is read as one continuous table, not one file per page.
Amounts and dates kept as your bank prints them
Debit and credit signs, decimal places and date formats are left as printed, so the numbers still reconcile against the statement.
Scanned, image-only PDFs, read with OCR
A statement with no text layer is read with OCR and may need a quick review — the one case where a row can come out wrong.
- CSV
- Scan
Rows are read by what they are — a date, a description, an amount — not by where they sit on the page, so a wrapped description stays with its transaction and a closing balance never becomes one. Why OCR mangles bank statements
Frequently asked questions
How do I import a bank statement into Google Sheets?
Convert the statement to CSV here, then in Google Sheets use File → Import → Upload and pick the file. Sheets reads the header row and puts each transaction on its own row.
Which file should I use, CSV or Excel?
CSV. It is plain text, so nothing depends on formatting surviving the round trip, and Sheets imports it without conversion. The .xlsx output works too.
Can I convert a PDF bank statement?
Yes — PDF is the most common input. Upload it and the output is the same CSV.
The import put everything in one column — why?
The delimiter was not detected. Re-import and choose Comma rather than “detect automatically”, and the columns will split.
Is my statement kept after conversion?
No. The file is deleted when the conversion finishes; only the converted copy stays at your private link.
Do I need an account?
No. The converter works without signing up.