How to Calculate Your Total Amazon Spending

Head over to Amazon, I have tried this on Amazon.in. I believe it should still work in other countries.

1. Log in and go to your dashboard

2. Under your profile section in the right-top corner, click on “Your Account”

3. Scroll down to the bottom section, under “Manage your data” and click on “Request your data”

4. Under the dropdown, you can see a list of things you can request data for

   1. Orders (We are interested in this)

   2. Addresses

   3. Payment options

   4. Subscriptions

   5. Search History

   6. Alexa and Echo Devices

   7. Kindle

   8. Fire TB

   9. Fire Tablets

   10. Advertising

   11. Amazon Photos and Drive

   12. Apps and More

   13. Amazon Music

   14. Prime Video

   15. Audible

   16. Customer Support Communication

   17. Request All Your Data (all the data)

Since we want to calculate the order sum, select “Your Orders”.

5. Once you click submit, you will receive a confirmation email in your registered email.

6. In the email, click on “Confirm Data Request”

7. They mention that it will take lots of time to receive the data. But, from the past trials, it’s usually in an hour or so.

8. When the downloads are ready, you will receive another email.

   

9. You can download the data and extract it.

The orders folder should resemble the structure shown above. Interestingly, it includes invoices for all orders, even covering digital goods like eBooks. Our focus, however, is on the “Retail.OrderHistory” folder, which contains the detailed order history.

Upload the CSV file to Google Sheets or open it with Microsoft Excel.

The column of interest here is "Total Owed." By selecting this column, you can view the total sum conveniently displayed at the bottom-right corner.

I hope this was helpful, have fun getting depressed.

---

Thanks for reading The Evilhead! Subscribe for free to receive new similar posts and support my work. I promise to keep it interesting, without spam