Back to all posts
Convert Amex Statement to CSV - Free Tool (2026)

Convert Amex Statement to CSV - Free Tool (2026)

Published on March 10, 2026 by CapyParse Team

American Express is the largest charge and credit card issuer in the United States by spend volume. Whether you carry an Amex Platinum, Gold, Blue Cash Preferred, or a Business card, chances are you've needed to get your statement data into a spreadsheet. This guide covers every method for converting Amex PDF statements into CSV, Excel, or QBO format, so you can reconcile expenses, import into QuickBooks, or run your own analysis.

Quick Summary

Amex offers a limited CSV download through its Activity page, but it only covers roughly 12-18 months and excludes official statement data. For full statement conversions, especially older statements or charge card PDFs, CapyParse converts Amex PDFs to clean CSV, Excel, or QBO files in seconds with 99%+ accuracy.

Can You Download CSV Directly from Amex?

Yes, partially. If you log into americanexpress.com and navigate to your account's Activity page, you'll find a Download option that lets you export transactions as CSV, QFX (Quicken), or OFX.

However, Amex's built-in export has several limitations you should know about:

  • ~12-18 month cap: The Activity download only covers roughly the last 12 to 18 months of transactions. Anything older is unavailable through this method.
  • No official statement data: The Activity export is a live transaction feed, not your official monthly statement. Statement summaries, fees, rewards data, and billing cycle details are excluded.
  • Pending transactions excluded: Only posted transactions appear in the download. Any charges still processing will be missing from the file.
  • No scanned-statement support: If you have paper Amex statements that you've scanned, the online download feature obviously can't help.

For anything beyond the last 12-18 months, or when you need the exact data from an official statement PDF, you'll need to convert the PDF itself. For a broader overview of downloading bank statements as CSV across different institutions, see our guide to downloading bank statements as CSV.

Amex Statement Formats and Quirks

Before you convert, it helps to understand how American Express structures its statements. Not all Amex PDFs are the same, and the layout varies depending on whether you have a charge card or a credit card.

Feature Platinum/Gold (Charge Cards) Blue Cash/EveryDay (Credit Cards) Business Cards
Date format MM/DD MM/DD MM/DD
Amount columns Single amount column Single amount column Single amount column
Statement sections Charges, Payments, Credits, Fees, Rewards Summary Charges, Payments, Credits, Fees, Rewards Summary Charges, Payments, Credits, Fees, Rewards Summary
Billing cycle Pay-in-full (balance due each month) Revolving balance (minimum payment) Varies (pay-in-full or revolving)
Multi-card PDFs Sometimes (authorized users) Sometimes (authorized users) Yes (employee cards)

Key things to know: Amex uses MM/DD dates on all statement types since each statement covers a single billing cycle. American Express provides up to 10 years of downloadable PDF statements through online banking. Business cards often include employee card sub-sections, and charge card statements require payment in full each month rather than carrying a revolving balance.

Convert Amex PDF to CSV with CapyParse (Step-by-Step)

Here's how to convert any Amex statement PDF into a clean CSV, Excel, or QBO file using CapyParse:

Step 1: Download Your Statement from Amex

Log into americanexpress.com, go to your account, and click Statements & Activity. Select the billing period you need and download the PDF. Repeat for each month you want to convert.

Step 2: Upload to CapyParse

Go to CapyParse's bank statement converter. Drag and drop your Amex PDF (or click to browse). You can upload multiple statements at once if you need to batch-process several months.

Step 3: Review Extracted Transactions

CapyParse uses AI-powered extraction to identify every transaction on your Amex statement: dates, descriptions, amounts, and transaction types. Review the results in the interactive preview. If your statement includes multiple cardmember sections, CapyParse separates them automatically.

Step 4: Download Your File

Click Export and choose your format: CSV for spreadsheets, Excel (.xlsx) for multi-sheet workbooks, or QBO for direct QuickBooks import. For multi-card statements, CapyParse bundles everything into a ZIP file with separate files per cardmember.

Convert Your Amex Statement Now

Upload your Amex PDF and get a clean CSV in under 30 seconds. 10 free pages included.

Convert Amex Statement

Amex Credit Card and Charge Card Differences

American Express is unique among card issuers because it offers both charge cards (Platinum, Gold, Green) and credit cards (Blue Cash Preferred, EveryDay, Hilton, Delta). The distinction matters when converting statements.

Charge Cards (Platinum, Gold, Green)

Amex charge cards require you to pay the full balance each billing cycle. Their statements typically show a single total amount due with no minimum payment line. Transactions are grouped into sections: New Charges, Payments Received, Other Credits, and Fees. CapyParse recognizes these sections and correctly classifies each transaction type in your export.

Credit Cards (Blue Cash, EveryDay, Co-Branded)

Amex credit cards like Blue Cash Preferred, EveryDay, Hilton Honors, and Delta SkyMiles cards carry a revolving balance with minimum payment requirements. Their statements include interest charges, APR details, and a minimum payment warning table. CapyParse handles both layouts and normalizes the output into a consistent format for your accounting software.

For more details on converting credit card statements from different issuers, see our complete guide to converting credit card statements to CSV.

Import Into QuickBooks, Excel, or Google Sheets

QuickBooks

Export your Amex statement as a QBO file from CapyParse and import it directly into QuickBooks via Banking > Upload transactions. Or use the CSV export and map the columns manually. For a detailed walkthrough, see our guide on importing bank statements into QuickBooks.

Excel and Google Sheets

The CSV export opens directly in Excel or Google Sheets. All transaction fields (date, description, amount, category) appear in separate columns, ready for sorting, filtering, pivot tables, or custom formulas. The Excel (.xlsx) export is also available if you prefer native spreadsheet formatting.

Not sure which format to choose? Check out our comparison of QBO, OFX, and CSV formats to pick the right one for your workflow.

Tips for Amex Conversions

Batch Processing

Converting a full year of Amex statements? Upload all 12 PDFs at once instead of one at a time. CapyParse processes them in parallel and keeps the results organized.

Foreign Transactions

Amex statements show foreign transactions with the original currency amount and the converted USD amount. CapyParse captures both values so you can reconcile international spending accurately.

Membership Rewards

Amex statements include a Membership Rewards summary section showing points earned, redeemed, and your total balance. CapyParse extracts this data alongside your transactions so you have a complete picture.

Password-Protected PDFs

Some Amex statements downloaded via secure message are password-protected. CapyParse can handle password-protected PDFs. Just enter the password when prompted during upload.

Frequently Asked Questions

Can I download Amex statements as CSV directly?

Yes, Amex lets you download recent activity as CSV from the Activity page, but this is limited to roughly 12-18 months of transaction history. It exports transaction data, not your official monthly statement. For older statements or full PDF statement data, you need a converter like CapyParse.

Does CapyParse work with Amex charge cards and credit cards?

Yes. CapyParse handles all American Express card types including Platinum, Gold, and Green charge cards as well as Blue Cash, EveryDay, and other credit cards. It correctly parses charges, payments, credits, fees, and rewards summaries.

How far back can I get Amex statements?

American Express provides up to 10 years of PDF statements through online banking. The CSV activity download only goes back about 12-18 months. To convert older PDF statements into spreadsheet format, upload them to CapyParse.

Can I convert multiple Amex statements at once?

Yes. You can upload multiple Amex PDF statements in a single batch on CapyParse. Each statement is processed individually, and you can download all results at once.

Is it safe to upload my Amex statement to CapyParse?

CapyParse uses encrypted connections (TLS) for all uploads. Files are processed in memory and are not stored permanently. Your financial data is never shared with third parties.

Have a QBO or OFX file from Amex instead?

Amex also offers QFX and OFX downloads for direct import into financial software. If you have a QBO or OFX file, use our free QBO to CSV converter to convert it to CSV or Excel. No signup required.

Ready to Convert Your Amex Statements?

Try CapyParse free and convert your Amex statements to CSV in seconds. 10 free pages to start.

Try CapyParse Free

View pricing for higher volumes.

Related Articles