How to convert a PDF bank statement to CSV

By Kayabyte · Last updated 28 October 2026

You have a PDF statement and you need a CSV: for a budgeting app, a spreadsheet, a tax preparer, or an import into accounting software. A CSV is just plain text with one transaction per line and commas between the columns, so in theory this is simple. In practice a PDF stores text by position on the page, not as rows and columns, which is why copying from it so often goes wrong.

Here are the ways to get there, starting with the ones that cost nothing and use what you already have.

1. Ask the bank for a CSV instead

Before converting anything, check whether your bank will give you the data directly. Most online banking sites have a download option on the transactions page, often labeled something like Export or Download, with CSV among the formats. The exact labels vary by bank.

Pick the date range you need. Many banks limit one download to a fixed number of months or rows, so you may need several downloads.
Banks usually keep PDF statements for much longer than they keep downloadable transaction data. If the month you need is years old, the CSV option may not reach it.
Check the first and last rows against the statement. Some banks export only posted transactions and leave out pending ones, or leave out the opening balance.

If this works, you are done. The rest of this page is for when it doesn’t.

2. Copy and paste from the PDF

For a one-page statement this can be quick:

Open the PDF in Preview and drag across the table to select it, then copy.
Paste into a new sheet in Numbers or Excel.
If everything lands in one column, split it by spaces or tabs (in Excel, Text to Columns on the Data tab; in Numbers, the exact steps vary by version).
Save or export the sheet as CSV.

What goes wrong:

Descriptions with spaces get split across several columns, so a merchant name ends up in three cells.
Wrapped lines: a long description that takes two lines in the PDF becomes two rows, one of them without a date or amount.
Debit and credit columns collapse, so you can no longer tell whether 45.00 was money in or money out.
Dates such as 03/04/2026 are read in your computer’s order, not the bank’s. For a non-US bank that quietly swaps days and months.
Page headers and footers repeat on every page and end up among the transactions.

For one month this is a few minutes of cleanup. For a year of statements it is a long afternoon, and the errors are hard to spot.

3. Check the result before you trust it

Whatever route you used, do one check: add up the amounts and compare with the statement. Opening balance plus all credits minus all debits should equal the closing balance. If it doesn’t, a row is missing, doubled, or has the wrong sign. Finding which one by eye is the slow part.

4. Where Balanced helps

Balanced is a Mac app we make that does the conversion and the check for you. You open the PDF, it finds the transaction table, and you see the result in a preview before anything is exported.

It reads text PDFs of any length, and scanned PDFs or images using Apple’s on-device text recognition.
Any bank, any layout: month names and headers are understood in English, Norwegian, Swedish, Danish, German, Dutch, French, Spanish, Italian and Portuguese.
In the preview you can change what each column means (date, description, debit, credit, amount, balance), switch the date order between day/month and month/day, and fix how signs are handled. Balanced remembers the layout for that bank, so next month’s statement goes straight through.
It checks that the opening balance plus the transactions equals the closing balance, and the running balance on each row when your statement has one. If it doesn’t add up, it tells you which rows and by how much, and exporting needs an explicit “Export anyway”.
No AI guessing: every number is copied from your statement and checked.
Everything happens on your Mac. Your statements never leave it.

Choose CSV in the export step and you get one clean file. The same file can also go out as Excel, OFX, QIF and several budgeting formats if you need them later.

Download Balanced and convert for free: the free version converts and checks everything and exports the first 10 transactions per file, enough to see whether it reads your bank properly. Pro is USD 59 per year or USD 7.99 per month; see pricing.

Honest limits

Results depend on how your statement is laid out, so always look at the preview before exporting. Balanced cannot promise to read every bank. Heavily skewed or low-quality scans can fail. Password-protected PDFs will not open: unlock the PDF first with the password from your bank. Macs running macOS 14 or later, Apple silicon and Intel, are supported.