Amazon Best Sellers Scraper for CSV Export
This Amazon Best Sellers scraper exports public Amazon top-list and category ranking pages into a structured CSV for product research, category monitoring, and marketplace analysis. Import the workflow into the UScraper local desktop app, replace the starting URLs with approved Amazon Best Sellers, New Releases, Movers and Shakers, Most Wished, or Most Gifted pages, and collect rank, product name, URL, brand, rating, review link, platform, price, image, and status fields without writing scraper code.
CSV file
13
Multi-URL
30s + 2s
Free
What it does
Scrape Amazon Best Sellers and top-list data to CSV
Amazon top-list pages are useful when you need a repeatable snapshot of products Amazon is ranking inside a category. This Amazon best sellers extractor starts from a list of category URLs, waits for the page body and ranking cards, then runs a Structured Export over each product card that appears.
The automation path is high level and reviewable: Navigate -> Wait for Page Load -> Wait for Element -> product-card check -> Structured Export -> Next pagination check -> Click -> wait, sleep, and loop. The Navigate block can be replaced with any Amazon Best Sellers page, Amazon best selling books category, New Releases page, Movers and Shakers page, Most Wished page, or Most Gifted page that fits your research scope.
Ranking rows with context
Keep the original URL and category beside every product so repeated exports are easy to filter, compare, and join with later product-detail or review datasets.
Pagination already connected
The graph checks for localized Next links, clicks through available pages, waits after navigation, and continues the current input until the list ends.
Diagnostic rows for blocked pages
Empty, challenged, or redirected pages still produce an error value such as captcha_or_robot_check, login_required, or no_product_rows_found.
Spreadsheet-first export
Headers and append mode are enabled, so multi-category runs land in one CSV that can be opened in Excel, Sheets, BI tools, or enrichment scripts.
Who this is for
Use cases for Amazon ranking exports
- Marketplace sellers can export Amazon Best Sellers data before deciding which categories, prices, and review-count bands deserve deeper sourcing work.
- Publishers and authors can sample Amazon book charts or Amazon best selling books lists, then compare ranks, prices, and review counts across repeated runs.
- Agencies and ecommerce analysts can collect category snapshots for client reports without routing the CSV through a hosted scraping actor.
- Merchandising teams can compare Best Sellers with adjacent lists such as New Releases, Movers and Shakers, Most Wished, and Most Gifted.
For adjacent marketplace research, pair this template with the Amazon Hot New Releases Scraper, Amazon Movers and Shakers Scraper, Amazon Most Wished For Scraper, and Amazon Product Details Scraper for US.
How to use
Configure the Amazon Best Sellers scraper workflow
Choose category URLs
Replace the Navigate URL list with the Amazon Best Sellers page or related top-list category URLs you are allowed to review.
Confirm the export path
Structured Export writes amazon-best-sellers-scraper.csv with headers and append mode. Change the save folder before running project-specific batches.
Run the loop
UScraper loads each URL, waits for content, exports visible ranking cards, clicks Next when available, pauses briefly, and continues until the current input ends.
Open and audit the CSV
Review rank order, missing prices, duplicate products, error rows, and sample product links before using the export in reporting or downstream analysis.
Output preview
Amazon Best Sellers CSV fields
The export is designed for category comparison rather than a thin product list. The original_url and category fields repeat on every row, while the error field stays blank for successful product rows and records access or layout issues when no cards are found.
| original_url | category | position | name | url | brand | stars | ratings | reviews_link | platform | price | picture | error |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| https://www.amazon.co.uk/gp/new-releases/books | Books | #1 | Sample suspense novel paperback | https://www.amazon.co.uk/dp/B0BOOK1234 | Example Press | 4.6 out of 5 stars | 2,418 | https://www.amazon.co.uk/product-reviews/B0BOOK1234 | Paperback | GBP 8.99 | https://m.media-amazon.com/images/I/example.jpg | |
| https://www.amazon.de/gp/movers-and-shakers/garden | Garden | #7 | Sample raised garden bed | https://www.amazon.de/dp/B0GARDEN99 | GreenCo | 4.4 out of 5 stars | 846 | https://www.amazon.de/product-reviews/B0GARDEN99 | EUR 39.99 | https://m.media-amazon.com/images/I/example2.jpg | ||
| https://www.amazon.es/gp/bestsellers/mobile-apps | Mobile Apps | captcha_or_robot_check |
amazon-best-sellers-scraper.csvColumn
original_url
The Amazon category URL opened for the current loop iteration.
Column
category
Current category or list name inferred from navigation or page headings.
Column
position
Visible rank badge from the Amazon ranking card.
Column
name
Product title, with image alt text and card link text as fallbacks.
Column
url
Amazon product detail URL from the ranking card.
Column
brand
Best-effort brand, publisher, or seller text when Amazon renders it.
Column
stars
Visible star-rating text.
Column
ratings
Visible rating or review count text.
Column
reviews_link
Product reviews URL when Amazon exposes one.
Column
platform
Platform or format text such as app platform, paperback, Kindle, or device family when available.
Column
price
Visible price text where Amazon displays it.
Column
picture
Primary product image URL from the card.
Column
error
Diagnostic value for CAPTCHA, sign-in, not found, or empty-card pages.
Local desktop template vs cloud scrapers and APIs
| Option | Good fit | Trade-off |
|---|---|---|
| UScraper Amazon Best Sellers template | No-code users who need editable category URLs and local CSV exports | Best for controlled research batches, not high-volume crawling infrastructure |
| Hosted cloud scrapers | Teams that want managed proxy, scheduling, and cloud execution | Product pages and exported rows pass through a third-party runtime |
| Amazon official APIs | Developers with approved access and contractual reuse requirements | Requires code, credentials, eligibility, and may not mirror every visible ranking page |
Frequently asked questions
Amazon Best Sellers pages may be publicly visible, but automated collection can still be restricted by Amazon Conditions of Use, robots rules, marketplace policies, intellectual property rights, privacy law, and local regulations. Keep runs modest, do not bypass CAPTCHA or access controls, and get legal review before commercial reuse.
Before you scale
Practical limits and maintenance notes
Guardrails for reliable Amazon category exports
Amazon may throttle or challenge automation
Use modest batches, avoid parallel runs against the same marketplace, and add longer waits when pages load slowly or product cards appear incomplete.
Top-list layouts vary by category and region
Missing titles, blank ranks, or empty prices usually mean Amazon rendered a different card layout, hid a field, or returned an access page instead of product rows.
Review terms before commercial reuse
Treat the CSV as a research export. Review Amazon policies, robots directives, official API options, and applicable law before redistributing, reselling, or enriching scraped product data.
Download the template, install the local desktop app from UScraper download, and use the UScraper template library when you need follow-up scrapers for Amazon reviews, product details, or broader ecommerce monitoring.
Get Started
Download and use this template instantly
What's Included
- Template JSON file ready to import
- Pre-configured scraping nodes
- Works with UScraper desktop app
Open-source templates
UScraper templates are open source. Improve this workflow or contribute a new one to help the community grow.
Contribute on GitHubBrowse more templates in the library
All Templates