Convert a bank statement PDF to CSV
Get a clean CSV of every transaction (date, description, amount, balance) from a PDF statement, checked against the statement's own totals.
Runs in your browser. Your file never leaves this device.
Loading the tool…
Choosing the right CSV
The standard CSV has one row per transaction with Date, Description, Amount and Balance. Money in is positive and money out is negative, which is what spreadsheets and most import tools expect.
QuickBooks Online accepts a 3-column CSV (Date, Description, Amount) with dates as MM/DD/YYYY. Choose “CSV for QuickBooks” and the file is formatted that way, whatever date style your statement uses.
Tips
- UK and Indian statements use day-first dates. Pick DD/MM/YYYY if your spreadsheet is set to a UK or Indian locale.
- If Excel shows odd characters for £ or €, open the CSV with Data → From Text/CSV and choose UTF-8.
What this tool does
CSV is the plainest way to get transactions out of a PDF statement: a text file with one row per transaction that Google Sheets, Numbers, Excel, LibreOffice and almost every import screen can read.
Drop the statement PDF from your online banking and the converter lists every transaction with its date, description, amount and running balance. Money in is a positive number and money out is negative, in a single Amount column, so you can sum or filter it straight away.
Before you download, the totals are checked against the opening and closing balance printed on the statement. If anything doesn't add up, the rows to look at are highlighted, so a missing line can't slip into your books unnoticed. The PDF is read in your browser and never uploaded.
People use it for
- Pulling a statement into Google Sheets to categorise spending
- Uploading missing months to QuickBooks Online as a 3-column CSV
- Feeding transactions into a budgeting app or a script
- Sharing a clean table with an accountant who asked for CSV
How to use it
Save the statement as a PDF
Download it from online banking. A PDF with real text works; a phone photo or a scan of paper doesn't.
Check the balance match
Drop the PDF on the box. A green balance check means every transaction was found; red points you at the row to check.
Pick CSV or CSV for QuickBooks
The standard CSV keeps the balance column. The QuickBooks option writes Date, Description and Amount with US dates, ready for Banking → Upload transactions.
What it works with
| You give it | You get | Good to know |
|---|---|---|
| Bank statement PDF (text) | Excel (.xlsx) | Dates and amounts as numbers, summary sheet |
| Credit-card statement PDF | CSV | Standard or QuickBooks 3-column |
| Bank or card statement PDF | OFX | QuickBooks, Xero, GnuCash import |
Questions
Which CSV columns do I get?
Date, Description, Amount and Balance for the standard CSV. The QuickBooks option drops the balance and writes Date, Description and Amount, which is the 3-column layout QuickBooks Online accepts.
Why do £ or € signs look wrong when I open the CSV in Excel?
Double-clicking a CSV can make Excel guess the wrong text encoding. Open it with Data → From Text/CSV and choose UTF-8 instead.
Can I import the CSV into Google Sheets?
Yes. Use File → Import → Upload and choose the CSV. Amounts come in as numbers you can sum and filter.
Should I use CSV or OFX for accounting software?
Use OFX when your software accepts it, because it imports without mapping columns. Use CSV when it only takes spreadsheets, or when you want to edit the rows first.
Is the statement uploaded?
No. It's read and converted in your browser, on your device.