How to Convert a PDF Bank Statement to Excel or CSV (Locked PDFs)

Most banks give you a statement as a PDF. It looks like a table, but a PDF is nothing more than text and lines painted onto a page, so you cannot sort it, total it, or import it anywhere useful. This guide teaches you how to get that statement into Excel or CSV, even in the awkward cases: scanned statements and password-protected files.

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

Why Bank Statement PDFs Are Hard to Convert#

A spreadsheet stores values in cells. A PDF stores characters at (x, y) locations on a page. When you look at a statement, you read those characters as rows and columns, but the software has to rebuild that grouping from the ground up, and there is no column structure saved in the file to help it.

That reconstruction is the whole job, and how hard it is comes down to one thing.

Digital PDFs vs Scanned PDFs#

A digital PDF is one your bank created. If you can click and drag to select a transaction in your PDF reader, it is digital. These are easy to convert, because the characters and their positions are right there to read.

A scanned PDF is an image of a statement. It happens when a statement is printed and then scanned or photographed. There is no text underneath, so the numbers have to be recognized from the image first. That step is never flawless, so a scanned file always needs a careful check after conversion.

How to Convert a PDF Bank Statement to Excel#

If you plan to use the data (sort it by date, total a column, filter to one payee, or tidy it before passing it on), Excel is the right tool. Here is how it works.

1. Open the converter and upload your PDF statement.
2. Wait a few seconds while the transactions are read from the file.
3. Look over the parsed rows on screen. Check that the first and last transactions are on your statement, that they match, 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 you can sort and total them without any cleanup.

How to Convert to CSV Instead#

CSV is plain text: one line per transaction, with each value separated by a comma. It is not as nice to look at, but almost every accounting and finance program can import it, which makes it the better choice when the spreadsheet is just a stop on the way somewhere else.

The steps are the same as for Excel. Upload the PDF and check the rows, but download as CSV. 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 a converter cannot open it until it is unlocked. There is no way around that, which is the whole 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 usually based on your account number, your date of birth, or your post code, and your bank's email normally 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 most useful check is the balance. Each running balance should equal the previous one plus that row's amount. If that holds 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 problem is a description that runs onto two lines on the statement. The payee name can wrap, and a weak parser treats the second line as its own empty transaction. The tell-tale sign is a row with a description but no amount, so scan for those.

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 and QuickBooks, the short version is the same: convert to CSV, then use the "Import a statement" option under the bank account and map the date, description, and amount columns.

A Note on Accuracy and Privacy#

Numbers do not lie. One wrong digit in an amount throws off a reconciliation, so the converter checks its own work: it reconciles the running balance on every file and shows you the result before you download. You stay in control, and 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 is removed too. Treat every converter the same way: before you upload a statement, check what it says it keeps.

With a little practice, converting a statement takes about as long as making a cup of coffee. Start with the PDF to Excel converter or the PDF to CSV converter, depending on what you need next.