Free Sephora Ingredients Dataset | 50 Products, 1,539 Ingredient Rows | November 2026 Edition
A free Excel sample of Sephora US ingredient lists: the full INCI list of 50 beauty products, split into one row per ingredient, with the brand's key-ingredient claims.
50 Sephora US products from 47 brands, 5 from each of 10 sub-categories: face serums, moisturizers, cleansers, face sunscreen, eye creams, face masks, foundation, lip balms, shampoo, and body lotions and oils. Each product has its full ingredient text exactly as Sephora shows it, and the ingredient list is also split into rows in label order, so you can filter, count and compare formulas without parsing anything yourself. Every row links to the product page on sephora.com, so you can check it yourself.
What's inside
- Full ingredient text: one cell per product, exactly as shown on sephora.com, with brand, product name, price, rating, review count, size and product highlights.
- One row per ingredient: 1,539 rows in label order (position 1 is the first ingredient on the label), with a grouping key that merges the spellings of water (Aqua) and fragrance (Parfum). 703 distinct ingredients; 31 ingredients per product at the median, from 9 to 57.
- Key-ingredient claims: 140 rows, the ingredient each brand highlights and what it says it does, for example "Niacinamide: Minimizes the appearance of pores and boosts the skin barrier".
- Ingredient-preference tags: Sephora's filter tags such as Fragrance Free, Paraben Free, Vegan or Hyaluronic Acid, for 44 of the 50 products (20 tagged Fragrance Free).
- Careful splitting: bracketed groups such as "Iron Oxides (CI 77491, CI 77492)" and "May Contain" shade lists stay one row, and names such as "1,2-Hexanediol" stay whole.
In numbers
- Most common ingredients: water in 42 products, glycerin in 36, phenoxyethanol in 26, sodium hyaluronate in 25 and tocopherol (vitamin E) in 22
- Niacinamide: 12 of the 50 products
- Ingredient text collected: October 30, 2026; prices and ratings from the listing of November 10, 2026
What you can do with it
- Check how often an active or a preservative appears, and in which categories.
- Compare formulas: which serums or sunscreens share the same base ingredients.
- Test an ingredient parser, an INCI lookup or a "what's in my skincare" app on real data.
- Match brand claims to the position of the claimed ingredient in the list.
Sheets
- About: key numbers, every column with its fill rate, how the rows were made
- Products: 50 rows, one per product, with the full ingredient text
- Ingredients: 1,539 rows, one per ingredient, joined by productId
- Key Ingredients: 140 rows, joined by productId
Want more?
- Full ingredient data: 8,725 of the 10,114 products listed on Sephora US have a full ingredient list. All of them, split the same way, are available by quote.
- Ingredient extracts: every product that contains one ingredient (for example niacinamide or zinc oxide), or the lists for one brand or category.
- Category packs: every product in a Sephora US sub-category with prices, ratings, descriptions and full ingredient text, November 2026 Edition.
Ingredient lists are reproduced as shown online and formulas change, so the product packaging is the reference. Not for allergy or safety decisions.
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/