Free UK Cosmetic and Health Product Ingredients Dataset: 100 Tesco Products in Excel
Explore a free Tesco UK ingredients dataset with 100 health and beauty products from 10 departments, each with its full ingredient list as printed and one row per ingredient: 2,123 ingredient rows in label order. Use the Excel sample to see which ingredients and preservatives UK skincare, haircare, toothpaste, supplements and medicine products use, before requesting a broader extract.
What's included
- Product identity: product titles, 84 brands, Tesco product IDs, GTIN barcodes, department, aisle and shelf, pack sizes, and a link to each product page on tesco.com.
- Full ingredient lists: the complete ingredient list of every product exactly as Tesco prints it, from 5 to 48 ingredients per product (21 at the median).
- One row per ingredient: 2,123 rows, each with its position on the label, the ingredient as printed, and a grouping key that merges the spellings of water (Aqua) and fragrance (Parfum). 813 distinct ingredients.
- Careful splitting: bracketed groups such as "Bulking Agents (Dicalcium Phosphate, Microcrystalline Cellulose)" or "[+/- CI 77491, CI 77492]" stay one row, and chemical names such as "1,2-Hexanediol" stay whole.
- Fragrance flag: a yes/no column for products that contain parfum or fragrance (46 of the 100).
- Usage and safety text: directions and warnings as printed, where Tesco shows them.
- Prices and ratings: shelf price, unit price, average rating and review count.
Departments covered
10 products from each of: Face Skincare, Body Skincare, Makeup & Accessories, Shampoo, Hair Colourants & Dyes, Deodorants, Suncare & Travel, Toothpaste, Mouthwash & Toothbrush, Vitamins, Minerals & Supplements, and Medicine.
What you can do
Find every product that contains a given ingredient, count how often a preservative such as phenoxyethanol or sodium benzoate is used, compare toothpaste or sunscreen formulas, check which products are fragrance free, or test an ingredient parser or INCI lookup on real UK labels. Each row links to the live product page, so you can check any product yourself.
The included worked example counts the ingredients that appear in the most products. Water (Aqua) is in 69 of the 100, glycerin and parfum in 46 each, and citric acid and limonene in 33 each. It also counts fragrance by department: all 10 shampoos and all 10 deodorants contain it.
Inside the workbook
One Excel file with a Products sheet (one row per product, full list in one cell), an Ingredients sheet (one row per ingredient, joined by Product ID), the completed Example, and a Data Dictionary that defines every column. A Start Here guide explains how to use each sheet. Barcodes and IDs are stored as text, so leading zeros are kept.
Sample scope: Ingredient lists were recorded on 22 October 2026. Formulas change, and the products are a balanced selection, 10 per department, not a representative sample of Tesco. Not for allergy, medical or safety decisions; always check the product label.
Need more? The full Tesco UK dataset has ingredient lists for 38,596 products, 5,235 of them in Health & Beauty, plus food ingredients, allergens and nutrition. Contact us for an ingredient extract by department, brand or ingredient, or for the full dataset.
Independent Happy Endpoint sample, not affiliated with Tesco.