How to convert a PDF bank statement to Excel or CSV (including password-protected PDFs)

Most banks hand you a statement as a PDF. It looks like a table, but a PDF is really just text and lines painted onto a page, so you cannot sort it, total it, or import it anywhere useful. This guide walks through getting that statement into Excel or CSV cleanly, including the awkward cases: scanned statements and password-protected files.

I build the converter behind this site, so the advice here is what I would actually do with a real statement on my own screen, not a list of generic tips.

Why bank statement PDFs are hard to convert#

A spreadsheet stores values in cells. A PDF stores characters at x and y coordinates on a page. When you look at a statement, your eye groups those characters into rows and columns. Software has to reconstruct that grouping from scratch, and there is no column structure saved in the file to help it.

That reconstruction is the whole job, and how hard it is depends entirely on one thing.

Digital PDFs vs scanned PDFs#

A digital PDF is one your bank generated. The text is selectable: if you can click and drag to highlight a transaction in your PDF reader, it is digital. These convert well, because the characters and their positions are right there to be read.

A scanned PDF is a picture of a statement. It happens when someone prints a statement and scans it back in, or photographs it. There is no text underneath, only pixels, so the numbers have to be recognised from the image first. That step is never perfect, which is why a scanned file always needs a careful check after conversion.

How to convert a PDF bank statement to Excel#

Excel is the right target when you plan to work with the data: sort by date, total a column, filter to one payee, or tidy it before sending it on. Here is the process.

1. Open the converter and upload your PDF statement.
2. Wait a few seconds while the transactions are read out of the file.
3. Look over the parsed rows on screen. Check that the first and last transactions match your statement and that the amounts line up with the right dates.
4. Download the Excel workbook.

The result is a real .xlsx file. The amount and balance columns come through as numbers, not text, so SUM and sorting work immediately without any cleanup.

How to convert to CSV instead#

CSV is plain text: one line per transaction, values separated by commas. It is not pretty to read, but almost every accounting and finance program can import it, which makes it the better choice when the spreadsheet is a stop on the way somewhere else.

The steps are the same as for Excel. Upload the PDF, check the rows, and download, but pick CSV as the output. Use CSV when you are heading into QuickBooks, Xero, Tally, or a bank feed, and use Excel when a person is going to open and read the file.

What to do with a password-protected PDF bank statement#

Many banks email statements as locked PDFs. You will know because your reader asks for a password before it shows anything. A locked file is encrypted, so no converter can read it until it is opened. There is no way around that, and that is the point of the lock.

The fix is to unlock it yourself first:

1. Open the PDF in any reader and enter the password your bank gave you. It is often based on your account number, your date of birth, or your post code. Your bank's email usually says which.
2. Print the file back to a new PDF (in the print dialog, choose "Save as PDF" or "Microsoft Print to PDF"). The new copy has no password.
3. Convert the unlocked copy.

Cleaning the data: date, description, amount, and balance columns#

Whatever you do with a statement afterwards, four columns carry the weight.

The single most useful check is the balance. Each running balance should equal the one above it plus that row's amount. If it does across the whole statement, the numbers are almost certainly right. A good converter does this reconciliation for you and flags any row that does not add up, so you know exactly where to look instead of re-reading the whole file.

The other common issue is a description that spans two lines on the statement. A long payee name can wrap, and a weak parser treats the second line as its own empty transaction. Scan for any row with a description but no amount, which is the tell-tale sign.

Importing the result into QuickBooks, Xero, or Tally#

Once you have a clean CSV, getting it into accounting software is straightforward, but each program has its own quirks. Rather than cram them all in here, I have written separate step-by-step guides:

• Import a PDF bank statement into QuickBooks, for both Online and Desktop.
• Convert a PDF bank statement to Tally XML, which imports as receipt and payment vouchers.
• Convert a PDF bank statement to Google Sheets, if you just want a free online spreadsheet.

For Xero, the short version is the same as QuickBooks: convert to CSV, then use Xero's "Import a statement" option under the bank account and map the date, description, and amount columns.

A note on accuracy and privacy#

Financial data is unforgiving. One wrong digit in an amount can throw off a reconciliation for an hour, so the converter checks its own work by reconciling the running balance on every file and showing you the result before you download. You stay in control: nothing is final until you have looked at the rows.

On privacy, the file you upload is read on the server and deleted right after the conversion, and its contents are never logged. If you are signed in, only the converted result is kept for a short window so you can download it again, then it too is deleted. Treat any converter the same way: before you upload a statement, read what it says it keeps.

Once you have the hang of it, converting a statement takes about as long as making a coffee. Start with the PDF to Excel converter or the PDF to CSV converter, depending on what you need next.