How to Convert a PDF Bank Statement to Excel for Free
Banks usually send statements as PDFs. That is fine for reading, but not for checking your spending, preparing a budget, doing your accounts or sending figures to an accountant. In Excel or Google Sheets you can sort, filter and add up every transaction. Here is how to convert a PDF bank statement to Excel for free, without uploading your financial data anywhere.
Why privacy matters for bank statements
A statement shows your name, account number, balance and every payment you made. Many online converters upload your file to their servers. With JanjuaPDF, the conversion happens inside your own browser, so the statement is not sent to anyone.
Step 1: Get the PDF from your bank
- Download the statement from your online banking or banking app. A PDF made by the bank converts much better than a photo or scan.
- If the PDF asks for a password, remove it first with Unlock PDF. You need the password your bank gave you.
- Only need some months or pages? Take them out first with Extract PDF Pages.
Step 2: Convert the statement to Excel
- Open PDF to Excel and choose your statement.
- Press PDF to Excel. The tool finds the columns, such as date, description, debit, credit and balance.
- Download the .xlsx file and open it in Excel or Google Sheets. Each PDF page becomes its own sheet.
Step 3: Check and tidy the result
- Compare totals. Add up a column and compare it with the totals on the statement, so you know nothing was missed.
- Join the sheets. Copy the rows from each sheet into one sheet if you want all transactions together.
- Remove extra rows. Headers, page numbers or bank notes may appear between transactions. Delete them.
- Check long descriptions. A description that runs over two lines may be split into two rows. Join them if needed.
- Fix dates if needed. If Excel does not recognise a date, use Data → Text to Columns or retype the format.
Useful things to do in Excel next
- Sort by amount to find your biggest payments.
- Filter the description column, for example by shop or app name, to see how much you spent there.
- Use SUM on the debit and credit columns to see money in and money out.
- Make a simple chart of spending by category for your monthly budget.
Scanned or photographed statements
- Turn photos into a PDF with Scan to PDF if needed.
- Open OCR PDF to read the text (English for now) and download the searchable PDF.
- Convert that PDF with PDF to Excel, then check every number carefully, because OCR can misread blurry digits.
Common problems and quick fixes
- "No text found": the statement is a scan. Use OCR PDF first, as shown above.
- Columns are shifted: statements with unusual layouts may need small fixes. Move the cells into the right column in Excel.
- You need a PDF again after editing: use Excel to PDF to turn your sheet back into a PDF.
Keep your data safe
- Download statements only from your bank's official app or website.
- Do not send statements to strangers who offer to "check" or "verify" your account.
- Delete copies you no longer need, especially on shared computers.
Frequently asked questions
Is it free to convert a bank statement to Excel?
Yes. It is free, needs no account and adds no watermark.
Is my bank statement uploaded to a server?
No. The spreadsheet is made inside your browser, so your account details stay on your device.
Will the numbers work in Excel formulas?
Yes. Plain numbers are saved as real numbers, so you can add them up. Always compare your totals with the statement.
My statement asks for a password. What do I do?
Many banks protect statements with a password they tell you, often based on your details. Enter it in Unlock PDF to remove it, then convert.
Why does it say no text was found?
Your statement is probably a scan or photo. Run it through OCR PDF first, then convert the new PDF.
Can I convert credit card statements and invoices too?
Yes. Any PDF with a simple table, such as card statements, invoices and price lists, usually converts well.