Your Cart
Loading

Sephora US Face Makeup Dataset | 869 Products with Ingredients | November 2026 Edition

On Sale
$9.99
$9.99
Added to cart

Every face makeup product listed on Sephora US, with full ingredient lists, in one Excel workbook.

869 products from 107 brands under Makeup > Face, collected at the end of October 2026. One clean row per product, 40 columns, ready to filter and sort.

What's inside

  • Product identity: product ID, SKU, brand, product name and a link to every product page.
  • Categories: every Face sub-category each product is listed in, for example Setting Spray & Powder (187), Face Primer (157), Foundation (153), Highlighter (141), Concealer (101).
  • Pricing: list, sale and value prices as shown, plus numeric minimum and maximum columns. List prices run from $5 to $240, median $34.
  • Ratings and popularity: star rating, review count and Loves count. 881,565 reviews counted across the pack, average rating 4.31.
  • Product content: full description, one-line summary, highlights, how to use, and the filter tags Sephora shows (skin or hair type, concerns, formulation, ingredient preferences).
  • Ingredients: the full ingredient list for 820 products (94%).
  • Sizes and shades: variation type, size, number of variants and every shade or size name.
  • Flags: bestseller, new, limited edition, limited-time offer, online only, Sephora exclusive and stock status, as true or false.
  • Images: main image, second image, further image links and the product video link.

Who buys this

  • Cosmetics brands: benchmark shade ranges, prices and ratings against 107 competing brands.
  • Product developers: compare formulas, finishes and full ingredient lists across 869 products.
  • Retail buyers and marketplace sellers: spot price and assortment gaps by sub-category.
  • Market researchers: measure brand share, shade counts, price bands and new launches.
  • Data science teams: build shade, variant or rating models on a clean, current product set.

Why this dataset

  • Current: prices, ratings and review counts collected October 30, 2026; product details refreshed October 30, 2026 for 838 of 869 products.
  • Complete for the category: every product listed under Makeup > Face on Sephora US, not a sample. A product in several sub-categories appears once.
  • Clean structure: one row per product, readable true/false flags, pipe-separated lists, no embedded code or JSON.
  • Analysis-ready prices: the displayed price text is kept, and numeric columns make sorting and averaging easy, including for price ranges.

Why not collect it yourself

  • The category spans 9 sub-category listings, each needing complete page-by-page crawling so no product is missed.
  • Most products sit in several sub-categories at once, so the results need careful de-duplication.
  • Ingredients, descriptions and shade lists live on each product page: 869 separate pages to visit and parse.
  • Prices arrive as display text and ranges, and need parsing before any analysis.
  • Bot checks, layout changes and category reshuffles need ongoing maintenance.

Dataset specs

  • Products: 869 (every product listed in the category on October 30, 2026)
  • Brands: 107
  • Columns: 40
  • Format: Excel (.xlsx) with an About sheet (key numbers and a guide to every column) and a Products sheet
  • Market: United States, prices in USD
  • Edition: November 2026 Edition

Not included

  • Customer review text. This pack has each product's rating and review count; the Sephora US reviews dataset, over 4.3 million reviews, is sold separately.
  • Daily price history. Available separately on request.

Need every Sephora US category? The full catalog of over 10,000 products is available. Email us for a quote.

Columns

productId, skuId, brandName, displayName, productUrl, packCategories, primaryCategory, listPrice, salePrice, valuePrice, listPriceMin, listPriceMax, salePriceMin, salePriceMax, rating, reviews, lovesCount, variationType, size, variantCount, variantsText, quickLookDescription, longDescription, highlightsText, skuRefinementsText, suggestedUsage, ingredientDesc, isBestseller, isNew, isLimitedEdition, isLimitedTimeOffer, isOnlineOnly, isSephoraExclusive, isOutOfStock, heroImage, altImage, alternateImages, productVideoUrl, first_seen_date, detailsCollectedOn

Happy Endpoint is an independent public data provider, not affiliated with Sephora.

📩 Need a Custom Format or Have Questions?

Feel free to reach out:

hello@happyendpoint.com

https://x.com/happyendpointhq

https://happyendpoint.com/

You will get a XLSX (809KB) file