Asked on a forum: I downloaded my HDFC credit card statement as a PDF, how do I get it into Excel? In order of speed: see whether a spreadsheet or CSV download exists, try Excel's own PDF import, copy the rows by hand, or upload the PDF to a tool that reads statements. Whichever you choose, check the result against the statement's total.
Method 1: look for a CSV or Excel download first
Before converting anything, check whether your card issuer offers transactions as a spreadsheet or CSV. we cannot describe any bank's menu, and it changes over time, so look in your own card app or net-banking for a download option and for the format list. A native spreadsheet needs no conversion at all.
Method 2: Excel's PDF import
Recent Microsoft 365 versions of Excel can read tables from a PDF through Data, Get Data, From File, From PDF. The exact menu depends on your version, and older or Mac versions may not have it. It shows the tables it found, and you load the one with the transactions. Text PDFs usually work; scanned pictures do not.
Method 3: copy and paste, then clean
Select the table in your PDF viewer, copy, and paste into a sheet. Often everything lands in one column. Use Data, Text to Columns, and split on spaces carefully, since descriptions contain spaces. This is slower and error-prone for long statements.
Method 4: upload to a statement reader
SpendixAI imports card statement PDFs and parses the rows, and you review them before they are saved. Choose the card as the account first, so each transaction keeps it. Statement import is part of the free plan. As with any parser, odd layouts may need a correction or two.
Cleaning the amounts once it is in Excel
Card statements often show credits differently from purchases. If your amounts arrive as text such as 1,299.00 Cr, or with a Dr marker, use a helper column. For an amount in D2 that ends in Cr when it is a credit, this works:
=IF(RIGHT(D2,2)="Cr",-VALUE(SUBSTITUTE(TRIM(LEFT(D2,LEN(D2)-2)),",","")),VALUE(SUBSTITUTE(D2,",","")))
It turns credits into negative numbers and purchases into positive ones. Check your own file first: if amounts already arrive as numbers, you do not need it, and if your issuer marks credits another way, change the marker in the formula.
Verify before you trust it
Say the statement shows a previous balance of ₹31,250.00, a payment received of ₹31,250.00, new purchases and charges of ₹47,890.40 and a refund of ₹1,299.00. The new amount due should be 47,890.40 - 1,299.00 = ₹46,591.40.
| Check | Expected (₹) | Your sheet (₹) |
|---|---|---|
| Purchases and charges | 47,890.40 | =SUMIF(E2:E200,">0") |
| Refunds and credits | 1,299.00 | =-SUMIF(E2:E200,"<0") |
| Net of the two | 46,591.40 | =SUM(E2:E200) |
Column E holds the cleaned amounts. If the net does not match, look for a split row, a missing page or a date that Excel changed.
One caution before you try free online converters: a card statement carries your name, card number fragments and your spending history. Prefer tools that run on your own computer, such as Excel itself, or a service whose privacy terms you have read. Never type your card PIN, an OTP or net-banking login into any converter; a statement tool has no reason to ask for them.
A short decision guide
- Statement is a native CSV or Excel file: use that, nothing else.
- Text PDF and Microsoft 365 Excel: try From PDF.
- Many statements, month after month: use a tool that reads them and lets you review.
- Scanned picture: type it, or ask the issuer for a text version.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

