You can get your Amazon order history into Excel without paying a tool by asking Amazon for a copy of your data, which is free from your account. When the download arrives, open the order file in Excel, keep a few columns, and match each order to the charges on your card statement. Returns and refunds need their own rows.
Where does Amazon order history live, and can it be exported?
Amazon order history lives in Your Account, where you can browse past orders on screen. To get it as a file, Amazon's help page on requesting your personal information describes a free data request. It also notes that order history is already available in Your Account.
That gives you two routes, and they suit different jobs:
- Browsing in Your Account. Good for finding one order, printing one invoice, or checking a date. It is a screen, not a spreadsheet, so it is slow for anything more than a handful of orders.
- The data request. Good for a year or more of orders that you want to sort, sum and match. It takes longer, because Amazon prepares the files and emails you when they are ready.
Paid browser extensions and apps also offer to export Amazon orders. Before you pay for one, try the free request. It comes from Amazon itself, so the figures are the ones Amazon holds, and nothing needs access to your login.
People usually want order history in a spreadsheet for one of a few reasons: to back up a tax deduction, to split shared purchases, to find out what a year of shopping cost, or to keep business purchases apart from personal ones. All of these need the orders next to the money that paid for them, which is the card or bank statement.
Requesting your Amazon data for free, step by step
Requesting your Amazon data is a six-step process on Amazon's own site. You sign in, choose the information you want, submit the request, confirm it through an email, and then download the files from a secure link when they are ready. The help page lists no fee for the request.
The steps, as Amazon's help page lists them:
- Go to the Request your data page from the help article.
- Sign in to your Amazon account. Amazon says this is required for security reasons.
- Select the information you want to receive. For this job, choose the category that covers your orders.
- Select Submit Request.
- Open the confirmation email and select the validation link.
- When the data is ready, download it from the secure link sent to your email address.
The help page does not give a time for step 6, so plan for a wait. Request the data a few days before you need it, not the evening before a tax deadline.
When the download arrives, it may contain several files. Look for the one that lists your orders. If it is a CSV file, Excel opens it directly; save a copy as a workbook before you change anything, so the original stays untouched.
Request only what you need. Choosing every category gives you a much larger download, most of which has nothing to do with spending.
Shaping Amazon order rows into a usable sheet
An Amazon order file usually has more columns than you need. Keep the order date, the order ID, the item description, the quantity, the amount you paid and the payment method if it is listed. Hide or delete the rest in a copy. Then decide whether each row is one item or one order.
That second choice matters. An order with three items may appear as three rows, one per item, each with its own price. Your card statement shows money, not items, so for matching you need one total per order.
A short routine gets there:
- Put the order ID in column A, the date in column B, the item in column C and the amount in column D.
- Insert a pivot table with order ID as rows and the sum of amount as values. That gives one line per order.
- Add the order date back with a lookup, or include it as a second row field.
- Check that the pivot's grand total equals the sum of the amount column.
Item rows are still useful for categories. If you run a small business and buy supplies alongside personal items, add a Category column on the item sheet. Labels that match your books save work later. A chart of accounts for a small business gives a starting list of expense accounts to choose from.
Check whether the amounts include tax and shipping. If the file lists tax on its own, add it to the item total before matching, since your card is charged the full amount.
Matching Amazon orders to card statement charges
Matching means finding, for each Amazon order, the charge or charges on your card statement that paid for it. Most orders match one charge of the same amount within a few days. The ones that do not are where a spreadsheet earns its keep: one order paid by more than one charge, or one charge covering part of an order.
You need the card statement as rows first. If your card is an Apple Card, the transactions can be exported from Wallet for free, and converting an Apple Card statement to Excel covers that export. For other cards, convert the statement PDF and put the rows on a second tab.
Here is an example with made-up figures:
| Order ID | Order date | Order total | Card charge(s) | Charge date(s) | Matched? |
|---|---|---|---|---|---|
| 111-001 | 2026-02-03 | 46.20 | 46.20 | 2026-02-04 | Yes |
| 111-002 | 2026-02-10 | 128.75 | 79.90 + 48.85 | 2026-02-11, 2026-02-14 | Yes, two charges |
| 111-003 | 2026-02-15 | 18.99 | (none) | No: check gift card balance | |
| 111-004 | 2026-02-20 | 64.00 | 64.00 | 2026-02-21 | Yes |
To flag unmatched orders, put a helper formula next to each order total: =COUNTIF(Charges!C:C, C2), where column C of the Charges tab holds card amounts. A zero means no single charge has that exact amount. For those rows, look for two or three charges near the order date that add up to the order total.
An order with no charge at all is usually paid some other way, such as a gift card balance, points or a different card. Check the payment method column if your file has one.
The matched sheet now answers the questions you started with. Filter by category to total business purchases. Filter by date to see a month. Sum the unmatched charges to find card spending at Amazon you have no order for, which is worth a look on its own.
If you only need a few months of matching, a quarterly statement gives you three months of charges in one file. Turning a quarterly bank statement into Excel covers that layout.
Amazon returns and refunds in the order sheet
A return shows up twice in your records: the original order and charge, then a refund on the card some days later. In Excel, give the refund its own row with a negative amount and the same order ID. That way the order's net cost is zero, and the card side and order side still match.
Refunds have a few quirks to look for:
- Partial refunds. If you returned one item from a three-item order, the refund is for that item plus any tax on it, not the whole order.
- Late refunds. A refund may post in the following statement month. Match it to the original order, not to the month it appeared.
- Refunds to a gift card balance. These never reach the card statement. Mark them on the order sheet so you do not search for them.
Add a Status column to the order sheet with values such as Kept, Returned and Partly returned. A pivot by Status then shows how much you spent and kept, which is often the figure people actually want.
Older purchases are harder to match if the card statements are only on paper. Scanning them is possible, but the scan needs checking before you rely on the totals. Scanning bank statements into Excel explains when to scan and when to ask the bank for PDFs instead.
Is a paid Amazon export tool ever worth it?
A paid Amazon export tool is rarely worth it for a one-off job. The free data request gives you Amazon's own record of your orders, and Excel handles the rest. A tool can save time if you need fresh exports every week or want orders pulled into another app automatically.
Weigh it this way:
- One year, once. Use the free request and a pivot table. Waiting a few days costs nothing.
- Every month, for a business. A tool that pulls new orders on a schedule may save enough time to cover its price. Check what it costs per year, not per month, and what access it needs to your account.
- A dispute or an audit. Use the free request, so the record you keep comes from Amazon itself rather than from a third party.
Watch what a tool asks for. Anything that wants your Amazon password, or broad access to your browser, can see far more than your orders.
The card side of the match is where a converter fits. If your card statement is a PDF of more than 2 pages, CheapBankConvert shows the price for its page count before you pay, and the first 2 pages preview free. It is not open yet, and its prices are early pricing.