To turn a credit card statement into Excel, download the statement as a spreadsheet or CSV if your bank offers one, because converting a PDF is where multi-line descriptions break. Then clean the text with a few formulas and reconcile the total to the statement. Layouts differ between ICICI, SBI and every other card, so check your own statement for the real column names. When a sheet stops being enough, SpendixAI accepts PDF, CSV or Excel statements and lets you review rows before saving.
Why do descriptions break converters?
A long merchant line wraps in the PDF onto a second line. A converter reads that second line as a new row with no date and no amount. Other usual culprits are reward-point columns, foreign-currency lines with an extra row for the original amount, and credit entries marked Cr beside the amount.
Step by step
- Look for a CSV or Excel download on your card account page first.
- If you only have a PDF, convert it, then look for rows with an empty date column.
- Fix or merge those rows by hand.
- Add helper columns with the formulas below.
- Reconcile the total to the statement before you trust anything.
Which formulas help?
Assume raw data in rows 2 to 200: dates in A, description in B, amount in C.
- Clean a description: =TRIM(CLEAN(B2))
- Flag continuation rows: =IF(A2="","continuation","new") in D2
- Merge the next row's wrapped text into this row: =IF(A3="",TRIM(B2&" "&B3),TRIM(B2)) in E2, filled down
- Turn text amounts such as 1,250.00 Cr into signed numbers: =IF(RIGHT(TRIM(C2),2)="Cr",-VALUE(SUBSTITUTE(LEFT(TRIM(C2),LEN(TRIM(C2))-2),",","")),VALUE(SUBSTITUTE(TRIM(C2),",","")))
The last formula assumes amounts end in Cr for credits and have no suffix for debits. If your statement uses another marker, change the text in quotes and the number 2 to match. Put it in a copy of the sheet first.
Worked example: reconciling a small statement
Say six rows after cleaning: ₹1,250, ₹840, ₹2,199, ₹560, ₹3,400 and a refund of ₹840 marked Cr. Debits: 1,250 + 840 = 2,090, plus 2,199 = 4,289, plus 560 = 4,849, plus 3,400 = 8,249. Credits: 840. Net = 8,249 − 840 = ₹7,409. Compare with the statement's total of purchases minus credits. If they differ, a continuation row was dropped or a Cr was read as a debit.
| Row | Description | Signed amount |
|---|---|---|
| 1 | Online order | 1250 |
| 2 | Restaurant | 840 |
| 3 | Electronics | 2199 |
| 4 | Cab | 560 |
| 5 | Travel booking | 3400 |
| 6 | Refund (Cr) | -840 |
In Excel, =SUM(C2:C7) would give 7409 for the table above if the amounts sit in C2 to C7.
What about merchant names?
Raw text often looks like a city code and a reference string after the shop name. Use Find and Replace to remove repeating junk, then make a small two-column table of raw text and clean name, and use a lookup to translate. The app normalises merchant names, and you can add aliases for the stubborn ones.
How do you handle foreign-currency lines?
A spend abroad often prints the original amount and currency on one line, and the rupee amount on the same line or the next. Add a column for currency, copy the original amount there and keep the rupee figure in the amount column. Do not add the two together. If you later move to a tracker that supports it, each expense can keep its own currency while totals use the rate saved with the transaction. Either way, check the rupee column against the statement, since that is what your card was actually charged.
When a sheet stops being enough
If you repeat this every month, the cleaning becomes a chore. SpendixAI lets you pick the account, upload the file, review rows before saving and set categories once. It cannot promise that every layout parses perfectly, so keep your reconciliation habit either way. For tax questions, keep the statement itself and ask your CA, since a spreadsheet is a working copy, not the record.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

