How to convert a credit card statement PDF to Excel
Getting card transactions out of a PDF statement looks like a copy-and-paste job until you try it. Payments land in the amount column with the wrong sign, interest summaries turn up as fake transactions, and a page break swallows a row. Here are four ways to do it, from free to fastest, plus the one check that proves your spreadsheet matches the statement.
Why card statements are harder than bank statements
- Activity is split into sections. Amex lists Payments, Credits and New Charges separately. Chase groups Payments and Other Credits, Purchases, Fees and Interest Charged. Citi and Capital One have their own layouts, and business cards repeat sections for each employee card.
- Two dates per row. Many issuers print a transaction date and a posting date ("Aug 3 Aug 4"). Tools that expect one date per row shift every column by one.
- Credits are marked differently. A minus sign, "- $", "CR" or a separate section. Miss one and a $500 refund becomes a $500 charge.
- Things that look like transactions but aren't. Interest charge calculation tables, rewards summaries, "minimum payment warning" tables and year-to-date fee totals all contain dates and amounts.
- Missing years. Rows often show only month and day. A December–January statement needs the right year on each side.
Option 1: download a CSV from the card issuer (free)
If the activity is recent, skip the PDF entirely. All four big US issuers let you export activity from their websites:
| Issuer | Where to look |
|---|---|
| American Express | Statements & Activity, then the download icon. Choose CSV or Excel and a statement period. |
| Chase | Open the card account, select the download icon above the transactions, then choose CSV and a date range. |
| Capital One | Open the card, then View Statements / Transactions, then Download Transactions (CSV). |
| Citi | Open the card, then Account Activity, then Download, then choose CSV and a time period. |
The catch is history. Issuers only let you download a limited window, usually the past year or two, and it varies. For closed cards, older years, or statements a client emails you, the PDF is all you have. Menus also move around, so if a label differs, look for a download icon near the transaction list.
Option 2: Excel's built-in PDF import (free with Microsoft 365)
Excel for Microsoft 365 on Windows can pull tables out of a PDF:
- Data > Get Data > From File > From PDF, then pick the statement.
- In the Navigator, tick the tables (often one per page) that hold transactions, then Transform Data.
- In Power Query, append the page tables, remove header and summary rows, and split any merged date columns.
- Close & Load, then fix the amount signs (see below).
It works well on simple, single-column layouts. On card statements it often splits a section across pages, merges the two date columns, or drops multi-line merchant descriptions into the next row. Expect 10–20 minutes of cleanup per statement. Check the result with the balance formula below before you trust it.
Option 3: copy and paste (free, slow)
Select the transaction text in a PDF reader, paste it into Excel, and use Data > Text to Columns. This only works on text-based PDFs, and pasted columns usually collapse into one, so you'll be splitting on spaces and repairing merchant names that contain spaces. It's fine for one short statement and painful for a year of them.
Option 4: a statement converter
Purpose-built converters read the layout rather than guessing at tables. When you compare them, the question that matters isn't "does it produce rows?" (they all do) but "does it prove the rows are complete?" A good one reconciles the extracted transactions against the statement's previous and new balance and tells you when they don't match.
Amex, Chase, Capital One and Citi card PDFs to Excel
Utilly reads card statement layouts, including split sections, two-date rows and CR/minus credits, and checks every file against the New Balance. Preview free with no sign-up, then download Excel, CSV, QuickBooks (.QBO, .IIF) or Quicken .QIF.
Amex to Excel Chase card Capital One card Citi cardThe balance check: prove nothing is missing
Every card statement prints a summary: Previous Balance, Payments and Credits, Purchases (sometimes with Cash Advances, Balance Transfers, Fees and Interest listed separately), and the New Balance. Your spreadsheet should rebuild that summary to the cent.
Pick a sign convention first
For bookkeeping, the usual convention is charges, fees and interest negative (money out) and payments and credits positive. The issuer prints the opposite, because to them a charge increases what you owe. If your column came out the issuer's way, flip all of it at once: put =-C2 in a helper column and fill down.
Then check the total
With amounts in column C (charges negative), the statement's previous balance in F1 and new balance in F2:
=ROUND(F1 - SUM(C:C) - F2, 2)The result must be 0. Because charges are negative, subtracting the sum adds them to the balance owed and takes payments off. If you get something else:
- Exactly double an amount on the statement: that row has the wrong sign (usually a credit read as a charge).
- Exactly one amount: that row is missing or duplicated. Look at page breaks first.
- Equal to the interest or fee total: the Fees or Interest Charged section wasn't captured.
Importing the result
For QuickBooks Online you can upload the Excel data as a CSV (3 columns: Date, Description, Amount). QuickBooks Online can also read card PDFs directly now. Either way, compare the result with the statement before you save. QuickBooks Desktop needs a .QBO (supported versions) or an .IIF file. Xero accepts CSV, OFX, QBO, QFX and QIF. Our file format guide explains which to pick.
FAQ
Why do card payments come out with the wrong sign?
Issuers print payments and credits as negative numbers (or with CR) because they reduce what you owe. In a bookkeeping file you usually want charges negative (money out) and payments positive. Pick one convention and flip the whole column if needed. Don't fix rows one by one.
Can Excel open a PDF directly?
Excel for Microsoft 365 on Windows can import tables from a PDF with Data > Get Data > From File > From PDF. It works on simple layouts but often splits a statement into one table per page and misreads multi-line descriptions, so plan to clean up.
What about scanned statements?
A scanned (image) PDF has no text layer, so table tools see nothing. You need OCR first, and then you need to check every amount, which is where the balance check matters most.
How do I know nothing was missed?
Previous balance minus payments and credits plus purchases, fees and interest must equal the new balance on the statement. If your spreadsheet doesn't hit the new balance to the cent, a row is missing, doubled or has the wrong sign.
Can I download a CSV instead?
Usually, for recent activity. Amex, Chase, Capital One and Citi all let you download activity as CSV or Excel from their websites, but only for a limited history. Older months, closed cards and statements a client emails you often only exist as PDFs.