Bank statement to Excel › Guides
Convert a credit card statement PDF to CSV
Credit card statements differ from bank statements: purchases are usually printed as positive numbers, there are two dates per line, and there is often no running balance. Here is how to get a clean CSV of purchases and payments on your own computer.
Verified sample The sample below was produced by running this site's converter on a synthetic card statement. It is not real data.
Steps
- Download the statement PDF from your card issuer. It must be the PDF the issuer generates, not a photo of a paper statement.
- Open the bank statement converter and drop the PDF on it. Nothing is uploaded; the file is read in your browser.
- Tick "Credit card: positive amounts are purchases". This makes purchases negative (money out) and payments or refunds positive, so the sign means the same as in a bank statement. Leave it off if your issuer already prints purchases as negative.
- Check the columns it found. The page says which columns it used. With a transaction date and a post date, the transaction date becomes the Date column.
- Check the preview against the statement. A card statement has no running balance to check against, so compare the totals: the sum of purchases in the preview should match the statement's purchases total.
- Download CSV or Excel. With several statements, tick "Combine files into one list" to get one sheet for the year.
Sample: a synthetic card statement
Date Description Amount 2026-04-02 TRANSFER TO SAVINGS -300.00 2026-04-03 TRANSFER FROM SAVINGS 36.50 2026-04-04 INTEREST PAID 1830.25 2026-04-05 RENT PAYMENT LANDLORD LLC -4.75 2026-04-07 COFFEE HOUSE 0098 -62.18 2026-04-08 ELECTRIC UTILITY AUTOPAY -54.32
28 transactions. Positive amounts were treated as money out (credit-card style).
What to check
- Without a balance column there is no automatic proof that every row was read correctly, so the total check above matters.
- Foreign-currency lines, installment plans and rewards summaries vary a lot between issuers; check those rows by eye.
- Scanned statements are not supported.