Want to extract Amazon product data straight into your spreadsheet?
You can see below the exhaustive list of selectors designed for any Amazon product page. These built-in data selectors are used within your =IMPORTFROMWEB( ) function; just pick them up directly in our Amazon scraper template or use them by yourself in your own spreadsheet.
=IMPORTFROMWEB("url", "name, rating")
=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)
You want to scrape in another language than English ? We made a special FAQ there.
Indicates whether the product is available or not (+ the available quantity when specified)
list_price
Manufacturer Suggested Retail Price (list_price_currency to get the currency only & list_price_text to get the value together with the currency)
sale_price
Sale price of the product (sale_price_currency to get the currency only & sale_price_text to get the value together with the currency)
sale_price_per_unit
Unit sale price of the product
prime_price
Returns the price of the product with an Amazon Prime account
badge
Indicates “best sellers”, “Amazon’s choice” and “Amazon exclusive” ASINs
has_coupon
Indicates whether the product has a coupon or not (true or false)
coupon_discount
Coupon value
has_deal
Indicates whether the product has a current deal or not (true or false)
buybox_quantity_max
Maximum selectable quantity
buybox_winner
Seller who gets the buybox
buybox_winner_link
URL of the Buybox seller page
ships_from
Indicates the product’s shipper
shipping_cost
Shipping price
offers_count
Indicates the number of offers for a given product (new and used)
normal_delivery
Indicates the standard delivery date
fastest_delivery
Indicates the fastest delivery date
sellers_names*
Lists all the sellers of the product including the buybox winner*
sellers_prices*
Lists all the prices including the buybox price*
sellers_links*
URL of all the sellers pages including the buybox winner*
sellers_offer_types*
Type of offers for all the sellers (new, used…) including the buybox winner
* when you use the selectors sellers_*** selectors, the function opens a new pop up (same as when you click on the “see other vendors” link). As a consequence, those selectors cannot be combined with any other selector within the same function.
