Getting started

SBI statement PDF to Excel: steps, cleanup and checks

Turn an SBI account statement PDF into an Excel sheet you can sort and total: check the PDF type, convert, clean columns and verify the balance.

Editorial illustration for SBI statement PDF to Excel: steps, cleanup and checks

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

  1. If the PDF is protected, open it with the opening code the bank told you and save an unprotected copy on your own device.
  2. 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.
  3. If that is not available, select the table in the PDF reader, copy it and paste it into one column of a blank sheet.
  4. 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.

CheckHowPass when
Row countCompare the number of data rows with the page totals if the PDF lists themCounts 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
BalanceOpening minus debits plus creditsEquals 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.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports