How to Convert a Bank Statement PDF to Excel

To convert a bank statement PDF to Excel, unlock the file first if your bank protected it with a password, then run it through a PDF-to-Excel converter that reads the transaction table and places each column, like date, description, debit, credit and balance, into its own Excel column.

Why bank statement PDFs need an extra unlock step

Many Indian banks send e-statements as password-protected PDFs. The password format varies by bank (often built from details like your date of birth or customer ID), and the bank's statement email usually tells you what it is. A converter cannot read a locked file's table at all until it is opened, so trying to convert a protected PDF directly either fails outright or comes back with a blank sheet.

Step by step: PDF to Excel for a bank statement

1. Open your email or net banking and download the statement PDF for the period you need.
2. If the PDF asks for a password, unlock it with the PDF unlocker so the file opens without a prompt.
3. Upload the unlocked PDF to the PDF to Excel converter.
4. Let the tool detect and extract the transaction table into rows and columns.
5. Download the resulting XLSX file and open it in Excel, Google Sheets or any spreadsheet app.
6. Check the first and last few rows for header or footer text that got pulled in as data, and delete those rows.
7. Reformat the date column to a proper date format if it came through as plain text.

Try it here

PDF to Excel

Add the unlocked statement PDF. Amounts come out as numbers you can sum and sort.

Files are uploaded over HTTPS, processed and deleted from our server straight after. Open the full PDF to Excel page

Cleaning up the date and amount columns

Bank statements often print dates as DD/MM/YYYY or DD-MMM-YYYY, and spreadsheet apps do not always recognise these automatically, especially if your regional settings expect month-first dates. Select the date column, use the spreadsheet's "text to columns" or "convert to date" option, and confirm the day and month have not swapped.

Debit and credit amounts sometimes land in the same column with a sign or a "Dr"/"Cr" label attached. If you need separate debit and credit totals for a budget or an audit, split that column using a formula or the find-and-replace tool before you trust any sum at the bottom.

What to check before you rely on the numbers

• Row count: compare the number of transaction rows in the Excel file against what the PDF actually shows, since a long statement can occasionally lose a row at a page break.
• Running balance: spot-check a few running balance figures against the PDF to confirm nothing shifted between columns during extraction.
• Currency symbols: a stray "Rs" or "₹" symbol stuck to a number can turn an amount into text, which breaks any sum formula until you clean it.

If the table does not extract cleanly

Some banks generate statements as scanned images rather than real text-based PDFs, especially for older archived statements. In that case, a standard converter has nothing to read, and you may need an OCR-based tool that recognises the printed numbers first. If your statement was scanned rather than generated digitally, check whether it looks blurry or slightly skewed when zoomed in, which is the usual giveaway.

Why you might need this in the first place

Banks share statements as PDFs because that format prints and displays consistently across every device, but a PDF is not built for calculation. If you are preparing a loan application, filing an income tax return, doing a personal budget, or reconciling accounts for a small business, you usually need the transactions in rows and columns so you can sort, filter, sum or chart them, which a PDF alone cannot do.

Converting once and keeping the Excel file also saves time if you need the same data again later. Rather than re-reading a long PDF every time you want last month's spending by category, a spreadsheet lets you filter and total figures in seconds.

A quick sanity check before you use the numbers

Before relying on the converted sheet for anything official, like a loan application, add up the total credits and debits in Excel and compare that against the closing balance shown in the original PDF. If the two do not reconcile, something was likely misread during extraction, and it is worth re-checking the raw PDF for that period rather than trusting the spreadsheet as is.

This check takes only a minute with a simple SUM formula, but it can save you from submitting a document with a silent extraction error to a bank, an accountant or a government portal, where the mistake might only surface much later.

Common mistakes

• Trying to convert a password-protected PDF directly, which returns an empty or broken sheet.
• Trusting the converted balance column without spot-checking a few rows against the original PDF.
• Leaving the bank's header and footer text (branch address, account summary) mixed into the transaction rows.
• Not reformatting the date column, so sorting or filtering by date behaves unpredictably.
• Sharing the unlocked, converted file over channels that are not secure, since it now has no password protecting your account details.
• Deleting the original locked PDF right after converting, leaving no backup if the extracted sheet later turns out to have an error.

Tools for this

Frequently asked questions

Sources

• Adobe Support: Remove a password from a PDF (checked 2026-09)

Rules and limits change. Always check the latest official notification or portal before you submit a form.