Tutorials

How to Convert Password Protected Bank Statement PDF to Excel

Getting a "password required" error when trying to convert your bank statement? This guide explains how to convert password-protected bank statement PDFs to Excel without unlocking them first — and what to do when you forget the password.

SHStatementHub TeamJul 21, 20269 min read1,900 words
Jump to section

You have downloaded your bank statement PDF, opened your conversion tool, and hit a wall: This document is password protected. Enter the password to proceed. For millions of Indians, this is a familiar frustration. Every major Indian bank — SBI, HDFC, ICICI, Axis, Kotak, and others — issues statement PDFs with password protection by default.

The good news: you do not have to unlock the PDF before converting it to Excel. Modern tools like StatementHub accept the password directly and handle the decryption in your browser without ever uploading your file to a server. This guide walks through every method available, from the simplest to the most manual, so you can pick the one that fits your situation.

Why Bank Statement PDFs Are Password Protected

Indian banks encrypt statement PDFs as a basic security measure. If your statement email is intercepted, the attacker cannot open the PDF without knowing your password. The protection is owner-level encryption in the PDF standard — meaning the file is locked until the correct password is entered.

Banks set the password automatically when generating statements, using a formula derived from your personal data. This means the password is deterministic — the same account always produces the same password — but it also means you can look it up if you know the formula your bank uses.

💡

The password is not your net banking PIN or ATM PIN. It is a separate value derived from your date of birth, PAN number, or a combination of these, depending on your bank.

Password Formats for Major Indian Banks

Each bank uses its own password formula. The table below covers the most common Indian banks — use it to find your password before attempting conversion.

BankPassword FormulaExample
SBI (State Bank of India)First 5 letters of your name (UPPERCASE) + date of birth in DDMMYY formatRAHUL150592 for Rahul born 15 May 1992
HDFC BankDate of birth in DDMMYYYY format15051992
ICICI BankFirst 4 digits of PAN + date of birth in DDMMYYYYABCD15051992
Axis BankRegistered mobile number (10 digits)9876543210
Kotak Mahindra BankDate of birth in DDMMYYYY format15051992
Bank of BarodaCustomer IDYour 8-digit customer ID
Punjab National BankAccount number (last 8 digits)Last 8 digits of your account number
Canara BankDate of birth in DDMMYYYY format15051992
Yes BankDate of birth in DDMMYYYY format15051992
IndusInd BankRegistered mobile number9876543210
⚠️

Bank password formats occasionally change. If the formula above does not work, log in to your bank's net banking portal — password instructions are usually printed in the email that delivered your statement, or in the FAQ section of your bank's website.

Method 1: StatementHub (No Unlocking Required)

StatementHub is designed specifically for password-protected Indian bank statement PDFs. It accepts the password directly, decrypts the file in your browser, extracts the transaction data, and lets you download an Excel file — all without uploading your statement to any server. This is the fastest and most privacy-preserving method.

  1. Go to statementhub.in in your browser.
  2. Click Drop your PDF here or drag your bank statement PDF into the upload area.
  3. When the password prompt appears, enter the password for your bank (see the table above).
  4. StatementHub decrypts and processes the file in your browser. A preview of your transactions appears within seconds.
  5. Click Download Excel to save the structured data as an .xlsx file.

StatementHub supports password-protected statements from SBI, HDFC, ICICI, Axis, Kotak, PNB, Canara Bank, Bank of Baroda, and most other major Indian public and private sector banks. For multi-bank statements, it automatically detects the format.

💡

Privacy note: StatementHub processes everything in your browser using JavaScript. Your statement PDF and the password you enter never leave your device. There is no server upload, no cloud storage, and no account required.

Method 2: Unlock PDF First, Then Convert

If you prefer to work with an unlocked PDF, you can remove the password using a desktop PDF editor or an online PDF tool, then use any Excel conversion tool on the resulting file. This is a two-step process with a significant privacy caveat.

Using Foxit PDF Reader (Free, Desktop)

  1. Open the password-protected PDF in Foxit PDF Reader.
  2. Enter the password when prompted.
  3. Go to File → Properties → Security.
  4. Change the Security Method to No Security.
  5. Save the file. The new PDF has no password.
  6. Upload the unlocked PDF to StatementHub or any other converter.

Using Online PDF Unlock Tools

Several online tools can remove PDF passwords. You supply the file and the password; they return an unlocked PDF. Common options include Smallpdf, ILovePDF, and PDF2Go.

⚠️

Important privacy risk: Online PDF unlock tools require you to upload your bank statement to a third-party server. Your financial data — account numbers, balances, transaction history — is transmitted over the internet and stored temporarily on their servers. For personal bank statements, this is a meaningful privacy risk. Use a desktop tool or StatementHub’s direct-password approach instead.

Method 3: Adobe Acrobat

Adobe Acrobat (the paid desktop application, not the free Acrobat Reader) can remove PDF encryption and also has a built-in PDF-to-Excel export feature. If you already have an Acrobat subscription, this is a self-contained solution.

  1. Open the statement PDF in Adobe Acrobat.
  2. Enter the password when prompted.
  3. To remove the password: go to File → Properties → Security → No Security → OK → Save.
  4. To convert to Excel directly: go to File → Export To → Spreadsheet → Microsoft Excel Workbook.
  5. Save the Excel file.

Adobe Acrobat's built-in PDF-to-Excel export is decent for simple statement layouts but often misaligns columns in complex multi-column Indian bank statements. For better accuracy on Indian bank formats, use the Acrobat method to remove the password, then run the unlocked PDF through StatementHub for extraction.

Troubleshooting: Wrong Password Errors

If none of the password formulas in the table work, try these diagnostic steps before concluding the password is unknown:

  • Check the statement email. Banks usually include the password formula in the same email that delivers the statement. Read the email carefully — the formula is often in the last line or in a "how to open this file" note.
  • Verify your date of birth format. Some banks use DDMMYYYY (8 digits), others use DDMMYY (6 digits). If one format fails, try the other.
  • Check for uppercase requirements. SBI passwords use uppercase letters. If your name has lowercase letters in the formula, convert them to uppercase.
  • Try without spaces or special characters. If your name has a space (e.g., "Rahul Kumar"), try just the first five letters without the space (RAHUL).
  • Generate a new statement. If you have been trying to open an older statement and the password is not working, generate a fresh one from net banking. The formula is the same, but the fresh download rules out a corrupted file.
  • Contact your bank. If all else fails, call the bank's customer care or visit the branch. They can verify the password formula for your account and reissue a statement if needed.

Security Tips When Handling Protected Statements

  • Never share the unlocked version by email. If someone asks you to share your bank statement, send the password-protected PDF and communicate the password through a separate channel (phone call, WhatsApp).
  • Prefer browser-based tools over cloud upload tools. StatementHub processes statements entirely in your browser — no upload means no exposure risk.
  • Delete unlocked copies after use. If you create an unlocked copy for a conversion step, delete it after you have the Excel file. Keep the original password-protected PDF for your records.
  • Store passwords in a password manager. Your bank statement password is derived from personal data you already know, but writing it in a dedicated password manager entry avoids having to look it up every time.

Got a statement ready?

Drop in the PDF, get a clean spreadsheet back. Free, unlimited, and nothing is ever uploaded.

Convert a statement