Credit Card Statement to Excel
Turn a card statement PDF into a list of charges you can sort, filter and total — for a expense claim, a category breakdown, or a year-end review. The statement is read on your device; your spending stays yours.
What makes card statements different
A card statement looks like a bank statement but behaves differently. There is usually no running balance — instead there is a purchase section, a payments and credits section, and an interest and fees section, each with its own table. Charges are printed without a sign; the section they appear in tells you the direction.
Because the converter reads positions rather than assumptions, it returns the transaction table it
finds and keeps the amounts positive, as printed. That is the honest reading: a
$84.12 line under "Purchases" is a purchase, and negating it would be a guess about
how you want to account for it.
Building an expense claim
-
Convert the statement period you are claiming
Month by month is easier than a whole year, because each claim usually has a period.
-
Delete the rows that are not expenses
Payments to your card, balance transfers, interest charges and refunds are not expenses. They are also easy to spot: payments sit in their own section.
-
Add a category column
Merchant names do most of the work. A pivot table on a cleaned-up description — strip the store numbers, keep the brand — gives you a category breakdown in a couple of minutes.
-
Keep the foreign currency detail
If the statement printed an original amount and a conversion, both survive as separate columns. That matters when a policy reimburses at the card's rate rather than today's.
Merchant names arrive as the processor wrote them. That means
SQ *BLUE BOTTLE 4471 and AMZN Mktp US*2H4KJ9. No converter can turn those
into "Blue Bottle Coffee" and "Amazon" without a merchant database, and shipping one would mean
shipping your transactions to it. Clean them in the sheet: sort alphabetically, and the repeated
prefixes collapse into a few find-and-replace passes.
Checking the conversion
Sum the amount column and compare it with the "total purchases" figure printed on the statement. If they match to the cent, the extraction is complete — same self-checking property as a bank statement's balance column. If they differ, count the rows: the gap is usually a transaction whose description pushed it onto a second line.
Privacy, specifically
A card statement is a map of where you physically were, week by week. Uploading one to a free online converter means trusting an anonymous server with that map, plus your card's last four digits and often the full account number. This tool has no server to trust: the file is parsed in the tab, the spreadsheet is assembled in memory, and both vanish when you close it.
FAQ
The refunds are mixed in with the purchases.
Some issuers print them together. Sort by amount or by description and look for the merchant you returned to — refunds usually carry the same merchant string. Or filter the description column for "REFUND", "CR", "RETURN".
Will it work with a statement that has several cards on one account?
Yes, the rows come out in page order. Add a card column yourself if you need to separate them, or convert each card's section separately.
What about the rewards or points summary?
That is a separate small table, usually excluded unless it is the largest numeric block on the page. It has no transaction value, so leaving it out is normally right.
Is there any chance the file is uploaded without my knowing?
No. There is no upload code in the application. Open your browser's Network tab and convert a file — you will see only the page's own assets. If you ever see a request carrying the PDF, that would be a bug worth reporting.