The question: how do I get my ICICI or SBI credit card statement into Excel when the descriptions wrap onto a second line and the converter turns each wrap into a junk row? Short answer: you can, but expect to do a little clean-up yourself, and always check the total against the statement before trusting the sheet.
Step by step, the way we would do it
- Download the statement as a PDF from your own card account. We will not describe your bank's menus because they change; look for statements in the card section.
- Convert or paste it into a spreadsheet. Whatever tool you use, put the raw output on its own tab and never edit it directly.
- Look at how the wrapped lines landed. Usually the first row has date, description and amount, and the continuation row has only text in the description column with no date and no amount.
- Join each continuation row to the row above it, using the helper formula below.
- Hide or delete the rows you no longer need, then compare your total with the statement.
The helper formula
Say column A has the date, column B the description and column C the amount, with row 1 as the header. In D2, type:
=IF(A2="","",B2&IF(AND(A3="",B3<>"")," "&B3,""))
Fill it down. Any row with a date gets its own description plus the next row's text when that next row has no date. Rows without a date return blank, so you can filter column D for non-blank values and copy just those. If a description wraps onto two continuation lines, add a second IF for A4 and B4 in the same pattern.
A made-up example
| Date | Description as pasted | Amount in ₹ |
|---|---|---|
| 12/03 | SAMPLE ONLINE MART MUMBAI IN | 1,249.00 |
| - | ORDER REF 88421 | - |
| 14/03 | SAMPLE FUEL STATION PUNE | 349.00 |
| 17/03 | SAMPLE ELECTRONICS HYDERABAD | 2,180.50 |
| - | EMI CONVERSION FEE NOTE | - |
After the formula, column D reads SAMPLE ONLINE MART MUMBAI IN ORDER REF 88421, then SAMPLE FUEL STATION PUNE, then SAMPLE ELECTRONICS HYDERABAD EMI CONVERSION FEE NOTE. The three real purchases add up to 1,249.00 + 349.00 + 2,180.50 = ₹3,778.50. If your statement says the purchases total ₹3,778.50, you are done. If the sheet says ₹3,778.00 you have lost fifty paise somewhere, probably a mangled decimal.
Why does the amount sometimes come out as text?
Because of the thousands comma, or a Cr or Dr marker stuck to the number. Check whether your statement uses such markers. If it does, make a new column that strips them with =VALUE(SUBSTITUTE(SUBSTITUTE(C2,",",""),"Cr","")), and decide in a separate column whether the row is a payment or a purchase. Do not assume which letter means what; read your own statement's legend.
What if we do not want to maintain formulas?
That is fair. A tool that reads statement tables for you saves the work. SpendixAI lets you upload a card statement as PDF, CSV or Excel, choose the card account first, and review the rows before anything is saved. It tidies merchant names as part of categorising. we would not promise that every layout will parse perfectly, so keep the total check either way.
How do I know the sheet is still right next month?
Keep a tiny log on a spare tab. Each month write the statement's printed purchases total, your sheet's total and the difference. A column of zeros tells you the process is holding. The first month a difference appears, you will know to look at that statement's layout before the error spreads into a year of numbers. Layouts are the one thing outside your control, so the log is cheap insurance.
If a continuation line contains a reference number or a note rather than a merchant name, it is harmless in column D. You can still search the sheet for the merchant name later, because it sits in the same cell as the reference.
Quick sanity list
- Row count looks plausible against the statement
- Purchases total equals the statement's purchases figure
- No row with an amount and no date
- Payments to the card are kept apart from purchases
Useful ideas start with a clearer picture of your own spending.
Explore your reports


