Convert a credit card statement PDF to Excel
Credit card statements are designed to be read, not analysed. The transaction list sits between summary boxes, reward tables and offers, and merchant names are truncated in odd ways. If you want to know where the money went this year, you need the transactions in a spreadsheet.
Why this is painful by hand
- Summary boxes and reward tables above the transaction list end up mixed into the data.
- Credits and refunds are marked with "CR" rather than a minus sign, so totals come out wrong.
- Statements for cards with add-on holders list several card numbers in one PDF.
- Foreign currency transactions show two amounts on one line.
How to convert it
- Download the monthly statement PDF from your card app or the email from the issuer.
- Drop it here. Most issuers protect the file with a password printed in the email.
- Preview the transaction table and download the .xlsx.
What you get
A clean transaction table with date, merchant, amount and CR markers handled as negative values. Add a Category column in Excel and a pivot gives you monthly spending by category.
Questions
Which card issuers work?
Any issuer that sends a PDF statement: HDFC, SBI Card, ICICI, Axis, Amex, Citi and others. The engine does not depend on a per-issuer template.
Can I combine twelve monthly statements into one sheet?
Convert each PDF, then copy the rows into a single workbook. The columns stay consistent for the same issuer.
Is the password stored?
No. It is used only to open the file during conversion.
Related conversions
PDF to Excel Converter is an independent service. Bank, card and software names are used only to describe the PDF formats this converter reads; all trademarks belong to their owners.