Amazon order history report: download your orders

If you're looking for the Amazon order history report to export Amazon orders for a budget, your taxes or an expense claim, the route Amazon's help describes is a different one: Request your data, Amazon's own way to get a copy of your account's information. This guide follows it, then turns what arrives into one sheet with a row per order, and covers the quicker route for just a few orders.

Plenty of guides still describe an Amazon order history report: a page in your account where you picked a date range and downloaded a CSV. As of October 2026, Amazon's help doesn't describe it. It gives two routes instead: your order history to look at in Your Account, and Request your data for a copy you can download. If you need a file, the second is the one.

The Amazon Request your data steps, as Amazon gives them:

1. Go to Request your data (search Amazon's help for "Request your personal information" to find the link).
2. Sign in to your Amazon account. Amazon requires it, for security.
3. Select the information you want to receive. For your orders, choose your orders.
4. Select Submit Request.
5. Open the confirmation email Amazon sends to your account and select its validation link. The request doesn't go ahead until you do.
6. When your data is ready, Amazon emails you a secure link. Download the file from it.

Amazon's help gives no time for the last step, so request it well before you need it, and keep an eye on the inbox of the email address on your account.

Expect several files rather than one sheet. If the download is a .zip, unzip it, then look for the folders and files whose names mention orders; the rest is other information on your account. Open the order files in Excel or Google Sheets, and look for two kinds of columns you'll need below: an order ID, and an amount per row.

Before you build anything on it, check it covers the period you need: sort by the order date and look at the first and last rows.

If the same order ID appears on several rows, each row is an item, not an order. That's useful for returns, but a budget wants one row per order. Turn it around with a pivot table:

1. Select the whole sheet and insert a pivot table (Insert › PivotTable in Excel, Insert › Pivot table in Google Sheets).
2. Put the order ID in Rows, and the order date under it.
3. Put the amount column in Values, summed.

You now have a row per order with its total. If you would rather keep the original sheet, add a column that sums every row with the same order ID. With order IDs in column A and amounts in column F:

=SUMIF($A:$A, A2, $F:$F)

Then remove duplicates on column A, and every order is left once with its total. A few checks before you trust the numbers: amounts written with a currency sign may be text, so remove the sign and format the column as a number; and if there's a separate column for tax or shipping, decide whether your total should include it.

For a handful of orders, waiting for a data request is slower than copying. Sign in, open Your Orders, narrow it to the period you need, select the list and paste it into an empty sheet as plain text. If the orders paste as lines one after another rather than rows, that's because the page shows them as cards. Our guide to exporting a list from any site shows how to copy and paste it properly and fold those lines back into rows.

Tabless is a browser extension that builds what you ask for from the sites you allow; nothing is typed or submitted without your OK. It isn't open yet. An export like this is one of the jobs we're building it for: asking in plain words for "my orders this year, one row each, with the date, the items and the total", and getting it as a CSV or XLSX file.

It's designed to read through the session your browser already has, the sites you're signed in to, for your own use, so there are no API keys or passwords to hand over, and to ask before it reads each site. It's for lists you're entitled to see, for your own work, and the site's own rules still apply. You sign in to Tabless with a Wix account.

Amazon's help doesn't give a time: it emails you a secure link when your data is ready. The request only starts once you select the validation link in its confirmation email, so check for that email first.

The steps in Amazon's help don't include a date range. Request your orders, then sort or filter the order date column to the year you need and delete the other rows. For a few orders from one year, copying them from Your Orders is quicker.

Not yet. Tabless isn't open, and exports like this one are among the jobs we're building it for. Join the waitlist, and we'll let you know when you can try Tabless.