The first entry in my Amazon US Electronics best sellers list was a Blink subscription plan at $11.99. The next two were physical products: Apple EarPods at $19 and an AirTag at $23. All three appeared in the same ranking, but the prices represented different kinds of purchases.
I used Spidra’s Amazon best sellers template to capture the top 100 entries in Electronics. Here’s how to turn a category page into a spreadsheet, keep Amazon’s original rankings, and compare the listings that matter to your research.
Open the Amazon best sellers template
In the Spidra dashboard, open Templates, choose E-commerce, and select Amazon best sellers. Start here when your question is “Which listings rank highest in Electronics?” If you want to know where a product appears for a keyword like “headphones,” choose Amazon search results instead. A product can appear in both lists at different positions. Open the Amazon best sellers template.
Figure 1. The Amazon best sellers template in Spidra’s E-commerce directory.
Choose a category and set the ranking depth
Paste the category URL into Best seller pages. I used the Amazon US Electronics best sellers page. To collect several categories, enter one category link per line. The form accepts up to 20 links.
The Pages field controls how far down each list you go:
- 1 page covers ranks 1–50.
- 2 pages cover ranks 1–100.
For this run, I entered one category URL and set Pages to 2. Before you select Run, the Output panel previews the fields, including rank, title, ASIN, price, currency, and rating.
Figure 2. The Electronics category URL and two-page setting used to collect ranks 1–100.
Read the rankings before sorting by price
The completed run returned 100 rows. These were the first six listings at the time of collection, with their titles shortened for readability.
Electronics rank | Listing | Captured price |
|---|---|---|
1 | Blink Plus Plan with monthly auto-renewal | $11.99 |
2 | Apple EarPods with USB-C plug | $19.00 |
3 | Apple AirTag (2nd generation) | $23.00 |
4 | Apple AirPods Pro 3 wireless earbuds | $199.00 |
5 | Midland ER310 emergency weather radio | $79.99 |
6 | Roku Streaming Stick HD with Voice Remote | $24.00 |
Figure 3. The Electronics results show each listing’s category rank, title, ASIN, and captured price.
If I were researching audio accessories, I’d shortlist the EarPods and AirPods Pro. They appeared at ranks 2 and 4, with the AirTag between them. Filtering the sheet to headphones brings the two audio products together. Keeping the original Rank column tells me where each stood in Electronics before I filtered the list.
The Blink listing needs a different comparison. Its title says “monthly auto-renewal,” so I’d label it as a subscription before comparing its price with a one-time hardware purchase. Its first-place rank tells me where it appeared in the category at collection time. The table gives no unit-sales or revenue figure for that position.
Export the list and track changes by ASIN
Choose CSV to open the results in Excel or Google Sheets. Choose JSON if you want to use the records in an application. Keep the ASIN, Amazon’s identifier for the listing, alongside the rank. For example, the USB-C EarPods in second place had the ASIN B0DCH8VDXF. I can use that identifier to find the same pair in a later export, even if the wording of its title changes.
For repeat comparisons, add the category URL and collection date to your sheet. Select Save as preset to reuse the category and page setting. When you collect the next list, match the ASINs and compare their ranks. Keep the ranking depth consistent: a product at rank 64 in a top-100 export would be absent from a top-50 export even if its rank had stayed exactly the same.
To try this with your own category, start with one page. Export the first 50 entries, shortlist the products relevant to your question, and keep their original ranks beside their prices. Try the Amazon best sellers template.