# American Express Statement to Excel: Card Rows, Clean

- Author: FastBankConvert (https://www.fastbankconvert.com)
- Published: 2026-10-02
- Updated: 2026-10-02
- Category: Bank statements to Excel and CSV
- Canonical: https://www.fastbankconvert.com/blog/american-express-statement-to-excel

> Turn an American Express statement to Excel: charge card layouts, additional card members, foreign spend lines, and payments with the right sign.
To bring an American Express statement into Excel, download the billing statement PDF or the activity file from your online account, convert it into rows, and add a column naming the card member on each charge. Keep foreign currency notes out of the amount column, record payments as negative, and tie the result to the statement summary.

## American Express PDF statement or the activity download?

American Express offers two files, and they answer different questions. Its [help page on transaction history and billing statements](https://www.americanexpress.com/us/customer-service/faq.transaction-billing-statements-history.html) says the previous two years of transactions can be sorted, filtered and downloaded as PDF, Excel or CSV, and that PDF copies of statements, including archived ones, are listed separately.

Use the activity download when you want recent transactions quickly and do not need them to match a closed statement. It is already a spreadsheet, so there is nothing to convert. Its weakness is that it is a view of a date range you chose, not a document the issuer closed and totalled.

Use the statement PDF when the sheet has to tie to something official: an expense report, a reconciliation, a dispute or a bookkeeper's request. The statement has a closing date, a previous balance, a new balance and totals by type. Those figures are the only way to prove your rows are complete. The same help page notes that archived statements will be available online within 24 hours, so an older month can take up to a day to appear.

### Mixing the two sources

Do not merge rows from the activity download with rows from converted statements for the same period. The two can differ in dates, description text and the handling of pending items, and the overlap creates duplicates that look like separate charges. Pick one source per period. If you must switch, for example using statements for last year and the activity download for this month, cut over at a statement closing date so every day belongs to exactly one source.

## Charge card and credit card layouts at American Express

American Express issues both charge cards, where the balance is generally due in full each cycle, and credit cards, which can carry a balance with interest. The statement layout is similar, but the summary box and the lines near it differ, so read the box before deciding which totals your rows must match.

### What to look for in the summary

Every card statement has a previous balance and a new balance. Between them sit the movements: payments, credits, new charges, fees and, on a card that carries a balance, interest. Your test is that the previous balance plus charges, fees and interest, minus payments and credits, equals the new balance.

On a card paid in full every month, the previous balance and the payment are often the same figure. That makes a handy first check: if your converted payment row does not match last month's balance, look at the payment first.

### Lines that are not transactions

Card statements carry plenty of text that is not a transaction: rewards summaries, plan or installment details, interest rate tables and notices. A converter that reads the whole page may pull some of it in as rows. Delete any row without a date and an amount, and any row whose amount appears in the summary but not as a charge in the list.

## Additional card member blocks on an American Express statement

An additional card member is a second person with a card on the same account. When a statement lists charges by card member, each person's charges usually sit in a block under their name with a subtotal. In Excel, that name has to move into a column, or it disappears when you sort.

### A worked example

The rows below are examples with made-up names, merchants and amounts. They show a statement with two card members, one charge carrying a foreign currency note.

| Date | Description | Member | Type | Amount | FX note |
| --- | --- | --- | --- | --- | --- |
| 05/03 | EXAMPLE CAFE | A. Rivera | Charge | 18.40 | |
| 05/07 | CITY HOTEL LISBON | A. Rivera | Charge | 326.70 | EUR 300.00 |
| 05/09 | OFFICE SUPPLY STORE | J. Rivera | Charge | 92.15 | |
| 05/12 | RETURN OFFICE SUPPLY | J. Rivera | Credit | -22.00 | |
| 05/20 | ONLINE PAYMENT THANK YOU | A. Rivera | Payment | -500.00 | |

Fill the Member column as you go down the converted rows: every row below a member's heading belongs to that member until the next heading. Then delete the heading rows and the per-member subtotal rows, keeping the subtotals in a small side table.

### Checking each member's total

With the data in a table, `=SUMIFS(E:E, C:C, "J. Rivera", D:D, "Charge")` gives one member's charges. Compare it with that member's printed subtotal. A mismatch tells you which block to reread, which is much faster than scanning the whole statement. Payments usually apply to the account, not to one member, so leave them out of member totals.

### When each member needs a separate file

Sometimes each card member's spending goes to a different place: one person's charges to a business, another's to a household budget. Build the full sheet first, tie it to the statement, and only then split it with a filter on the Member column. Splitting before the tie-out means you can no longer prove the pieces add up to the whole, and a charge that slipped between two blocks would go unnoticed.

If you repeat this every month, keep the member names spelled exactly the same each time. A SUMIFS on "A. Rivera" will not count rows typed as "A Rivera", and a pivot table will show them as two people. A short list of allowed names on a separate tab, used with data validation, prevents the drift.

## Foreign spend lines on an American Express statement

A foreign spend line is a charge made in another currency. The statement shows the charge in your billing currency and often prints the original amount and currency nearby, sometimes with the rate. Only the billing-currency figure is the charge. Everything else is a note and belongs in its own column.

### How it goes wrong

The original amount looks like a number, so a converter or a copy and paste can place it in the amount column as its own row. In the example above, a stray row of 300.00 would add a charge that never happened. The summary test catches it: your total would exceed the statement's new charges by exactly the original foreign amount.

### Keeping the note

Move the original amount and currency into the FX note column on the same row as the charge. If a separate foreign transaction fee appears as its own line, keep it as a Fee row, because it is a real charge that the summary includes. A card that charges no such fee simply will not show one.

## Which sign do American Express payments and credits get?

On a card sheet, charges are positive and payments, refunds and statement credits are negative, because the account measures what you owe. Statements mark these reductions in different ways, such as a minus sign or a credit marker. Convert each marker into a real negative number before totalling anything.

### Payments versus credits

Keep payments and credits apart in the Type column, and keep statement credits from rewards or offers apart again, since they are neither a refund from the merchant nor money you paid in. A payment is money you sent from a bank account. A credit is money the merchant or the issuer gave back. If you track spending, a refund should reduce spending at that merchant, while a payment should not touch spending at all. Mixing the two understates what you spent.

### Combining with your bank sheet

If the card sheet sits next to a bank sheet, flip the card amounts by multiplying by minus one so spending is negative in both. The card payment then shows as an outflow from the bank and an inflow to the card, netting to zero. The [PNC bank statement walkthrough](/blog/pnc-bank-statement-to-excel) and the guide to [TD Bank statements in Excel](/blog/td-bank-statement-to-excel) cover the bank half of that picture.

## Opening an American Express sheet in Excel 2016

Excel 2016 can open a CSV or XLSX file without trouble, so the activity download needs no extra step. The statement PDF is different. Whether Excel 2016 can import a PDF directly depends on the edition and updates, which the guide on [PDF to Excel in Excel 2016](/blog/pdf-to-excel-in-excel-2016) explains.

If your Excel cannot read the PDF, convert the statement outside Excel and open the result. Check two things when it opens. First, that dates are real dates and not text, which you can test by sorting the column. Second, that amounts are numbers, which shows when SUM returns a value instead of zero.

### Getting the rows

FastBankConvert is getting ready to open. It is built for credit card statements as well as bank ones, gives you an Excel, CSV or JSON file, and tells you before download if a statement's balances do not add up; [Get started](/get-started) to join the list. Whatever produces your rows, the broader checks in [turning a PDF bank statement into a clean Excel list](/blog/pdf-bank-statement-to-excel) apply to card statements too: one row per transaction, consistent signs and a total that ties.