Which Credit Cards Export Transactions as CSV, OFX, or QFX (2026)
If you're trying to export your credit card transactions to a spreadsheet or accounting software, you've probably discovered the frustrating truth: most credit cards don't offer a clean CSV, OFX, or QFX download.
Instead, you get a PDF statement. And PDFs aren't importable — not into Excel, not into QuickBooks, not into Xero or Wave or any accounting platform.
This guide covers exactly what each major US issuer actually offers for transaction exports, which formats work with which accounting tools, and what to do when your card doesn't give you what you need.
The Short Answer: Most Credit Cards Are PDF-Only
Before diving into issuer specifics, here's the pattern: debit and checking accounts almost always offer CSV/OFX/QFX downloads. Credit cards usually don't. Banks and card issuers treat credit accounts differently than deposit accounts — and the export options reflect that.
The formats you'll encounter:
| Format | Full Name | Compatible With |
|---|---|---|
| CSV | Comma-Separated Values | Excel, Google Sheets, QuickBooks, Xero, Wave, virtually everything |
| OFX | Open Financial Exchange | Quicken, QuickBooks, Microsoft Money, most accounting software |
| QFX | Quicken Financial Exchange | Quicken (proprietary OFX variant) |
| QBO | QuickBooks Online format | QuickBooks Online only |
| Portable Document Format | Reading only — not importable |
If your card doesn't offer CSV, OFX, or QFX, you need a conversion step to get transactions into your tools. More on that below.
What Each Major Issuer Actually Offers
Chase
Credit card export: PDF only
Chase is one of the most commonly searched because it's one of the most frustrating. For credit cards — Sapphire, Freedom, Ink, and all co-branded cards — Chase provides statements exclusively as PDFs. There is no CSV or QFX download option for Chase credit cards.
Chase does offer CSV, OFX, and QFX downloads for checking and savings accounts (not credit cards). This trips people up regularly: they see the export option in their checking account and assume it applies to their credit card. It doesn't.
Workaround: Download the PDF statement from chase.com > Statements > Download. Convert with a PDF extraction tool to get Excel or CSV. See our Chase statement conversion guide for step-by-step instructions.
American Express
Credit card export: CSV available (limited), OFX/QFX available
Amex is one of the more export-friendly issuers. Through the Amex website, you can download transactions in several formats:
- CSV — available for recent transactions (typically the current statement period and a few months back)
- OFX — available for Quicken and accounting software integration
- QFX — available for Quicken-specific imports
To access these: Log in to americanexpress.com > Account Services > Statements & Activity > Download Your Transactions. You can select a date range and download format.
Limitations: The date range for CSV/OFX downloads varies by account and may not extend to older statements. For historical statements (18+ months back), you may need to fall back to PDF statement exports.
For accountants: Amex Business cards also support direct QuickBooks Online sync through the Amex-QuickBooks integration, which pulls transactions automatically without any manual download.
Capital One
Credit card export: CSV available (90-day window)
Capital One offers CSV downloads for credit card transactions — but with a significant limitation: the export window is typically capped at 90 days of transactions. If you need to export more than three months of history, you'll need to download multiple 90-day chunks or fall back to PDF statements.
To export: Log in to capitalone.com > Your account > View Transactions > Download Transactions. Select CSV format and date range.
Capital One does not offer OFX or QFX exports for credit cards.
For accountants: The 90-day limitation is a real constraint for year-end work or catch-up bookkeeping. If you need a full year's transactions, download four quarterly PDFs and convert them, which is often faster than stitching together four CSVs.
Citi
Credit card export: OFX available (limited), PDF for statements
Citi offers OFX downloads for some credit card accounts through their transaction download feature. The availability and date range varies by card type and account standing.
To check: Log in to citi.com > Account Details > Download. If the option is available for your account, you'll see format options including OFX.
Practical reality: Many Citi cardholders find the OFX export is unreliable or limited to recent periods. PDF statement downloads are consistently available going back several years. For reliable historical data, PDF conversion is typically the more dependable path.
Discover
Credit card export: PDF only (QFX discontinued)
Discover used to offer QFX downloads, making it a popular choice for Quicken users. That changed: Discover discontinued QFX exports in 2022. Credit card statements are now PDF-only.
Discover does offer a transaction search and basic activity view on their website, but there's no download button for CSV, OFX, or QFX format. The only download available is the PDF statement.
For accountants: This is a common point of confusion — older online guides may still say Discover supports QFX. As of 2026, it doesn't. Convert the PDF statement instead. Our Discover statement guide covers the process.
Bank of America
Credit card export: OFX available, PDF for statements
Bank of America offers OFX downloads for credit card transactions, which is useful for Quicken users. CSV is not offered as a standard export format.
To access: Log in to bankofamerica.com > Accounts > Transactions > Download > Select format (OFX) and date range.
Limitation: The download range is typically limited to recent activity. For full statement history — especially for tax-year lookups — PDF statement downloads remain the reliable option.
Wells Fargo
Credit card export: OFX and QFX available (limited range), PDF for statements
Wells Fargo offers OFX and QFX exports for credit card accounts. This makes it one of the better options for Quicken users and accountants who need machine-readable transaction data.
To access: Log in to wellsfargo.com > Account Activity > Download Account Activity. Select format (OFX, QFX, or direct connect) and date range.
For Excel users: Wells Fargo's OFX export isn't directly importable into Excel — it requires Quicken or accounting software. If you need Excel or CSV format, you'll need to convert the OFX or download the PDF statement and extract it.
US Bank
Credit card export: OFX and QFX available
US Bank offers OFX and QFX downloads for credit card accounts, similar to Wells Fargo. Log in to usbank.com > Account Details > Download Transactions.
The date range for OFX exports is typically 12-18 months. For older history, PDF statements are available.
Other Issuers
Most other US credit card issuers — including Barclays, Synchrony, store credit cards, and credit union cards — provide PDF statements only with no CSV, OFX, or QFX export option.
Regional banks and credit unions occasionally offer OFX through Quicken Direct Connect, but this requires a paid Quicken subscription and is card-specific. Check your issuer's download or export section to see what's available.
Summary: Which Cards Offer Native Exports?
| Issuer | CSV | OFX | QFX | |
|---|---|---|---|---|
| American Express | Yes (limited dates) | |||
| Wells Fargo | ||||
| US Bank | ||||
| Bank of America | ||||
| Capital One | Yes (90-day limit) | |||
| Citi | Some accounts | |||
| Chase | ||||
| Discover | ||||
| Most others |
The Problem With Native Exports (Even When Available)
Even when your card does offer CSV or OFX downloads, there are common limitations:
Date range caps. Capital One's 90-day CSV limit is the most well-known, but others have similar restrictions. For year-end accounting or multi-year lookups, native exports often fall short.
Inconsistent availability. Citi's OFX export works for some accounts but not others, and may disappear after card changes or account restructuring. You can't build a reliable workflow around it.
Not all columns you need. Native CSV exports often include date, description, and amount — but not category, reference number, or merchant category code. If you need enriched data, the raw export may not be enough.
No batch processing. Most issuers require you to log in and download each month or date range individually. For a bookkeeper managing 12 months of data for a client, that's 12 separate downloads per card.
Format compatibility issues. OFX and QFX formats need Quicken or accounting software — they're not directly openable in Excel. If your workflow is spreadsheet-based, you need CSV, which most issuers don't offer.
What to Do When Your Card Doesn't Export CSV or OFX
The universal workaround is PDF statement conversion. Every issuer provides PDF statements — most going back 5-7 years — and AI-based conversion tools can extract the transaction data accurately in seconds.
The workflow:
- Download your PDF statement from your issuer's website (available for all cards, all date ranges)
- Upload the PDF to CreditCardToExcel — AI extracts every transaction in 10-30 seconds
- Download as Excel (.xlsx) or CSV
The output includes Date, Description, Amount, and Category columns — ready for Excel, or importable into QuickBooks, Xero, Wave, FreshBooks, Sage, or any other accounting platform.
This approach has several advantages over native CSV exports:
- No date range limits — convert statements from any year
- Consistent format — same output structure regardless of issuer
- Batch processing — convert multiple months at once (Pro and Business plans)
- Works for every card — Chase, Citi, Discover, store cards, credit union cards — if it has a PDF statement, it works
For Accountants: The Most Reliable Approach
If you're managing credit card data for clients — especially during tax season or for catch-up bookkeeping — building around PDF conversion rather than native exports makes sense.
Native CSV and OFX downloads are convenient when available, but they're inconsistent across issuers, have date caps, and require logging into each client's card portal separately. A PDF-based workflow is:
- Issuer-agnostic — one tool handles Chase, Amex, Capital One, and every other card
- History-complete — access to years of statement PDFs, not just 90 days
- Auditable — the PDF statement is the legal document; your extracted data traces directly to it
- Client-friendly — clients can email you their downloaded PDFs without sharing account credentials
For more on how accountants use statement conversion in practice, see our guide on how accountants use PDF statement conversion.
Which Accounting Platforms Accept Which Formats?
If you do have native CSV or OFX exports, here's what each major platform accepts:
| Platform | CSV | OFX | QFX | QBO |
|---|---|---|---|---|
| Excel / Google Sheets | ||||
| QuickBooks Online | ||||
| Xero | ||||
| Wave | ||||
| FreshBooks | ||||
| Sage 50 | ||||
| Zoho Books | ||||
| Quicken |
For platform-specific import guides:
- Import credit card statements into QuickBooks
- Import credit card statements into Wave
- Import credit card statements into Xero
- Import credit card statements into FreshBooks
Common Questions
Frequently Asked Questions
American Express has the most complete native export options — CSV, OFX, and QFX are all available for most accounts, with reasonable date ranges. Wells Fargo and US Bank are good options for OFX/QFX. Capital One offers CSV but limits the range to 90 days. Chase, Discover, and most store cards don't offer CSV for credit card accounts at all.
Regulatory and system architecture reasons. Debit and checking accounts fall under different rules (Regulation E) that require electronic transaction records, which drove banks to build downloadable formats. Credit cards are governed by the CARD Act and Truth in Lending, which mandated PDF statement disclosures — not machine-readable exports. Most banks simply never built CSV export on top of their credit card systems.
Not directly. OFX is XML-based and Excel won't open it cleanly as a spreadsheet. You can import OFX into Quicken or QuickBooks, which then offer their own export options — but that's an extra step. For Excel, CSV is the right format. If your card only offers OFX, converting the PDF statement to CSV is often faster than the OFX-to-QuickBooks-to-CSV route.
No. Chase offers CSV downloads for checking and savings accounts only. Chase credit card statements — Sapphire, Freedom, Ink, and all others — are available as PDF only. To get Chase credit card transactions into a spreadsheet, download the PDF statement and convert it using a tool like CreditCardToExcel.
Discover discontinued QFX exports for credit card accounts in 2022. Before that, Discover was a popular choice for Quicken users because of the QFX download. As of 2026, Discover provides credit card statements as PDF only. Convert the PDF to CSV or Excel for use in accounting software.
Download the PDF statement from your issuer's website — every issuer has this, going back years. Upload it to CreditCardToExcel. AI extracts the transactions and downloads them as Excel or CSV in about 30 seconds. This works for every card, every issuer, and any date range. Try it free — no signup required for the first three conversions.
Related Guides
Ready to stop manual data entry?
Convert your credit card statements to Excel in seconds. Free, no signup required.
Try CreditCardToExcel Free