Want to extract Walmart data straight into your spreadsheet?
You can see below the selectors designed for any Walmart listing page or Search result page to use within your =IMPORTFROMWEB() function; just pick them up directly in our Walmart product scraper template / Walmart Search scraper template or use them by yourself in your own spreadsheet.
=IMPORTFROMWEB("Walmart product URL", "title, price")
=IMPORTFROMWEB(A2,B1:C1)
Product selectors
| Selector | Description |
|---|---|
| upc | Universal Product Code |
| title | Title of the listing |
| brand | Product brand |
| brand_link | Link to the brand page of the product |
| description | Description of the listing |
| bullet_points | Listing’s bullet points |
| buybox_winner | Seller who gets the buybox |
| price* | Product price |
| ratings | Average rating |
| reviews_count | Number of reviews |
| category_N** | Category of the product (replace N by the desired value) |
| categories | All product categories (make sure to leave empty cells below) |
| featured_image_source | Collects the main image source for each product listed |
| availability | Availability of the product |
| imageN_source | Image of the product page (replace N by the image number) |
| images_source | All the images of the product page (make sure to leave empty cells below) |
*Pricing information: Prices, terms, and availability may vary according to the region. Items sold online by Walmart may be eligible for price match, while items sold by Marketplace Sellers are not eligible for price match. Therefore, as the server can be located elsewhere than where you are, the price may be different.
**The categories of the product are ranked from the 1st (Home) to the last one (up to 8). 
Search results selectors
| Selector | Description |
|---|---|
| name | Collects each product name |
| price | Collects each product price |
| price_text | Collects the value together with the currency |
| rating | Collects average rating for each product listed |
| reviews_count | Collects number of reviews collected for each product listed |
| link | Collects the URL of each product listed |
| image_source | Collects the main image source for each product listed |
| id | Collects the product id |
| us_item_id | Collects the product US id |
| availability | Indicates whether the product is available or not |
| badge | Extracts the badge of the product |
| sponsored | Indicates whether the product is sponsored or not |