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 explain how you can download Amazon product reviews as a CSV file using Helium 10.

This method is FREE. Just follow the step by step instructions below.

(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.

 

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 and in-person 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. If you want to meet Augustas in-person, visit one of his live events for Amazon business owners: European Seller Conference, PPC Congress, and Seller Fest.

follow me on:

Leave a Comment:

4 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
Ben says October 8, 2018

Why you haven’t mentioned that the Helium 10 provides only first 100 reviews?
Is it same with River Cleaner as well?

Any tool or suggestion to get all reviews free?

Reply
P says November 14, 2018

Helium10 and River Cleaner – They both have restricted number of comments to download. any suggestions for all to be downloaded free?

Reply
Add Your Reply