Click to Skip Ad
Closing in...

How to see exactly how much money you’ve spent at Amazon in your life

Updated 7 years ago
Amazon Tips

If you purchase an independently reviewed product or service through a link on our website, we may receive an affiliate commission. Learn more.

Amazon has completely changed the way people shop in every market where the company operates. No, it certainly wasn’t the first e-commerce company. No, it wasn’t the first web retailer to offer deep discounts. And no, it wasn’t the first company to provide a single online marketplace where thousands of third-party sellers can offer products directly to consumers. But it was the first company in many markets to check all those boxes and really resonate with shoppers.

How long have you been buying various products on Amazon? Five years? 15 years? Maybe even 20 years? If you had to guess, how much money do you think you’ve spent in all that time? Well, you don’t have to guess because we’re going to show you exactly how to figure it out in just a few easy steps.

DON’T MISS: Our first look at the iPhone 7 couldn’t be less exciting (and why that’s OK)

We’ve seen this tip on a bunch of different websites over the years, but it was posted most recently on Business Insider. In a nutshell, Amazon allows you to download spreadsheets that show all of your orders over a certain period of time. Of course, you can easily set that time span so that it covers your entire order history, and then use a simple formula to add up the grand total.

Here’s what you need to do:

  1. First, visit this page on the Amazon website.
  2. In the Orders section, click on Download Order Reports (you’ll be prompted to log in if you haven’t already).
  3. 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.
  4. Click Request Report. After a few moments, you’ll be prompted to download a “.CSV” file.
  5. Save the file on your PC and then open it using Microsoft Excel. If you don’t have Excel, you can use Google Docs for free by visiting
  6. 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.

So, what’s your total? Feel free to share it in the comments below if you think you can wow us. And remember, it might seem like an insanely high number if you’ve been an Amazon customer for a long time, but just think about how much money you’ve saved on all those orders by purchasing from Amazon instead of pricier retailers.

Maren Estrada
Maren Estrada Deals Editor

Maren Estrada is a deals expert with more than 15 years of product reviews and deals coverage experience. Having been the Editor for BGR Deals since it first launched in 2013, she has helped our audience save millions of dollars over the years on tens of thousands of popular products. She is the authority on daily deals coverage. In addition to BGR, her work has also appeared on Yahoo!, MSN, and more.