How to convert a State Bank of India statement PDF to Excel

Step 1 — Download the statement from SBI

Log in to OnlineSBI → My Accounts → Account Statement → select the period → choose PDF. Choose the widest period you need — the analyzer handles a full financial year in one file, so there is no benefit to downloading month by month.

Step 2 — Have the password ready if the file is locked

SBI typically issues the statement unlocked from OnlineSBI, but statements emailed to you are locked with your date of birth in DDMMYYYY format. You do not need to remove the password yourself: the analyzer has a built-in unlock step where you enter it once.

Step 3 — Upload it

Open the bank statement analyzer and drop in the PDF. The bank is detected automatically, so there is nothing to configure. CSV and Excel statements work too if that is what you were given.

Step 4 — Check the verification, then download

Before you download anything, look at the extraction summary: number of transactions found, total credits, total debits, and whether the balance chain verified. If the closing balance matches the statement, every row in between has been read correctly. Then generate the Excel workbook.

What you get

• Transactions — date, narration, cheque number, withdrawal, deposit, running balance, category
• Party-wise summary — counterparties with totals received and paid
• Monthly summary — credits, debits and net movement per month
• Cash transactions — deposits and withdrawals isolated
• High-value report — everything above a threshold you set

What usually goes wrong with SBI statements

SBI statements vary a lot between OnlineSBI downloads, YONO exports and branch printouts, and older branch statements are often scanned images with no text layer. The analyzer detects which variant it is and falls back to OCR when there is no extractable text.

Frequently asked

Other banks

HDFC · SBI · ICICI · Axis · Federal Bank · Kotak