Turn a bank statement into a CSV table you can import
Turn a bank statement PDF into a CSV of dates, descriptions, amounts and balances. Paste text or drop a file to preview the table free, then check it.
This preview shows the first 25 rows and does not keep your file.
Need a different result? Turn anything into anything: drop any file, pick what you want out of it.Try it →Bank statements are laid out for reading, not for importing: transactions sit in a table with money out, money in and a running balance, and copying them by hand into a spreadsheet is slow and easy to get wrong. This page reads the transaction table and returns it as a CSV with one header row, keeping every date, amount and balance as printed.
What you get
Amounts stay as printed
Dates, money out, money in and balances are copied exactly as they appear on the statement. Nothing is recalculated or rounded, so you can check a running balance against the original.
One header row, plain values
The output has at most eight columns, a single header row and no merged cells. That is the layout most spreadsheets and import tools expect.
Works from text or a PDF
Paste the statement text or drop a PDF, Word or text file. The preview reads up to 5 pages of a PDF (2 MB) or about 6,000 characters, so you can see the table before you decide anything.
How it works
- Step 1
Paste the statement text, or drop the PDF, Word or text file into the box.
- Step 2
Check the preview: the rows and columns should match the printed transaction table.
- Step 3
Create a free account to get every row, download the CSV, run scanned statements through OCR, convert batches of files and edit the table by asking.
Who uses it
Reconciling a month's spending
Export the account and card lines for one statement period, then compare them with a budget or expense sheet row by row.
Sending records to an accountant
Share a clean CSV of transactions instead of a PDF they have to retype, with dates and amounts left as they were printed.
Importing into a finance app
Load the transactions into a tool that expects a header row and plain values, without reformatting each column first.
Questions
Will the CSV keep the amounts exactly as they appear on the statement?
Yes. Dates, money out, money in and balances are copied as printed, with no recalculation or rounding. That means you can compare the running balance in the CSV with the one on the statement.
Does the preview show the whole statement?
No. The preview shows part of the table so you can check the layout. A free account gives you every row of a long statement and the CSV download.
Can it read scanned bank statements?
Scanned statements need a free account, because reading a scan uses OCR. Once you have an account you can run scans through the same conversion.
Is my statement kept after the preview?
The preview does not keep the file. Your statement is only used to build the table you see on this page.
Will the CSV always be perfect?
Not always. Results can contain mistakes, especially with unusual layouts or poor scans, so check dates, amounts and balances against the original statement before you import or rely on the file.
Related tools
See it on real examples
Three actual runs of this tool. Open one to see the input and the whole result.