I don’t know about you, but I’ve never really thought about how much money I’ve spent on Amazon since most of the time I buy things that I actually need. Not much of an impulsive buyer, but it is interesting to know how much you’ve spent while being a member of Amazon Prime or just a casual Amazon user. Within Amazon settings, it will gather all of your purchases from whatever date.
Here’s what you need to do:
- First, visit this page on the Amazon website.
- In the Orders section, click on Download Order Reports (you’ll be prompted to log in if you haven’t already).
- In the Start Date box, put January 1 of the oldest available year. Then click the Use today link next to the End Date box.
- Click Request Report. After a few moments, you’ll be prompted to download a “.CSV” file.
- Save the file on your PC and then open it using Microsoft Excel.
- In the cell at the bottom of the column showing your transaction totals, input the formula =SUM(X1:X1000) and then hit enter. In place of “X1” and “X1000,” be sure to enter the actual cell names for the first and last numbers in that column. For my spreadsheet, it was =SUM(AD2:AD25)