How to Export an American Express Statement to Excel

You have an American Express card. You need 24 months of history for a tax filing.

It downloads in 30 seconds. The columns are Date, Description, Amount, Category, Card Member, and Reference Number.

The file opens in Excel directly. This is the cleanest export of any major credit card issuer.

This page is the American Express export guide. It covers the 2 download options (PDF and CSV), the difference between personal and business card portals, the multi-card support, and how to use the CSV with QuickBooks or Excel for accounting.

American Express gives you 5 years of monthly PDF statements and 5 years of combined CSV download. The Amex CSV is the cleanest of any major credit card issuer, with Date, Description, Amount, Category, Card Member, and Reference Number as separate columns. The CSV includes all cards on the same account in one file.

Amex does not offer OFX or QBO. For QuickBooks users, the CSV path works (with a small import dance). For Xero or Sage users, the CSV path also works. For users who want the cleanest possible file, the Amex CSV is it.

Personal and business cards are managed through different portals. The personal card portal is at americanexpress.com. The business card portal is at global.americanexpress.com. The export flow is similar but the menus are different.

What American Express Actually Gives You

Amex’s online portal at americanexpress.com gives personal card holders 2 export options. Both are useful in different situations.

What most guides miss about Excel conversion is that the quality depends on the mechanism, not on the tool. Two tools that look different on the surface often run the same 4-step process underneath: read, find, parse, verify. The difference is in how well each step handles edge cases (merged cells, missing balances, non-standard date formats, scanned vs digital input). Choosing between tools based on UI alone misses the actual quality lever.

• Monthly PDF Statements going back 5 years. One PDF per month per card. The PDF has the standard Amex branding, the account summary, the reward point summary, and the transaction list. This is the official statement you would send to a lender.
• Combined CSV Download going back 5 years. This is the cleanest export. The file is a single CSV with all transactions for the date range. It opens directly in Excel or Google Sheets. No conversion needed.

There is no OFX, no QFX, no QBO. For users on QuickBooks, the CSV is the right path, but the import requires a small dance (the Amex CSV uses MM/DD/YYYY dates by default, which QuickBooks may need adjusted).

There is no combined statement feature, but the CSV includes all cards on the same account in a single file. If you have multiple Amex cards (personal + supplementary, or business + employee cards), the CSV has a “Card Member” column that identifies which card made each transaction. This is one of 10 banks covered in our US bank export guide.

How to Download Amex CSV Step by Step

The CSV export is the cleanest path. Here is the click-by-click flow for personal cards.

1. Log into americanexpress.com with your User ID and Password.
2. Click on the card account you want the statement for.
3. Click “Statements & Activity” in the navigation.
4. Click “Download Statements” in the sub-navigation.
5. Choose the date range. The maximum is 5 years.
6. Choose “CSV” as the format.
7. Click “Download”. The file saves to your default downloads folder.

The file is named something like amex_activity_2024-01-15_to_2026-01-15.csv. Open it in Excel. The data is in 6 or more columns, depending on how many cards you have on the account. Done.

I learned this the hard way the first time I had an Amex client who needed 3 years of history for an audit. I downloaded 36 monthly PDFs. Then I found the CSV download, which would have given me everything in one file. The lesson: always check the CSV first, fall back to PDF only if you need a specific month’s official statement.

The 6 Columns in the Amex CSV

The Amex CSV has 6 standard columns, plus more if you have multiple cards. Here is what each column is.

• Date is the transaction date. Format is MM/DD/YYYY. You may need to convert to YYYY-MM-DD for some accounting software.
• Description is the merchant name. Sometimes truncated at 30 characters, but usually full.
• Amount is the transaction amount. Positive for charges, negative for credits (refunds, statement credits).
• Category is the merchant category code, mapped to a human-readable name like “Restaurants” or “Gas Stations”. This is more useful than a raw 4-digit MCC.
• Card Member is the name on the card. For supplementary cards, this identifies which card member made the charge. For single-card accounts, this is the account holder’s name.
• Reference Number is a unique identifier for the transaction. Useful for matching transactions with receipts or disputes.

For multi-card accounts, the CSV includes all transactions across all cards, with the Card Member column identifying which card made each charge. This is unique to Amex. No other major credit card issuer gives you a single file with all cards’ transactions.

How to Download Amex PDF Step by Step

The PDF export is in the “Statements & Activity” section. Here is the click-by-click flow.

1. Log into americanexpress.com.
2. Click on the card account.
3. Click “Statements & Activity” in the navigation.
4. You will see a list of monthly statements going back 5 years.
5. Click the statement you want. The PDF opens in your browser.
6. Save the PDF (Ctrl+S or File > Save).

The PDF is one file per month per card. For 24 months of history across 2 cards, you are downloading 48 files. The PDF is well-formatted and a converter that handles Amex’s standard layout will extract the transactions cleanly.

Amex Business Cards: A Different Portal

Amex business cards (Business Platinum, Business Gold, Blue Business Plus) are managed through a different portal: global.americanexpress.com. The export flow is similar but the menus are labeled differently.

1. Log into global.americanexpress.com.
2. Click on the business card account.
3. Click “Statements” in the navigation.
4. Choose the date range. The maximum is 5 years.
5. Click “Download” and pick “CSV” (preferred) or “PDF” (for official statements).

The CSV format is the same as personal cards, with the same 6 columns. The Card Member column is especially useful for business accounts with multiple employee cards, because it identifies which employee made each charge.

For business credit cards, Amex also offers a “Year-End Summary” feature that gives a single PDF with the year’s transactions aggregated by category. This is useful for tax preparation but not for detailed accounting.

Multi-Card Support: The Unique Amex Feature

If you have multiple Amex cards on the same account (personal card + supplementary card for a family member, or business card + employee cards), the CSV download includes all cards’ transactions in a single file. The Card Member column identifies which card made each charge.

This is unique to Amex. No other major credit card issuer gives you a single file with all cards’ transactions. Discover’s CSV is limited to one card at a time. Capital One’s CSV is the same. Chase’s CSV is the same. Only Amex bundles them.

For users managing multiple Amex cards, this is a significant time saver. One download per quarter (or month) covers all cards. For users managing non-Amex cards, you need to download each card separately and combine the files in Excel.

How to Use the Amex CSV in QuickBooks

The Amex CSV works with QuickBooks Online (QBO) and QuickBooks Desktop, but the import requires a small dance. QBO does not accept the Amex CSV format directly. The workaround:

1. Save the Amex CSV as .xlsx (just rename or open and save in Excel).
2. In QBO, go to Banking > Add account > Upload file.
3. Map the columns: Date to Date, Description to Description, Amount to Amount. The Category column can be ignored (QBO has its own categorization).
4. Click “Import”.

For QuickBooks Desktop, the import is via File > Import > Excel. The same column mapping applies. The Card Member and Reference Number columns are not imported (QBO has no equivalent field), but you can keep them in the .xlsx file for your own reference. Our QuickBooks conversion guide covers the full import dance for both QBO and CSV paths.

The 5-Year CSV Limit (and How to Get More)

Amex’s CSV export goes back 5 years. For most users, that is enough. For some use cases (long-term tax audits, historical financial analysis), 5 years is not enough.

Two ways to get more than 5 years:

1. Download the CSV in 5-year chunks. Run the export for the last 5 years. Then run it for the 5 years before that. Amex’s portal lets you pick any date range, but the maximum span is 5 years. Combine the two files in Excel with a simple append.
2. Request older statements by phone. Call Amex customer service at the number on the back of your card. Ask for statements older than 5 years. They can mail you PDFs or email them. The PDFs will be the older “image statement” format, which is harder to convert.

For most users, 5 years is enough. The 5-year limit is an Amex portal limit, not a banking limit. Older data exists. Getting it requires a phone call.

The 2am Test for Amex Conversions

If you are exporting an Amex statement at 2am, here is the flow that works.

1. Open americanexpress.com. Log in.
2. Click the card. Click “Statements & Activity”. Click “Download Statements”.
3. Set the date range. Choose CSV. Click Download.
4. Open the CSV in Excel. The data is already in 6 columns.
5. Convert the date format to YYYY-MM-DD if needed.
6. Save the file as .xlsx if you want to keep working in Excel.

There is no conversion step. The CSV is the file. This is the easiest export of any major credit card issuer. For PDFs from older history, our general PDF-to-Excel conversion guide covers the broader workflow.

A common failure mode bookkeepers report is treating this as a single operation rather than a chain of dependent steps. The temptation is to find a tool that ‘just works’ and stop investigating the mechanism. The result is a wrong-fix cycle: the tool gives partial output, the bookkeeper spends 30+ minutes troubleshooting, the fix is for the wrong step, and the same error recurs on the next statement. The fix: identify which step failed and apply the right intervention to that step.

What to Do With Multiple Amex Cards

If you have multiple Amex cards on the same account, the CSV export gives you everything in one file. No combining needed. The Card Member column identifies which card made each charge.

If you have multiple separate Amex accounts (e.g., a personal account and a business account), the export flow is similar for each but the portals are different. Log into each portal separately, run the CSV export for each, then combine the two files in Excel. The column structure is the same across both portals.

For users managing many separate Amex accounts, the combined approach is essential. The CSV files have the same column structure across accounts, so combining is just an append operation. Add an “Account” column to identify which account each transaction came from. Our batch conversion guide covers the desktop converter setup for multi-account scenarios.

For a deeper look at the conversion step, see our general guide to converting bank statements to Excel. For QuickBooks users, see our QuickBooks-specific conversion guide. If you have multiple banks to convert at once, see our batch conversion guide. For the full map of which bank gives what, see our US bank export guide. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end.