Chase Credit Card CSV Export: Formats and Limits

Chase is the largest credit card issuer in the United States. Between Sapphire, Freedom, Slate, the Ink Business family, and co-branded cards like United, Southwest, Marriott, Hyatt, and Amazon, tens of millions of people eventually need the same thing: their Chase credit card transactions in a spreadsheet. This guide covers exactly how the Chase CSV export works, what the file looks like column by column, where the export falls short, and how to get data out of the PDF statements that hold everything the download cannot reach.

This article is specifically about Chase credit cards. If you are working with Chase checking or savings statements, see our Chase bank statement guide instead. Credit card exports behave differently in a few ways that matter, especially around amount signs and available history.

How to Download Chase Credit Card Transactions as CSV

The good news first: the built-in export works, it is free, and for recent transactions it is the fastest option available. Here is the process on chase.com as of mid-2026 (Chase updates its interface periodically, so exact labels may shift slightly).

That is the honest version: five clicks and you have a file. The problems only show up when you look at what is inside the file, and what history the export can actually reach. Both are covered next.

What the Chase CSV Export Looks Like

As of mid-2026, the Chase credit card CSV contains seven columns. They are consistent across Sapphire, Freedom, Ink, and co-branded cards, which is convenient if you manage several accounts.

The Sign Convention: Purchases Are Negative

In the Chase credit card CSV, purchases, fees, and interest appear as negative amounts, while payments and merchant refunds appear as positive amounts. A 42.50 dinner shows up as -42.50, and your monthly payment shows up as a positive number.

This trips people up because it is the opposite of what the paper statement shows. On the PDF statement, charges print as plain unsigned numbers and payments or credits carry the minus sign. Two documents describing the same account use opposite conventions, and both are internally correct. The CSV treats the file like a cash flow ledger (money out is negative), while the statement treats it like a balance you owe (charges increase the balance).

Why this matters: if you paste CSV data next to statement data, or feed either one into a tool that assumes bank account conventions, every transaction can end up pointing the wrong way. Deposits become withdrawals and totals stop reconciling. Keep track of which convention your target system expects before you import anything.

The Type column is more reliable than the sign alone. Filtering on Sale isolates actual spending, Payment isolates what you paid toward the balance, and Return catches refunds that would otherwise inflate a naive sum of positive amounts. If you build any recurring analysis on Chase CSVs, key it off Type rather than guessing from the Amount sign.

The Category Column Is Chase's Taxonomy, Not Yours

The Category column is filled in by Chase using its own labels. They are useful for a quick glance at spending, but they do not map to a QuickBooks chart of accounts, a Xero category list, or your firm's coding scheme. A software subscription might land under Shopping, and a client lunch under Food & Drink. Treat the column as a hint, not as bookkeeping.

The Limits of Chase's Native Export

The CSV download is genuinely useful for recent activity. It also has hard edges that show up exactly when the stakes are highest: tax season, an audit, a loan application, or catching up on years of bookkeeping.

• Limited lookback: The activity download covers roughly the last 24 months. PDF statements, by contrast, are available for up to 7 years. Everything between year 2 and year 7 exists only as PDF.
• One account, logged in: The export works per card, per session. There is no bulk export across all your Chase cards, and no way to pull data for an account you can no longer log into (a closed card, a former employer's account, a client who only sent you PDFs).
• Silent truncation on large ranges: Chase has historically capped large activity downloads at around 1,000 rows without any warning. If your date range holds more transactions than that, the file simply arrives incomplete.
• No running balance: The CSV has a single Amount column and nothing else. There is no balance after each transaction, no previous balance, no new balance, and no interest or rewards summary. Those figures live only on the statement.
• Activity is not the official record: The download is a live transaction feed, not the statement of record. If you are producing documentation for an audit, a lender, or a legal matter, the PDF statement is the document that counts, and its data is what you need in your spreadsheet.

In short: for the last two years of a card you control, the native export is fine. For anything older, anything official, or any account you cannot log into, the data lives in PDF statements. That is the problem CapyParse solves.

Converting Chase Credit Card PDF Statements

Chase keeps up to 7 years of PDF statements available under the Statements section of your account. Converting them to a spreadsheet takes four steps:

One accuracy point worth calling out. As covered above, credit card statements read opposite to bank statements: an unsigned amount on a credit card statement is a charge, and the minus sign marks a payment or refund. A converter built only for bank accounts will flip every transaction. CapyParse detects that a document is a credit card statement and keeps the direction of every transaction correct in the export: charges come out as money spent, payments and refunds as money received. Your totals reconcile against the statement balance instead of mirroring it backwards.

Chase Ink Business and Sapphire Statements

The CSV export format is the same across Chase's card lineup, but the PDF statements differ by product, and so do the questions people ask about them.

Sapphire Preferred and Sapphire Reserve

Sapphire statements group transactions into sections: payments and credits, purchases, fees charged, and interest charged, followed by a rewards summary showing Ultimate Rewards points earned. Travel credits and annual fees appear as their own line items, which matters for anyone splitting personal and reimbursable travel. When you convert a Sapphire PDF with CapyParse, each section's transactions come through as individual rows with the correct type, so fees and interest are easy to categorize separately from spending.

Ink Business Cash, Unlimited, and Preferred

Ink Business statements add a layer that personal cards do not have: employee cards. Purchases are often broken out per cardholder with individual subtotals, and the same employee-level detail is exactly what bookkeepers need for expense allocation. The activity CSV flattens all cardholders into one list; the PDF statement preserves the breakdown. Converting the PDF keeps each transaction row intact so you can filter by cardholder name in your spreadsheet.

Ink Business Premier Export Options

The Ink Business Premier card is Chase's pay-in-full business card, and its data export options are a common point of confusion. As of mid-2026, Ink Business Premier has no dedicated export tool. It uses the same options as every other Chase credit card:

• Activity download from the account activity page in CSV, QFX, or QBO format, with the same roughly 24-month window
• Monthly PDF statements, available for up to 7 years
• Chase's built-in reporting for Ink cards, including spending summaries and around 24 months of statement detail viewable online

You can also connect an Ink Business Premier account to QuickBooks or other accounting software through a bank feed, but feeds only sync from the connection date forward and typically backfill just the most recent weeks or months. For historical Premier data (prior years for taxes, a full spending history for a new bookkeeper, employee card breakdowns from past cycles), the PDF statements are the only complete source, and converting them with CapyParse turns each cycle into a clean spreadsheet or QBO file.

Import Into QuickBooks, Excel, or Google Sheets

QuickBooks

For recent transactions, Chase's own QBO download imports via Banking, then Upload transactions in QuickBooks. For older statements, export a QBO file from CapyParse instead; it imports the same way and QuickBooks treats the account as a credit card, handling charge and payment directions automatically. Full walkthrough in our QuickBooks import guide.

Excel

Both the Chase CSV and the CapyParse CSV or Excel export open directly in Excel. Format the Amount column as currency, and remember the sign convention when writing formulas: with purchases negative, total spending is the sum of negative amounts. A pivot table on the Category or Type column gives you a one-minute spending review.

Google Sheets

In Google Sheets, use File, then Import and upload the CSV. Choose to insert a new sheet and let Sheets detect the separator automatically. Dates and signed amounts come through cleanly, ready for filtering, QUERY formulas, or a shared budget tracker.

Working with cards from other issuers too? Our credit card statement conversion guide covers Amex, Discover, Citi, and Capital One alongside Chase.

Frequently Asked Questions

Related Articles