To get an HDFC credit card statement from PDF into Excel, first look for a CSV or Excel download on the statement page. If there is none, use Excel's built-in PDF import (Data, Get Data, From File, From PDF in recent Windows versions), or upload the PDF to an expense tracker that reads statements. Whichever you pick, finish by checking that your rows add up to the statement's own totals.
This page is about what happens after the file lands in the sheet, because that is where most people lose an evening. Statement layouts differ between cards and change over time, so treat the steps below as a method and check them against your own statement.
Which route should you try first?
| Route | Works best when | Catch |
|---|---|---|
| Download as CSV or Excel, if offered | Your card's statement page lists a spreadsheet format | Not every statement or every month offers it; check your own page |
| Excel: Get Data from PDF | You have a recent Excel for Windows and a text-based PDF | Multi-line merchant names and page breaks come in as separate rows |
| Copy and paste from the PDF | A one-off, short statement | Columns collapse into one; you will split them by hand |
| Upload to a statement-reading tracker | You do this every month | Review every row before saving; unusual layouts may not parse perfectly |
A scanned image of a statement, as opposed to a downloaded PDF, will not import cleanly by any of these routes. Download the PDF itself from your card account instead of photographing a paper copy. If the file is locked, open it with the file password your bank has set for it, and change nothing else about the file.
What does the clean-up look like in Excel?
After the import you will usually see dates as text, amounts as text with commas, and credits marked with a Cr suffix. Fix these in helper columns so the original stays untouched. Say column A holds the date text 14/03/2026 and column D holds the amount text.
- Real date from dd/mm/yyyy text: =DATE(RIGHT(A2,4), MID(A2,4,2), LEFT(A2,2))
- Amount as a number, with Cr turned negative: =IF(RIGHT(TRIM(D2),2)="Cr",-1,1)*VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRIM(D2),"Cr",""),",","")," ",""))
- Merchant text tidied: =TRIM(UPPER(B2))
- Blank-row flag after a page break: =IF(AND(A2="",D2=""),"drop","keep")
Fill these down, then paste the results as values into a fresh sheet before sorting. Sorting a sheet where formulas point at neighbouring rows is how rows get scrambled.
A worked example with made-up numbers
Suppose the statement lists four purchases and one refund. After clean-up the amounts read 2,499.00, 640.50, 11,200.00, 899.00 and a 1,200.00 Cr.
- Purchases: 2,499.00 + 640.50 + 11,200.00 + 899.00 = 15,238.50.
- Refund: 15,238.50 − 1,200.00 = 14,038.50 net spend.
- Find the purchases total printed on the statement and compare it with your 15,238.50, then the credits with your 1,200.00.
- If they differ by exactly one row's amount, a row was dropped or doubled at a page break. If they differ by a small odd amount, look for a fee or interest line that your import skipped.
That reconciliation takes two minutes and is the only proof that the conversion worked. A sheet that looks right but is short by one ₹11,200 purchase is worse than no sheet.
Why do some rows come in broken?
- Long merchant names wrap onto a second line, which becomes a second row with no amount.
- Foreign-currency purchases carry the original currency amount in a separate column next to the rupee amount; make sure you sum the rupee column only.
- EMI conversions and fee lines may sit in a different block of the statement from ordinary purchases.
- Reward-point summaries and payment-due boxes get imported as rows. Delete them.
Can this be less manual every month?
If you repeat this monthly, a tool built for statements saves the clean-up. SpendixAI accepts card statements as PDF, CSV or Excel; you choose the account first, review the parsed rows before saving, and possible duplicate imports are flagged, which matters when two overlapping statements get uploaded. It does not connect to your bank and never asks for net-banking logins. Do not assume every layout will parse perfectly, which is exactly why the review step exists. You can then export to CSV and keep the sheet for your own pivots.
A short routine
- Download the PDF the day the statement is generated.
- Import, clean, reconcile the three numbers.
- Name the file with the statement month, such as 2026-03-hdfc-card, and keep the PDF beside the sheet.
- Fix wrong categories now, not at year end.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

