How to Convert a Bank Statement PDF to Excel

Your bank sends statements as PDFs, but a PDF is hard to work with: you can't sort the transactions, add up your spending or filter by shop. Converting the bank statement PDF to Excel fixes that in a minute.

This guide shows you how to convert a statement for free, how to make sure the numbers are right, and what to do with scanned or password-protected statements.

How to Convert a Bank Statement PDF to Excel

1. Open the free PDF to Excel converter.
2. Drag your statement onto the page, or click to choose it. It's read in your browser, so the file isn't uploaded.
3. Check the preview. Each transaction should be on its own row, with the date, description and amounts in separate columns.
4. Keep Turn numbers like 1,234.50 into real numbers ticked, so Excel can calculate with them.
5. For a statement with several pages, tick Put all pages in one sheet to get one continuous list.
6. Click Download .xlsx and open it in Excel, Google Sheets or LibreOffice.

How the Numbers Are Converted

Amounts in a PDF are just text. The converter turns them into real numbers so formulas work:

In the PDF	In Excel
1,234.50	1234.5
(120.00)	-120
15%	0.15
2026-09-01	stays as a date (text)
0042-1188-7731	stays as text

Dates, account numbers and anything with a leading zero stay exactly as written, so nothing is changed by accident. If you'd rather keep every value as text, untick the numbers option before downloading.

Check Your Totals After Converting

Before relying on the spreadsheet, take ten seconds to check it:

1. Select the Debit column and look at the sum at the bottom of the Excel window.
2. Compare it with the total debits printed on the statement.
3. Do the same for Credit.

If the totals match, every transaction came through. If not, look for a row where text wrapped onto two lines, which is the most common cause.

What to Do With the Spreadsheet

Once your transactions are in Excel, a few simple steps go a long way:

• Sort by amount to find your biggest expenses.
• Filter the description column for a shop or company, such as "Daraz" or "K-Electric", to see everything you spent there.
• Add a Category column (Food, Bills, Shopping) and use a PivotTable to total each one.
• Combine months. Join several statements with Merge PDF, then convert once with Put all pages in one sheet ticked.

Scanned or Password-Protected Statements

The statement is password-protected

Many banks lock statements with a password such as your date of birth or the last digits of your account number. Remove it first with Unlock PDF: type the password and download an unlocked copy, then convert that. You do need to know the password.

The statement is a scan

If the statement is a photo or a scan, each page is a picture with no text inside, and the converter will tell you so. Run it through PDF OCR first to recognize the text. Scans are harder to turn into clean columns, so check the result carefully.

Is It Safe to Convert a Bank Statement Online?

Bank statements are some of the most private documents you have. With ToolsBench, the PDF is read and the spreadsheet is created entirely in your browser, so the statement never leaves your device. No account is needed, and nothing is stored.

With other online converters, check whether your file is uploaded to their servers before you use them for financial documents.

Final Thoughts

Converting a bank statement PDF to Excel turns a document you can only read into data you can sort, filter and total. Check the totals once after converting, and unlock or OCR the statement first if it's protected or scanned.

Ready to try it? Use the free PDF to Excel converter. No sign-up, and your statement stays on your device.