How to Convert an American Express Statement PDF to CSV
American Express makes it easy to download recent transactions - but for older statement periods, the PDF is your only option. Here's the full picture: how AmEx's built-in export works, where the date limits are, and how to convert any AmEx PDF statement to CSV on your own computer without uploading your financial data to a third-party server.
American Express is one of the more export-friendly card issuers for recent data - they support CSV, OFX, QFX, and QBO downloads from the activity view. But those downloads cap out at a certain date. For a full tax year, historical analysis, or any period outside that window, you're working with the official PDF statement. Converting that PDF to CSV cleanly and privately is what this guide covers.
AmEx's built-in export: what it covers
AmEx's online account gives you several export options for recent activity. To access them:
- Sign in at americanexpress.com and open the card account.
- Go to Statements and Activity (sometimes called Account Activity).
- Look for a Download or Export button near the transaction list.
- Choose your format: CSV (works in any spreadsheet), OFX or QFX (for Quicken), or QBO (for QuickBooks).
- Set the date range and download.
The available date range varies by account type and how long you've held the card, but it's typically a rolling window of several months to a year. If the period you need is within that window, this native export is the fastest path.
AmEx export quirks worth knowing
A few AmEx-specific details that trip people up:
- Charge cards vs. credit cards. AmEx Platinum, Gold, and Green are charge cards (balance due in full monthly). AmEx Blue Cash, EveryDay, and co-branded cards are revolving credit cards. The statement format differs: charge card statements don't show a minimum payment or revolving balance. The transaction data is the same either way, but be aware the PDF layout varies.
- Additional cards. If you have additional card members on your account, their transactions appear on the primary statement. The CSV export from the activity screen may let you filter by card member; the PDF statement lists all cards together.
- Rewards and credits. Statement credits, cashback applied, and Membership Rewards points redemptions appear as line items. These show up in both the PDF and the export. Tag them as "Rewards" before running expense totals so they don't distort your spending numbers.
When you need to convert the PDF
For any statement period older than AmEx's export window - typically anything past a year, or specific billing cycles from a prior tax year - the PDF statement is your only source. Official AmEx statements are available going back several years under Statements and Activity.
Step 1: Download the AmEx statement PDF
- Sign in at americanexpress.com and open the account.
- Go to Statements and Activity.
- Use the statement dropdown to choose the billing period you need.
- Click to download the PDF statement and save it to your computer.
- Repeat for each month or quarter you need.
Step 2: Convert the PDF to CSV locally
An AmEx PDF statement is a formatted document - multi-section layout, summary tables, transaction detail, and sometimes multiple pages. A plain copy-paste into Excel rarely works because the visual structure of the PDF doesn't map cleanly to rows and columns.
The reliable approach is a PDF converter that reads the statement structure and extracts each transaction row: date, description, amount. Two types exist:
- Online converters. Convenient, but require you to upload the statement to a server that isn't yours. For a document containing your card number and spending history, that's a meaningful privacy risk.
- Local desktop converters. The PDF is processed on your own machine. Nothing is uploaded, and your data stays private.
Quill parses AmEx statement PDFs locally on your computer. It reads both personal and business AmEx card layouts, extracts every transaction, auto-categorizes it (Travel, Dining, Software, etc.), and exports to CSV or QuickBooks format. Your AmEx data never leaves your machine.
Business AmEx cards
American Express has a large business card lineup - Business Platinum, Business Gold, Blue Business Plus, Business Prime, and co-branded options. The PDF conversion workflow is identical for business cards, but the use case often shifts toward expense reporting and bookkeeping rather than personal budgeting.
A few considerations for business AmEx conversion:
- Employee cards. Business AmEx accounts often have multiple employee cards. The primary statement consolidates all employee spending. If you need per-employee breakdowns, filter by cardholder name in the exported CSV.
- Category split. Business AmEx statements sometimes pre-categorize spending into broad buckets (Travel, Entertainment, Shipping). A local converter can map these into more granular categories - Quill uses its own categorization based on merchant names, which is typically more precise than AmEx's broad groupings.
- QuickBooks export. Many businesses running AmEx for company expenses want transactions in QuickBooks rather than a spreadsheet. Quill exports to a QuickBooks-compatible format directly from the AmEx PDF, skipping the intermediate CSV step.
What about AmEx's OFX and QBO exports?
AmEx's native OFX and QBO downloads are useful if your accounting software can accept them - Quicken, QuickBooks, and some other tools can import OFX directly. The advantage is that the data structure is already formatted for accounting; the limitation is the same date-range cap as the CSV export. For current-year accounting, use the native OFX or QBO if your software accepts it. For older statements, the PDF-to-CSV path is the only reliable option.
For related guides, see how to import American Express statements into QuickBooks and how to convert any bank statement PDF to CSV.
Frequently asked questions
Does American Express let you download transactions as a CSV?
Yes. American Express lets you download recent transaction activity from your online account in several formats including CSV and OFX. However, the download window is limited - typically a rolling window of recent months. For older statement periods, the only option is the official PDF statement, which requires a separate conversion step to become CSV.
Where do I find my American Express statement PDF?
Sign in at americanexpress.com, open the account, and go to Statements and Activity. Choose the statement period from the dropdown and click to download the PDF. Both personal and business AmEx cards store statements in the same section.
Is it safe to convert an AmEx statement PDF online?
Using an online converter means uploading your AmEx statement - which contains your card number, account balance, and full transaction history - to a third-party server. A safer approach is a local desktop tool that parses the PDF entirely on your own computer. Quill does this: your AmEx data is never transmitted and never leaves your machine.
Convert your AmEx PDFs to clean CSV
Drop your American Express statement PDFs into Quill and get categorized, spreadsheet-ready data - 100% on your own machine. One-time purchase, no bank login.
Get Quill