How to scrape Amazon product data to Excel (free, no code)

You have an Amazon search full of exactly the products you want to track, and now you need it in a spreadsheet: titles, prices, ratings, review counts, and links. Copying each card by hand is slow and error-prone, and writing a Python scraper with proxies is overkill for a product-research job. There is a faster way. This guide shows you how to scrape Amazon product data into an Excel or CSV file in about two minutes, for free, without writing a line of code, using the Grabby web scraper Chrome extension.

By the end you will have a clean spreadsheet of Amazon products you can sort, filter, and reuse, whether you are tracking competitor prices, doing product research, or building a catalog.

Is it legal to scrape Amazon?

Scraping publicly visible data for personal research is generally acceptable, but it is not a free-for-all. Amazon’s terms restrict automated collection, so keep your usage reasonable: pull the pages you actually need, don’t hammer the site, and don’t republish copyrighted content such as images or full reviews. Because Grabby reads the page you have already loaded in your own browser, at your own pace, it behaves far more like a person browsing than like an aggressive bot. Use it responsibly and review Amazon’s terms. (This is a how-to, not legal advice.)

What you’ll need

• Google Chrome, Microsoft Edge, or Brave.
• The free Grabby extension. No account, no API key, and no proxies, and it runs entirely in your browser.
• An Amazon search results page for whatever you want to collect.

Step 1: Install Grabby (free)

Add Grabby to your browser from the Chrome Web Store. There is nothing to sign up for and nothing to configure. Everything in this guide works on the free plan.

Step 2: Open your Amazon search

Go to Amazon and search for what you want, for example wireless earbuds, and you will land on a results page such as amazon.com/s?k=wireless+earbuds. Scroll down once so the whole first page of products has loaded. Filter or sort on Amazon first (by price, rating, Prime, and so on) if you want, because Grabby captures whatever the page is showing.

Step 3: Select the product list

Click the Grabby icon to open its side panel, then choose Scrape List. On a supported site like Amazon you will also see a one-click template for the search results, so you can skip straight to the data. Otherwise click Select the list and click any one product card. Grabby highlights the entire repeating set of products, and a single click grabs them all. No CSS selectors, no XPath.

Grabby figures out the columns for you: title, price, rating, review count, product image, and the link to each listing. You get a live preview of how many products and columns it found.

Install Grabby free and follow along

Step 4: Grab every page, not just the first

An Amazon search runs across many pages. Before you run the scrape, tell Grabby how to page through them:

• Pagination: point at Amazon’s Next button once, and Grabby clicks through each results page for you.
• Just this page: when the first page is all you need.

Set a sensible maximum number of pages, hit Start, and watch the row counter climb as Grabby walks each page and collects every product. To keep things friendly with Amazon, don’t run dozens of pages back to back; a handful at a time is plenty for most research.

Optional: pull each product’s detail page

Need fields that only appear on the individual product page, such as the brand, description, or availability? Give Grabby the column of product links and it will open each one and pull those extra fields, then merge them back into your table. It is the difference between a list of products and a full dataset.

Step 5: Clean and sort the data

Your results open in an editable data table. This is where a good scrape becomes a good spreadsheet. Sort by price to find the cheapest options, remove empty or duplicate rows, rename columns, and hide any columns you do not need, all before you export. Everything here is non-destructive, so you can tidy the file until it is exactly what you want.

Step 6: Export to Excel, CSV, or JSON

Click Export and choose your format. Pick CSV or Excel and open the file directly in Excel, export JSON if you need the data somewhere else, or copy the whole table and paste it straight into Google Sheets. Everything is saved locally, so the file is yours and nothing is uploaded.

Troubleshooting

• Wrong or missing columns? Re-select the list, or use the column tools to add the field Grabby missed.
• Pagination stops early? Choose Pagination and point at Amazon’s Next button manually so Grabby knows exactly what to click.
• Prices look blank? Scroll the page once so all cards render, then run the scrape again.
• Hit a CAPTCHA? You are moving too fast for Amazon. Run fewer pages and give it a moment between runs.

Frequently asked questions

Is it really free? Yes. Grabby is free while in early access, with every feature unlocked and no sign-up.

Does Amazon block this? Grabby reads the page you already loaded in your normal browser session, so it isn’t firing the automated requests that anti-bot systems look for. Very large, rapid runs can still trigger a CAPTCHA, so keep page counts reasonable.

Can I scrape ratings and review counts? Yes, both are captured as columns automatically. Full review text lives on each product page and can be pulled with detail-page scraping.

Can I export to Google Sheets? Yes, copy the table and paste it straight into a sheet, or export CSV or Excel and import it.

Will it work on other stores? Yes. The same point-and-click method works on eBay, Walmart, and virtually any site with a product list.

Scrape any other site the same way

Amazon is just one example. The same select, paginate, clean, and export flow works on any website with a repeating list or table. For the general version of this walkthrough, see our guide to scraping any website to Excel without writing code.

That’s your Amazon data in a spreadsheet, free and without code. Install Grabby and turn any Amazon search into Excel in two clicks.