Download Amazon product reviews as Excel/CSV file

If you are a professional seller on Amazon and if you want to improve your product, you should probably like to know all the reviews of the product, what are people talking about, and do they like or dislike the product? In this article I will describe 2 different ways to download Amazon product reviews as a CSV file using 2 tools: Helium 10 and River Cleaner.

Both methods are FREE. Just follow step by step instructions below.

 

Method 1 (FREE). Using Helium 10 - a toolbox for Amazon sellers

First of all, you will need to create an account with Helium 10 or login to the existing one. FREE account is enough to download Amazon product reviews.

If you will decide to test out all other tools of Helium 10, make sure that you click our Helium 10 partner link and use coupon code DEMOMONDAYS to get 7-days trial plus 10% off any plan. If you are curious what Helium 10 has to offer, check watch the “Demo Mondays #25 – Helium 10”  episode.

The Helium 10 Software Suite contains over 20 tools that help Amazon sellers to find profitable products, identify powerful keywords, launch products, optimize listings, track keywords, monitor hijackers, locate reimbursements from Amazon and more – to save time and increase sales on Amazon.

So, here are the detailed steps how to use Helium 10 to get the product reviews as a CSV/Excel file:

  1. Download and install the Helium 10 Chrome extension. It is essential to use Chrome web browser, of course.
  2. When you download Chrome extension of Helium 10, you will see the small blue icon on the right corner of your screen.
  3. If you are not yet logged in to the Helium 10 Member’s Area, you will see a message about that once you click on the Helium 10 Chrome Extension icon.
  4. Now when you are signed up, go to the Amazon product listing for which you want to download the reviews. As an example let’s go to the Infinity Instruments Orange Retro 9.5-Inch Metal Wall Clock.
  5. If you click on the Helium 10 Extension icon you will see an option called “Review Downloader”.
  6. You will have an opportunity to filter reviews according to your criteria: by date, by Verified/Not Verified, only the reviews with or without Images/Videos. There are also 5 yellow stars which represent different star ratings of the reviews. In order to filter out only 1-star (7%) and 2-star (4%) reviews, you need to un-mark (click) the last 3 stars, so that they are filled with the white color. Check the second screenshot below, where I have chosen to download only the low star reviews.
     
  7. Once you are happy with your filters – click on the [EXTRACT] button. A new browser tab will open.
  8. If you want to save file on your PC, click the blue [EXPORT REVIEWS] button at the top right corner and download the CSV to your computer.
  9. The downloaded CSV data has 9 columns: Date, Author, Verified, Helpful, Title, Body, Rating, Images, Videos. You can open it with Excel, Google Sheets or any other software, which can open CSV files and you feel comfortable with.

    NOTE: if you open the CSV file with text editor and see the “data:text/tsv;charset=utf-8,” at the beginning of the document – make sure you remove this, otherwise the Sheet’s column names will be shifted by 1 position to the right.

 

Method 2 (FREE). Using the River Cleaner tool

First of all, what is River Cleaner?

River Cleaner is a Chrome browser Extension that keeps your Amazon product listing compliant! This tool offers guidelines for keeping your listings in check with Amazon’s TOS right inside the Seller Central dashboard. Just insert your copy, keywords or other details and instantly see if you face a possible violation.

Actually it is much more than a simple Chrome extension. If you want to learn more, watch this Demo Mondays session with River Cleaner.

Here are the simple steps how to get all the Product Reviews as a CSV file

NOTE: You do not need to open an account with River Cleaner. This feature is for FREE for everybody without providing any personal information.

  1. Install River Cleaner Chrome Extension
    The icon at the top of the browser will look like this:
  2. No need to click on this icon, as it will ask you to login to your River Cleaner. However the review-download feature is FREE to everyone and you can just ignore the login box.
  3. Open any of Amazon US or EU product listing. Let’s take the following LED desk lamp I love very much: LED 9W Eye-caring Dimmable Office Table Lamp
  4. Scroll down to the second half of the page where it says “Customer Reviews”
  5. Look for the [Download reviews] button and click on it! This button is created by the River Cleaner extension.
  6. Once clicked, it will change to [Downloading…]
  7. Within few seconds you will get a popup offering you to save the CSV file with all the reviews. Note, be patient if the number of reviews is high, as it might take slightly longer for the system to show the file download popup.
  8. Now you have a CSV file, which has 4 columns: Rate, Name, date and Review. You can open it with Excel, Google Sheets or any other software, which can open CSV files and you feel comfortable with.

 

What can you do with the downloaded reviews?

There can be several uses of it. Here are some ideas:

  • Use it to extract keywords you might be missing on your product listing.
  • Read low rated reviews and decide how you can improve the product.
  • Examine the language patterns of your product users.
  • Copy and paste all the reviews into the word cloud tool TagCrowd.com – it will show you the most used words by the reviewers

About the Author Augustas Kligys

Augustas Kligys is the host and creator of several popular virtual summits for Amazon sellers. The first one is European Private Label Summit, which covers a lot of important topics for those willing to grow their Amazon FBA business in European Marketplaces. The second - AMZ Seller Summit - an event, where experts shared their Amazon business optimization secrets and mindset, which helps to elevate your business to the next level. Augustas also hosts weekly DEMO MONDAYS video series, where Amazon seller tools are demoing their products.

follow me on:

Leave a Comment:

2 comments
J says July 17, 2018

I believe there is a bug with this software as all the CSV files are blank after the download. I’ve tried it among different listings and categories and the problem still persists.

Reply
    Augustas Kligys says July 27, 2018

    I tested it works for me. What is your ASIN?

    Reply
Add Your Reply