Sheetfold

How to get a credit card statement into Excel

Export the transactions if your card issuer lets you, convert the PDF if it does not, and check the result against the summary every statement prints.

Updated Oct 21, 2026 · 6 min read

The short answer: for recent months, download the transactions as CSV from your card account online and open the file in Excel. For older statements, or when you need exactly what the statement shows, convert the PDF. Then check the result against the summary box printed on most card statements (and on every US one): previous balance, minus payments and credits, plus purchases, fees and interest, equals the new balance.

1. Download the transactions from your card account

Most card issuers let you export activity from their website, and sometimes from the app:

  1. Sign in on the issuer’s website and open the card’s transactions or activity.
  2. Choose the date range or the statement period you need.
  3. Look for Download or Export and pick CSV (sometimes called spreadsheet or Excel format).
  4. Open the file in Excel. If dates or amounts look wrong, use Data, From Text/CSV instead of double-clicking, so you can set the date format and delimiter.

How far back you can go depends on the issuer. Three large US issuers, from their own help pages:

  • Chase: on the website, activity from the last two years downloads as CSV (or QFX, QIF and QBO for accounting software); statements go back up to seven years, as PDFs, depending on the account type.
  • American Express: recent activity and the past six billing statements download as CSV or for Quicken and QuickBooks, and two years of transactions can be downloaded as PDF, Excel or CSV.
  • Citi: statements from the last 12 months download as PDF or as Quicken and Microsoft Money files; online statements reach back up to seven years.

The catches: downloads usually reach back only a limited time, they can include pending charges that are not on any statement, and they carry none of the statement’s totals. Merchant names are often shortened, and foreign purchases may show only the converted amount.

2. Convert the PDF statement

Convert the PDF when the months are older than the download allows, when your issuer offers statements only as PDFs, or when you need the statement exactly as issued, with its period, fees and interest. A bank statement converter reads the rows into Excel; Sheetfold reads card statements from any issuer, in any language, and checks the rows against the statement’s own totals before you download.

General PDF to Excel tools have a harder time with card statements than with bank statements, for reasons worth knowing even if you convert by hand.

Why card statements are harder to convert

  • No running balance. A bank statement prints a balance after every row, so each row can be checked. A card statement lists charges and payments without one, so a missing row leaves no visible gap.
  • Signs work the other way. A purchase increases what you owe; a payment reduces it. Some statements mark credits with CR or a minus, some put them in their own section, and a converter that reads the sign wrong turns a refund into a charge.
  • Several sections. Payments, purchases, fees and interest are often listed separately, sometimes with a section per cardholder for additional cards.
  • Foreign currency lines. A purchase abroad may print the original amount, the exchange rate and the converted amount on two lines, and only one of those numbers belongs in the amount column.

Check the totals

Instead of a running balance, most card statements print a summary, usually on the first page (US issuers must). That summary is the check: add up the rows you converted, by type, and compare each sum with the printed total. When they match, and previous balance plus the rows equals the new balance, no amount was dropped or misread, unless two errors happen to cancel each other out.

Printed on the statementSum of the rows read
Previous balance1,284.501,284.50
Payments ·1 row1,284.501,284.50Matches
Credits and refunds ·1 row25.0025.00Matches
Purchases ·6 rows942.18942.18Matches
New balance917.18917.18Matches
A purchase that sat at the bottom of a page is the classic row to lose. The purchases total catches it, and the new balance is off by exactly that amount.

In Excel, with charges as positive amounts and payments and credits as negative ones, the whole check is a single sum: the total of all rows should equal the new balance minus the previous balance. If it does not, sum each type separately to see which section is off, then look for an amount equal to the difference.

Sheetfold does this for you: it reads the printed totals along with the rows, checks the rows against them, and names the rows to look at when a total does not match. The Excel file it gives you lists money out (purchases, fees, interest) and money in (payments, refunds) in separate columns, with a signed amount beside them, so it works whichever way your books record a card. For QuickBooks, Quicken or Xero, download a QBO, QFX or OFX file instead: purchases arrive as charges and payments as credits, the way those programs expect a card.

Sources, checked 21 October 2026: Chase Spending Planner, Chase paperless statements, American Express downloads, American Express statement history, Citi statements.

Questions

Can I export my credit card transactions to Excel?
Usually yes for recent activity: most issuers offer a CSV download on their website, which Excel opens directly. Older statements are often available only as PDFs, and those need converting.
Why does my credit card statement have no running balance?
Card statements list charges and payments without a balance after each row. They print a summary instead: previous balance, payments and credits, purchases, fees and interest, and the new balance. That summary is what you check a conversion against.
Should payments be positive or negative in the spreadsheet?
Pick one view and keep it. From your cash flow, purchases are money out and payments to the card are money in. On the card’s own balance it is the reverse: purchases increase what you owe. Sheetfold exports separate Money out and Money in columns, plus a signed amount, so either view works.
How do I convert a credit card statement PDF to Excel for free?
A free Sheetfold account converts 5 pages a day: drop the PDF, check the result against the totals it shows, and download Excel, CSV, or a QBO or QFX file for QuickBooks or Quicken.

Try it on your own statement

Drop a PDF here and Sheetfold reads it, then checks every row against the balances your bank printed. A free account converts 5 pages a day.

or drop it here

All guides