Amazon data selectors (search page)

Want to extract Amazon products lists straight into your spreadsheet?

You can see below the selectors to use within your =IMPORTFROMWEB( ) function; just pick them up directly in our Amazon Search scraper template or use them by yourself in your own spreadsheet.

=IMPORTFROMWEB("Amazon search url", "title, price")
=IMPORTFROMWEB(A2,B1:C1)

Please note that ImportFromWeb works with most of Amazon markets, including US (.com), Canada (.ca), Mexico (.com.mx), Brazil (.com.br), UK (.co.uk), France (.fr), Germany(.de), Netherlands (.nl), Spain (.es), Italy (.it), Turkey (.com.tr), India (.in), Saudi Arabia (.sa), UAE (.ae), Japan (.jp), Australia (.com.au), Singapore (.sg)

Those are the selectors to use to extract the “organic” ASINs

Selector Description
asinCollects each product ASIN
titleCollects each product title
priceCollects each product price (price_currency to get the currency only / price_text to get the value together with the currency)
ratingCollects average rating for each product listed
reviews_countCollects number of reviews collected for each product listed
has_dealIndicates whether the product has a current deal
couponIndicates whether the product has a coupon and the value of this coupon
badgeIndicates “best sellers”, “Amazon’s choice” and “Amazon exclusive” ASINs
link*Collects the URL of each product listed
featured_image_sourceCollects the main image source for each product listed
number_of_results*Returns the number of results from your search

*number_of_results: The following selector shouldn’t be mixed with the previous selectors and must be used individually.

Additional selectors for sponsored products

Please note that “sponsored” selectors can not be combined with the “organic” selectors

SelectorDescription
sponsored_asinExtracts the ASINs of the sponsored products
sponsored_titleCollects sponsored product titles
sponsored_priceCollects prices of the sponsored products
sponsored_ratingCollects ratings of the sponsored products
sponsored_times_evaluatedExtracts the number of reviews for each sponsored product
sponsored_linkCollects links of the sponsored products
sponsored_featured_image_sourceExtracts the featured Image’s link of the sponsored products