Convert a Bank Statement PDF to Excel (Keep the Tables Intact)
- Plain copy-paste breaks bank statement tables because a PDF stores text as loose positions, not real columns; a proper PDF to Excel converter rebuilds the grid.
- Unlock the file first: most Indian bank statements (SBI, HDFC, ICICI, Axis) are password-protected, and converters cannot read a locked PDF.
- pdfswing.com converts free, with no sign-up and no watermark, and works right in your phone browser for files received on WhatsApp or email.
- Always verify: check that date, debit, credit and balance are in separate columns and that the closing balance matches before you submit anywhere.
- Scanned or photographed statements need OCR; whenever possible download the original digital PDF from net banking for a cleaner conversion.
Why a bank statement PDF turns into a mess in Excel
A PDF is designed to look the same everywhere, but underneath it stores text as loose pieces placed at fixed positions on the page. It does not know that your statement is a table. So when you copy a statement from your PDF viewer and paste it into Excel, the software has to guess where columns begin and end. Usually it guesses wrong: the whole line drops into a single cell, or amounts split across the wrong columns, and the running balance ends up next to the wrong date.
A proper PDF-to-Excel converter does something smarter. It reads the position of every number and word, detects the invisible grid of your table, and rebuilds it as real spreadsheet cells. That is why the recommended method below keeps your tables intact, while plain copy-paste does not. This matters most for bank statements because a single row shifted by one column changes the meaning of the money completely, and any lender, CA or tax officer reviewing the sheet will notice.
Step-by-step: convert your bank statement PDF to Excel (free)
Use our PDF to Excel tool. It runs in your browser, needs no account and adds no watermark.
1. First remove the password if your statement has one. Bank PDFs from SBI, HDFC, ICICI, Axis and others usually open only with a password (often your PAN, date of birth or customer ID). Open the PDF, enter the password, then use a Remove PDF Password tool to save an unlocked copy. Converters cannot read a locked file.
2. Go to pdfswing.com and open the PDF to Excel tool.
3. Upload your unlocked statement PDF, or drag and drop it into the box.
4. Wait a few seconds while the tool detects the tables and rebuilds the columns.
5. Download the .xlsx file. Open it in Excel, Google Sheets or LibreOffice Calc.
6. Check the result (see the verification section below) before you send it anywhere.
That is it. Because there is no sign-up, you can do this as many times as you need, for every month of statements you have to submit.
Handling passwords, scanned statements and multi-page files
Password-protected PDFs: Most Indian bank statements are locked. The password rule is printed in the same email or on the download page: SBI often uses your account number or a mix of details, HDFC commonly uses your customer ID, and net-banking exports may use PAN in capitals followed by your date of birth. Unlock the file first, then convert.
Scanned or photographed statements: If you got a printout and scanned it, or someone sent a photo on WhatsApp, the PDF is an image with no real text inside. A normal converter will produce empty or garbled cells. You need an OCR-based conversion for that, which reads the picture and recognises the characters. Whenever possible, download the original digital PDF from net banking instead of scanning a printout, as digital PDFs convert far more cleanly.
Many pages: A one-year statement can run 30 or more pages. That is fine, the tool processes all pages. Just review the last page too, since totals and closing balance usually sit there and are the most important numbers to get right.
Verify the numbers before you submit anything
Never send a converted statement to a bank, CA or tax portal without a quick check. Converters are very good but not perfect, especially with unusual fonts or merged cells.
1. Open the Excel file next to the original PDF on screen.
2. Confirm the columns are correct: Date, Narration/Description, Debit (withdrawal), Credit (deposit) and Balance should each be in their own column.
3. Spot-check five or six rows against the PDF, including the first and last transaction.
4. Check the closing balance. In an empty cell, subtract total debits from total credits and add the opening balance, then compare it with the closing balance printed on the statement. If they match, your data is intact.
5. Watch for amounts that lost their decimal or got a stray comma. In India amounts are often written like 1,23,456.78, and occasionally a converter reads the grouping commas oddly. Fix any such cell by hand.
This five-minute check protects you from rejected loan or ITR submissions caused by a single misplaced figure.
Do it on your phone (mobile-first, WhatsApp files)
Most people in India download statements straight to a phone, often receiving them on WhatsApp or email. You do not need a laptop.
1. Save the PDF from WhatsApp or your bank email to your phone. It usually lands in your Downloads or a WhatsApp Documents folder.
2. Open your mobile browser (Chrome, or any browser) and go to pdfswing.com.
3. Open the PDF to Excel tool, tap upload, and pick the file from your storage.
4. Download the .xlsx. You can open it in the Google Sheets app or Microsoft Excel app on the phone itself, or email it to yourself to open on a computer later.
Everything runs in the browser, so a mid-range phone on mobile data is enough. If the file is locked, unlock it first using the password tool in the same browser. Tip: rename the downloaded file to something clear like Statement_Apr2026.xlsx before you upload it to a portal, so it is easy to find later.
Is it safe? Privacy and your bank data
A bank statement is sensitive: it shows your account number, balance and every transaction. Treat it carefully.
On pdfswing.com the tools are free, need no sign-up and add no watermark, and your file is only used to produce the conversion, not to create an account or profile. Still, follow good habits with any online tool. Convert on your own device over a trusted connection, not on a shared or public computer. Avoid random sites that ask you to log in with your bank or email to download the result, those are red flags. After you have your Excel file and have verified it, delete the unlocked copy of the PDF from your Downloads folder if you created one, so an unprotected version of your statement is not left lying on the device.
If your only need is to protect a statement before sharing, you can instead add a password rather than remove one. Do the sensitive work yourself, keep copies minimal, and you are in good shape.
What to do next
Our free PDF to Excel tool detects the tables in your statement and rebuilds every column so the data stays intact.
Since most bank statements are locked, you will first need to remove the PDF password to create an unlocked copy the converter can read.
If you instead want to protect a statement before sharing it, you can add a password to the PDF in the same browser.
Once you have edited the numbers in your spreadsheet and want a clean printable copy, you can convert it back to PDF for submission.
If a portal only asks for a few months, you can split out just those pages from a long multi-page statement before converting.
Recommended tools
Frequently Asked Questions
How do I convert an SBI or HDFC bank statement PDF to Excel for free?
First open the PDF with the password your bank gave you (SBI and HDFC statements are usually locked), then save an unlocked copy using a remove-password tool. Upload that copy to the free PDF to Excel tool on pdfswing.com, and download the .xlsx. There is no sign-up and no watermark. Finally, check the closing balance in Excel against the PDF to confirm the tables converted correctly.
Why does my bank statement lose its columns when I paste it into Excel?
Because a PDF stores text as loose pieces at fixed positions, not as a real table. When you copy-paste, Excel cannot tell where one column ends and the next begins, so everything collapses into one cell. A dedicated PDF to Excel converter detects the table structure and rebuilds each column, which is why it keeps date, debit, credit and balance separate.
My statement is a scanned copy or a WhatsApp photo. Can I still convert it?
A scanned or photographed statement is an image with no real text inside, so an ordinary converter returns empty or garbled cells. You need OCR, which reads the picture and recognises the characters. The cleaner fix is to download the original digital PDF from net banking instead of scanning a printout, because digital PDFs convert far more accurately.
Do I need to remove the password before converting?
Yes. A converter cannot read a locked PDF. Open the file with your bank password, then use a remove-password tool to save an unlocked copy, and convert that. After you are done, delete the unlocked copy from your device so an unprotected version of your statement is not left behind.
Will the converted Excel file be accepted for a loan or income tax filing?
It can be, as long as the data is accurate. Reviewers care that the figures match your official statement, so always verify: check that debit, credit and balance sit in separate columns and that the closing balance matches. Many people submit the converted Excel alongside the original bank-issued PDF, which the lender or portal treats as the authoritative document.
Is it safe to convert my bank statement on an online tool?
It is reasonably safe if you use a trusted tool on your own device over a secure connection. pdfswing.com is free, needs no sign-up and adds no watermark. Avoid any site that asks you to log in with your bank or email to get the result. After converting and verifying, delete any unlocked copy of the PDF you created.
Related guides
- How to Convert Excel to PDF and Fit the Sheet on One PageStop spreadsheets splitting across pages: set the print area and scaling in Excel, then convert to PDF with columns, gridlines and formattin
- How to Convert PDF to Word Without Losing Formatting (Free)Convert PDF to Word without losing formatting, free and no sign-up. Keep tables, fonts and layout intact. Works on mobile. Simple step-by-st