To get an SBI statement from PDF into Excel, first check whether the PDF is text or a scanned picture. If you can select and copy words from it, Excel's own PDF import or a simple copy-paste can work. If it is a picture, no spreadsheet will read it without OCR, and you should look for a CSV or Excel download from your net banking instead.
Step 1: look at what your bank already offers
Statement download options vary by bank and change over time, so open your own net-banking statement page and see which formats are listed. If an Excel or CSV option is there, use it and skip conversion entirely. A direct download keeps numbers as numbers, which avoids most of the cleanup below. Never hand your login details to a converter website; a statement is your private data, so read any tool's terms first.
Step 2: convert the PDF
- If the PDF is protected, open it with the opening code the bank told you and save an unprotected copy on your own device.
- In recent versions of Excel for Microsoft 365, use the Data tab, Get Data, From File, From PDF, then pick the table that looks like your transactions and load it. Menu names differ between versions, so check yours.
- If that is not available, select the table in the PDF reader, copy it and paste it into one column of a blank sheet.
- Save the file as an Excel workbook before you touch any column.
Step 3: clean the columns
Pasted or imported rows commonly arrive with dates as text, narration split across lines and numbers with commas stored as text. Fix these in order.
- Dates: if a cell is left-aligned, it is text. Use Data, Text to Columns, choose Date, and pick the order (DMY) that matches your statement.
- Amounts: to turn text such as 12,450.00 into a number, use =VALUE(SUBSTITUTE(D2,",","")) in a new column and copy it down.
- Wrapped narration: if a transaction's description spilled onto a second row with no date, move that text up to the row above and delete the stray row.
- Debit and credit: keep them in two columns, or add one signed amount column with =F2-E2 where E is debit and F is credit.
Step 4: how do I know the conversion is correct?
Do a balance check before you trust any total. Say the opening balance is ₹25,000, the debits add up to ₹18,640 and the credits add up to ₹32,000. The closing balance should be 25,000 minus 18,640 plus 32,000 equals ₹38,360. If your sheet's last balance figure differs, a row has been dropped, doubled or mis-parsed.
| Check | How | Pass when |
|---|---|---|
| Row count | Compare the number of data rows with the page totals if the PDF lists them | Counts match |
| Debit total | =SUM(E2:E300) | Equals the bank's total, if shown |
| Credit total | =SUM(F2:F300) | Equals the bank's total, if shown |
| Balance | Opening minus debits plus credits | Equals last balance on the statement |
Can I skip the manual steps?
A spreadsheet is fine for one statement a month. When you have several accounts, SpendixAI accepts bank or card statements as PDF, CSV or Excel, lets you pick the account first, and shows the rows for review before saving, so you are not rebuilding the same cleanup every month. It does not promise every layout will parse perfectly, which is why the review step exists.
Before you close the file
- Keep the original PDF untouched in a folder named by month.
- Add a Category column and sort by narration to tag repeated payees in bulk.
- Record the balance check result in a note on the sheet.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
