Bank statements

Credit card statement PDF to Excel: the fastest methods that work

Get an HDFC credit card statement PDF into Excel without retyping: check for a CSV first, try Excel's PDF import, clean the amounts, then verify the total.

Editorial illustration for Credit card statement PDF to Excel: the fastest methods that work

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.

CheckExpected (₹)Your sheet (₹)
Purchases and charges47,890.40=SUMIF(E2:E200,">0")
Refunds and credits1,299.00=-SUMIF(E2:E200,"<0")
Net of the two46,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.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports