American Express statement to Excel
Get any Amex statement into Excel, with every charge, credit and card member accounted for
Amex's download covers recent activity. For older billing periods, closed cards or the PDFs a client sends you, convert the statement and get every charge and credit in Excel, CSV or QuickBooks, checked against Amex's own Previous Balance and New Balance. Written for bookkeepers and accountants doing catch-up work, tax prep and month-end close.
To get an Amex statement into Excel, sign in at americanexpress.com, open Statements & Activity, pick the billing period, click Download, and choose CSV or Excel. That covers recent activity. For older billing periods, cancelled cards, or the PDF statements a client sends you, convert the Amex PDF statement to Excel, CSV or QuickBooks instead.
Which one you need depends on what you are doing with the numbers. A download is fine for checking last month's charges. Bookkeeping catch-up, tax prep and a clean month-end close need the statement itself: every charge and credit for the billing period, tied to Amex's own Previous Balance and New Balance.
While you are here
Extract every transaction from any bank PDF
Upload a statement from any bank and DocuClipper returns a clean table with dates, amounts, descriptions, and running balance intact. No reformatting before you can reconcile or import.
Method 1: Download card activity from americanexpress.com
- Sign in at americanexpress.com and select the card.
- Open Statements & Activity and choose the billing period (or a custom date range).
- Click Download (the arrow icon above the transaction list).
- Choose CSV or Excel. QuickBooks (.qbo) and Quicken (.qfx) files are also offered, over a shorter window.
- Open the file in Excel and save it as .xlsx if you want to keep formatting.
What you get is the card's activity: one row per charge, payment or credit. What you do not get is the statement. The file has no Previous Balance, no New Balance and none of the statement's fee and interest totals, so you cannot show it matches the statement you are reconciling. If the period you need is older than the download offers, the card is closed, or a client emailed you PDFs, use method 2.
Method 2: Convert the Amex PDF statement to Excel, CSV or QBO
- On americanexpress.com, open Statements & Activity, go to your statements, and download the monthly PDFs you need (or use the PDFs a client sent you).
- Upload the PDFs to DocuClipper. Upload a whole year at once if you have it; each billing period is handled separately.
- DocuClipper extracts every charge, payment and credit with its date, description and amount (plus the cardholder on multi-card business statements), then checks each statement against Amex's printed Previous Balance and New Balance. Statements that tie out are marked as balanced; one that does not is flagged so you can compare it with the PDF before export.
- Click Download Data and choose Excel (XLSX), CSV, or a QuickBooks Web Connect (QBO) file. See downloading transactions for every format.
The 14-day free trial converts up to 120 pages with no credit card, so you can check the result on your own Amex statements before you commit.
Which method should you use?
| Your situation | Use | Why |
|---|---|---|
| Last few months, you can sign in to the card | Amex CSV or Excel download | Free and immediate |
| Billing periods older than the download covers | Convert the PDF statements | The PDF is the only source for those months |
| A client sent you PDF statements | Convert the PDF statements | No login to the client's Amex account needed |
| You need to prove the numbers match the statement | Convert the PDF statements | Each period is checked against the printed Previous Balance and New Balance |
| Business card with several card members | Convert the PDF statements | Every row is labeled with its cardholder |
| Catching up QuickBooks or Xero | Convert to QBO or CSV | See importing statements into QuickBooks |
What we see in Amex statements
From DocuClipper's production data, statements uploaded in the 30 days to November 2, 2026:
| Measure | Amex |
|---|---|
| Amex statements converted | 5,000+ |
| Pages converted | 47,000+ |
| Closed more than 90 days before upload | 64% |
| Closed more than a year before upload | 31% |
| Typical age at upload (median) | about 6 months |
How we counted: a statement counts as Amex when its first page carries americanexpress.com or its file name names Amex, so these are lower bounds. Age is the gap between the statement's closing date and the day it was uploaded.
Amex statements run long: the average one converted here was over 9 pages, because business and corporate cards list every card member's charges. That is where copying by hand stops being an option, and where a check against the printed New Balance earns its keep.
Put it into practice
Manual copy-paste is where errors begin
Split rows, drifting balances, missed transactions: they all trace back to re-keying. DocuClipper preserves the bank's layout so debits, credits, and totals tie out the first time.
Amex statement details that break copy and paste
Amex statements are built for card members, not for spreadsheets. These are the parts that trip up copy and paste, and that DocuClipper handles for you:
- Card member sections. Business and corporate statements list charges under each card member, each with its own subtotal. Pasted into Excel, the subtotals land in the column as if they were charges, and you lose who spent what. DocuClipper adds a Cardholder column to every row (name and card ending) and leaves the subtotals out. More in statements with multiple cardholders.
- Payments and credits. Payments, refunds and statement credits sit in their own section and print as negative amounts. In the export they come through as credits to the card, not as charges, so the period totals to the New Balance.
- Foreign transactions. A purchase in another currency prints the foreign amount and exchange rate on an extra line. Only the US dollar amount is the transaction; the extra line is not a second charge.
- Fees, interest and Pay Over Time. Annual fees, interest charged and Pay Over Time or Plan It balances appear in separate summary blocks. They are booked once, where they belong, instead of twice.
- A year of statements in one PDF. Combined PDFs are split back into billing periods so each month is checked on its own.
Because every Amex statement is checked against its own printed balances, a period that does not add up is flagged, never handed to you as a quietly wrong spreadsheet. Across all banks and cards, DocuClipper extracts at 99.9% accuracy.
Getting Amex statements into QuickBooks or Xero
For catch-up bookkeeping, convert the year of Amex PDFs and download a QuickBooks Web Connect (.qbo) file. In QuickBooks Online, open Bank transactions, choose Upload from file, and pick your Amex credit card account; charges come in as charges and payments as payments. For Xero, download a CSV or use the Xero export and import it into the Amex card account. Either way, check that the period's ending balance in your books matches the statement's New Balance; with converted statements it already does.
FAQ
Can I download my Amex statement in Excel format?
Amex lets you download recent card activity as a CSV or Excel file. Your monthly statements themselves are PDFs. To get a full statement into Excel with its billing period and balances, convert the PDF.
Does the Amex CSV download match my statement?
Not on its own. The download is a list of transactions for the period you pick. It does not include the statement's Previous Balance or New Balance, so you cannot tie it to the statement from the file alone. A converted PDF statement is checked against both.
How do I get Amex transactions older than the download allows?
Download the monthly PDF statements from Statements & Activity on americanexpress.com (or request archived statements from Amex), then convert them to Excel, CSV or QBO. A full year of statements can be uploaded at once.
Can I import Amex statements into QuickBooks?
Yes. Convert the Amex PDFs, download a QuickBooks Web Connect (.qbo) file, and upload it to your Amex credit card account from Bank transactions, Upload from file in QuickBooks Online, or File, Utilities, Import, Web Connect Files in QuickBooks Desktop.
Does it work on Amex business cards with several card members?
Yes. Business Platinum, Business Gold, Blue Business and corporate statements list charges under each card member. Every transaction gets a Cardholder column with the card member's name and card ending, so you can sort or filter spending by employee in Excel.
Is converting Amex statements secure?
Yes. DocuClipper is SOC 2 Type II audited, your statements are visible only to your account, and you can delete them at any time.
More statement guides
Next step
Upload your first statement free
No credit card required. See extracted transactions in seconds, then export to Excel, CSV, or QBO when you're ready to scale.