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

  1. 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.

  2. 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.

  3. 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 itYou get
Bank statement PDF (text)Excel (.xlsx)
Credit-card statement PDFCSV
Bank or card statement PDFOFX

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.

Guides