Bank Statement PDF to Excel Free — Extract Data Without Typing
📅 June 2026⏱ 7 min read✍️ Fast Private PDF Team
Manually retyping bank transactions from a PDF into Excel wastes hours and introduces errors. Here is how to extract the data automatically — free, in your browser, without uploading your financial data to any server.
How to convert bank statement PDF to Excel — step by step
Most Indian bank statement PDFs are password protected. Here are the passwords for the major banks:
Bank
Statement PDF password
SBI
Account number
HDFC
Customer ID (8 digits)
ICICI
First 4 letters of name (lowercase) + DOB in DDMMYYYY
Axis Bank
Customer ID
Kotak
Date of birth in DDMMYYYY
Yes Bank
Customer ID or date of birth
PNB
Account number
BOI (Bank of India)
Date of birth in DDMMYYYY
Canara Bank
Account number
Union Bank
Date of birth in DDMMYYYY
Unlock first: Use the Unlock PDF tool to remove the bank statement password before extracting. Enter the password from the table above, download the unlocked version, then extract the data.
Will it work with my bank statement?
The tool works on native PDF bank statements — those downloaded digitally from your bank's website or app. Here is what works and what does not:
Statement type
Works?
Why
Downloaded from Net Banking website
✓ Yes
Native PDF with selectable text
Sent to email by bank
✓ Usually
Usually native PDF
Downloaded from bank mobile app
✓ Yes
Native PDF
Scanned paper statement
✗ No
Image-only PDF, no text layer
Photographed statement
✗ No
Image only, needs OCR
Passbook scan
✗ No
Image only
What to do when the CSV looks messy
PDF tables are not stored as true structured data. The extractor groups text by position — sometimes columns shift or merge unexpectedly. Here is how to clean up in Excel:
Text to Columns — select the messy column, go to Data → Text to Columns → Delimited → Comma
Find and Replace — remove extra spaces, line breaks, or unwanted characters
Sort by date column — transactions may not be in order. Sort by the date column after extraction
Filter by amount — use AutoFilter to separate credits and debits
Sum transactions — use =SUM() on the amount column to verify totals match the statement
Why this matters — common uses
Income tax filing
CA professionals and self-filers need transaction data in spreadsheet format to categorise income and expenses for ITR filing. Extracting 12 months of statements manually takes days — with this tool it takes minutes.
Loan applications
Banks and NBFCs reviewing loan applications ask for 6 months of bank statements. Extracting the data lets you quickly verify your average monthly balance, salary credits, and EMI debits before submitting to the lender.
Personal expense tracking
Import bank transactions into a personal finance spreadsheet. Categorise spending, identify patterns, and track where money goes without manually entering hundreds of transactions.
Business accounting
Small businesses reconciling accounts can import bank transactions directly into their accounting spreadsheet. Match against invoices and identify discrepancies without manual data entry.
Frequently asked questions
Upload your bank statement PDF to fastprivatepdf.com/pdf-to-csv.html, select the pages with transaction data, and click Extract. Download the CSV file and open in Excel or Google Sheets. Works best with native digital bank statements downloaded from Net Banking.
Yes. SBI statements downloaded from SBI Net Banking or YONO are native PDFs with selectable text. First unlock using your account number as password, then extract the transaction table.
The password for SBI bank statement PDF is your account number. For HDFC it is your Customer ID. For ICICI it is the first 4 letters of your name in lowercase followed by DOB in DDMMYYYY format.
Yes. The PDF to CSV tool processes everything in your browser — your bank statement data never leaves your device. No upload to any server, no data collection. You can verify this in your browser Network tab — no data is sent anywhere during extraction.
PDF does not store tables as structured data. The tool detects columns by grouping text at similar horizontal positions. Complex tables with irregular spacing or merged cells may need minor cleanup in Excel — use Text to Columns and Sort features to organise the data.