How to export Amazon reviews to CSV, and track new reviews automatically

Amazon reviews are the one part of a listing written by the people who bought it, and Amazon shows them only on the page, 10 at a time, newest or most helpful first. Getting them out — into a spreadsheet, a report or a weekly read — means copying by hand, exporting once, or running a tracker that fetches the new ones as they arrive. This guide covers all three, what each can reach now that Amazon keeps the full review list behind a sign-in, and the steps in AMZ Selling Tools.

Why export reviews at all

• To read a product’s complaints in one place. The one-, two- and three-star reviews of your own listing, sorted by date: a defect shows up as the same sentence in several reviews before it shows up in your returns.
• For competitor research. What buyers of the rival product praise and what they miss is a feature list written by customers, and it is sitting on a public page.
• For a report. A client, a buyer or a team wants the reviews of a quarter as rows with dates, not as screenshots.
• To keep up. Knowing which reviews are new this week, without rereading the page to find out.

What any method can reach since the sign-in wall

Two changes on Amazon’s side set the limits for every method, ours included:

• July 2023 — the list is capped. For any one filter — a star rating, a sort order, verified purchases only — Amazon serves ten pages of 10 reviews and then stops, whatever the listing’s total. Page 11 does not exist.
• November 2024 — the list needs a sign-in. A signed-out visitor sees only the handful of reviews featured on the product page itself; the full list opens for signed-in shoppers.

Amazon shows about 100 reviews per filter; star and sort filters stack to roughly 500–1,000 per listing, and older reviews are out of reach for every tool. The ratings count on a product page — “12,480 global ratings”, say — counts stars, most of them left without a written review; the reviews with text are fewer, and the ones reachable today are the most recent and the most helpful hundred of each filter. A tool that promises every review of such a listing is reading from an archive it built up over the years, or counting ratings rather than reviews; neither is what the page serves now. What a tracker can add is time: from the day you start recording, the reviews that arrive are kept, and after a year you hold a history the page itself never shows.

Method 1: by hand

For one listing, once, the browser is enough:

1. Sign in to the store and open the product page — the list behind the featured reviews needs an account.
2. Open the full review list from the link under the featured reviews.
3. Sort by most recent, and add a star filter or verified purchases only if you want a subset.
4. Copy each review — stars, title, date, name and text — into your sheet. One page holds 10; the list ends after ten.
5. Repeat per star rating to reach past the first hundred; each rating is its own list of up to a hundred.

The costs show the second time you do it: no record of which reviews you already copied, dates and badges worded differently in every store and language, and the better part of an hour per listing at any depth. Fine for a one-off look; not a method for a listing you will come back to.

Method 2: a one-off export

A tracker runs the same walk and writes a file. In AMZ Selling Tools a review line is one ASIN in one marketplace with a mode, and three of the four modes are built for a one-off pull:

• All reviews. Everything Amazon will serve for the listing: one pass when it has a hundred reviews or fewer, otherwise one pass per star rating plus a most-helpful pass for any rating that fills its hundred, with the duplicates between the passes removed on Amazon’s review id. This is the deepest export the page allows.
• By stars. Any set of star ratings — the one- and two-star reviews of a rival, the five-star reviews of your own listing for a testimonial page — and nothing else.
• Latest N. The newest 10 to 100 reviews, as a sample.

Set the line’s schedule to manual, run it, and export the result as CSV or JSON — the file opens in Excel, Numbers or Google Sheets with the columns listed below. Any of the three can also be restricted to Verified Purchase reviews, and any of them can be left on a schedule instead, so the file is refreshed without you.

Method 3: track the new reviews automatically

For a listing you will come back to, the better tool is a tracker that only fetches what is new, and that is the review tracker’s default mode. The first run of a new-reviews line records the latest 100 reviews as a baseline (up to 20 checks); after that only reviews newer than the last check are fetched, and a run that finds nothing new uses one check.

Pick the cadence per line. The default is weekly, on the weekday you created the line: a week of reviews reads in one sitting, and a quiet week costs one check. Daily suits a launch, a product with a suspected defect or a rival’s new version; monthly suits the long tail of a catalogue. Each run lands at a 10-minute slot in the marketplace’s time or yours, or at the least-loaded slot if you leave the choice to us, and Check now runs a line whenever you want a reading.

When a low rating matters more than a cadence, put an alert on the line: an email when a new review arrives at or below the star rating you choose — the ready-made preset is “New 1–2 star review” — sent after the run that records it, with the rating and the review’s title. It is the same alerts system as the listing tracker’s, so the rule sits beside your price and Buy Box rules.

Over months the line becomes the review history Amazon never shows: when each review arrived, the rating mix on each run, and the full text of every review since the day you added the line, exportable at any time and never counted twice, because each review is keyed on Amazon’s own id.

What is in the CSV

Each row of a reviews export is one review:

• the ASIN and the marketplace, and Amazon’s review id;
• the date, the star rating, the title and the full text;
• the reviewer’s display name, as Amazon prints it beside the review;
• the Verified Purchase badge and the number of helpful votes;
• the variant reviewed — size, colour or pack — and the links to any photos;
• the run that first recorded the review, so a weekly export can be filtered down to the newcomers.

A second export lists the runs themselves: when each ran, how many reviews it brought back and how many were new, and the listing’s rating summary on that day — total ratings, the average and the star breakdown — which is the series behind a rating chart. Any cell that begins with a character a spreadsheet would read as a formula is escaped on the way out, so a review that opens with an equals sign or a plus runs nothing when the file is opened in Excel or Google Sheets.

How to do it in AMZ Selling Tools

The Amazon review tracker page describes the feature field by field; this is the sequence in the app.

1. Add the lines. On the Reviews page, choose the marketplace — one of 12 stores; the United States and Canada are one store each here, with no city to pick — and paste the ASINs. Several ASINs and several stores make one line per pair, and a CSV upload adds lines in bulk.
2. Choose the mode and the schedule. New since last check and a weekly run on today’s weekday are preselected; All reviews, By stars or Latest N, a daily, monthly or manual schedule, a star or Verified Purchase filter and the time of day are in the options beside the add row.
3. Run the first check. After an add, the app offers to run the first check right away, so the baseline of the latest 100 is in place before the first scheduled run.
4. Read. The Reviews view lists every fetched review across your lines, newest first, narrowed by marketplace, ASIN, rating or new only; the Lines view shows each line’s last and next run, and Check now sits on every line.
5. Export. CSV or JSON from the page; the AMZ Reviews tab of the Google Sheets script, which appends the latest reviews under what is already in your sheet; or the API, with the same personal key as your listing data — a key that also creates lines and starts checks, which spend credits, so keep it private.

What it costs

Review runs spend checks, the same unit as the listing tracker: $0.00449 per check (5 reviews per check, about $0.90 per 1,000 reviews). Each run spends one check per 5 reviews it brings in, and at least one check. A one-off All reviews export of a listing with 400 reachable reviews is therefore about 80 checks, and a new-reviews line costs what it finds. A review line checked weekly that finds nothing new uses about 4 checks a month ($0.02); checked daily it uses 30 checks ($0.1347), the same as one tracked ASIN.

Every new account starts with a free 30-day trial: 10 checks a day, shared with the listing tracker, and up to 3 review lines. No card required. Start your free trial.

Read next

• Amazon review tracker — the feature page, field by field.
• Amazon data in Google Sheets — the Apps Script, with the AMZ Reviews tab beside your listings and keyword ranks.
• How to monitor Amazon listing changes automatically — the title, image and content changes that often sit behind a run of new reviews.
• How to track Amazon keyword rankings — whether shoppers find the listing whose reviews you are reading.