How to export your Amazon order history to a spreadsheet

Amazon Order History Report in Spreadsheet

If you buy products on Amazon, you’re among many. And there may be a time when you need to not only see all of your purchases for a time period but hold onto a record of them. You might need to show expenses for business supplies or just want to keep track of your Amazon spending.

Whatever your reason may be, Amazon makes it pretty easy to export your purchases to a spreadsheet that you can save or share and here’s how.

Generate an Order History Report on Amazon

Head on over to the Amazon website and log in. After you log in, click this link to the Order History Reports.

Note: According to the Amazon Help page, you can get to the Order History Reports in the Your Account area of the site. However, after much searching, I was unable to find it. If the above link doesn’t work for you, head to the Amazon Help page and click Order History Reports from there.

Once you arrive on the Order History Reports page, the rest is easy.

1) Choose the Report Type from Items, Orders and Shipments, Refunds, or Returns.

2) Select the Start and End Dates for the report. Alternatively, you can pick one of the Quick Set Options to the right.

3) Optionally, you can give the report a name.

4) Click Request Report.

Amazon Request Order History Report Web

After you request the report, it takes only a minute or so for it to generate. But remember, that depends on the time frame and number of items in the report.

You can then access the report on that same screen at the bottom. You should also receive an email with a link to the report and can grab it from the Downloads area of your browser.

Amazon Request Order History Report Email

View your Amazon purchase history

When you click to open the report, it will open with your default spreadsheet application such as Numbers or Excel, unless you specify otherwise. And the report contains a ton of details for the items like order date and ID, price, payment type, shipment date, tax exemption information, and much more.

Amazon Order History Report Numbers

Wrapping it up

If you need to review and save a record of your Amazon purchases, this tip should help. And remember that you can use that Order History Report for refunds and returns if you need to as well.

Do you have any tricks for tips for Amazon that you’d like to share? If so, you can comment below or hit us up on Twitter!

And for more help with Amazon or the scoop on Amazon news, take a look at our Amazon section of iDB.