A Standard Chartered India statement PDF can usually become an Excel sheet in three moves: test whether the PDF holds real text, bring the rows into Excel, then reconcile the result against the opening and closing balances. The reconciliation is the step most guides skip, and it is the only proof that nothing was dropped or merged.
Is my PDF text or just a picture?
Open the PDF and try to select a single transaction line with your mouse. If the text highlights and you can copy it, it is a text PDF and conversion will work. If you can only drag a box over the page, it is a scan or an image, and no Excel import will read it without optical character recognition, which is error-prone for money. In that case, check whether your own net-banking offers a spreadsheet or CSV download instead. Menu names and formats differ, so look at your own statement options rather than trusting a screenshot from someone else's account.
If the PDF is password protected, you open it with the password the bank gave you. Keep that to yourself and never type it into a random online converter.
How do I bring the rows into Excel?
- Excel in Microsoft 365 and recent versions can import a PDF through the Data tab (Get Data, From File, From PDF). It lists the tables it found on each page; pick the transaction tables and load them.
- Older Excel versions lack this. Copy the text out of the PDF reader, paste into one column, then use Data, Text to Columns to split on spaces or a fixed width.
- Google Sheets has no built-in PDF import. Convert in Excel first or paste and split text with the SPLIT function.
- A multi-page statement often arrives as one table per page. Append them into one list so the running order is kept.
What usually breaks after the import?
| Symptom | Why it happens | Quick fix |
|---|---|---|
| Dates sit left-aligned and will not sort | They arrived as text | Use Data, Text to Columns, choose Date, and pick the order that matches your statement |
| Debit and credit amounts in one column with text like Dr or Cr | The layout used letter markers | Add a helper column: negative when the marker says debit |
| Narration split across two rows | A long description wrapped in the PDF | Merge the continuation row into the row above, then delete it |
| Repeated header rows every page | Each page has its own header | Filter on the header word and delete those rows |
| Amounts shown as 1,23,456.00 become text | Indian digit grouping plus stray spaces | Use =VALUE(SUBSTITUTE(TRIM(D2),",","")) in a helper column |
How do I prove the sheet matches the statement?
Use a worked reconciliation with made-up numbers. Say the opening balance is ₹48,200 and the closing balance is ₹39,750. Your sheet shows total credits of ₹62,000 and total debits of ₹70,450.
- Opening balance 48,200 plus credits 62,000 equals 110,200.
- Subtract debits 70,450 to get 39,750.
- That equals the closing balance, so every line came through.
- If you got 39,250 instead, you are ₹500 off. Sort by amount and look for a missing ₹500 row, or a row where the marker was misread.
Do I need to tidy it further before analysis?
Only if you plan to total by category. Add one column for category and fill it for the repeated merchants first, because a handful of names usually cover most of the rows. Leave genuinely unclear lines as Unsorted rather than guessing, and resolve them from your own memory or receipts.
When uploading the PDF directly is easier
Doing this every month is tedious. SpendixAI accepts a bank or card statement as PDF, CSV or Excel, lets you pick the account first, and shows the rows for review before anything is saved. It does not promise every layout will read perfectly, so you still look the rows over, and it never asks for your net-banking login.
Whichever route you take, finish by comparing totals to the statement's own balances. That single check is worth more than any formatting.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

