To turn an HSBC India PDF statement into a usable Excel table, first see whether a CSV or Excel download exists, because it saves most of the work. If only the PDF is available, extract the table, strip the non-transaction rows, convert the dates and amounts to real values, and confirm the sheet reconciles with the statement's closing balance.
Copy and paste or convert: which is better?
Selecting text in a PDF and pasting it into Excel can work for a short statement, but a long one tends to drop columns together. A conversion tool that detects tables usually gives a better start, including Excel's own from-PDF import in recent versions. Whatever you use, treat the output as a first draft and check it. Avoid uploading private statements to sites you do not trust.
We do not claim to know how HSBC India orders its columns. Open the file and list what you see: date, narration, reference, debit, credit, balance, in whatever order they come.
What do I do about a locked PDF?
If the PDF asks for a password, look back at the message that delivered it, because banks usually explain how the password is formed. Type it yourself. Do not send the file and the password together to anyone else. After opening it, you can print it to a new PDF for your own working use, then delete that working copy once the sheet is done.
How do I clean the converted table?
- Remove title rows, address blocks and any opening-balance summary above the header.
- Remove repeated page headers and the page footers that came in as rows.
- Join wrapped narrations. A narration that broke over two lines may appear as a row with a blank date. Move the text up into the row above, then delete the stray row.
- Remove the totals row, if the statement has one, so it is not summed with the transactions.
- Rename columns to short names you will type in formulas: Date, Narration, Debit, Credit, Balance.
How do I fix dates and amounts?
Text dates sit on the left of the cell and refuse to sort. If a date such as 07/04/2026 reads as seventh April in your file, convert it with Data, Text to Columns and the order day, month, year. For text amounts like 1,250.00, use this to test whether Excel sees a number.
- =ISNUMBER(D2) shows TRUE for a real number and FALSE for text.
- If it shows FALSE, use =VALUE(SUBSTITUTE(D2,",","")) in a new column, then copy and paste as values over the old one.
- Wrap blanks safely: =IF(D2="",0,VALUE(SUBSTITUTE(D2,",",""))).
How do I split debit and credit and test the result?
If you have both columns, a single signed amount helps: =N(E2)-N(D2) gives credit minus debit. Total the Credit column, total the Debit column and compare with the statement. Say opening balance ₹55,000, credits ₹1,20,000, debits ₹1,08,400. Then 55,000 + 1,20,000 - 1,08,400 = ₹66,600, and that must match the closing balance printed on the statement.
What should the finished sheet look like?
| Column | Holds | Test |
|---|---|---|
| Date | A real date | =COUNT shows every row is numeric |
| Narration | Text as printed | No blank cells on real transactions |
| Debit | A number or blank | Total matches the statement |
| Credit | A number or blank | Total matches the statement |
| Balance | A number | Used only for the tripwire check |
Once the sheet matches this shape, filters, pivot tables and SUMIFS formulas all work without surprises. Add a Category column on the right, and a Month column using =TEXT(A2,"mmm yyyy") if you want to pivot by month.
Is there a quicker way for monthly use?
If you repeat this every month, the manual clean-up gets old. SpendixAI lets you upload a statement in PDF, CSV or Excel and review the rows before they are saved, which replaces the clean-up for ordinary files. If a layout is unfamiliar it may not read perfectly, so the closing-balance check stays on your list.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

