# Detergent ingredients Excel (free): names & roles

> Free Excel reference of 69 detergent ingredients: Arabic, English and INCI names, class, function, products, safety notes, label reader, calculators and a quiz.

Source: https://softwiro.com/blog/detergent-ingredients-reference-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Detergent ingredients in Excel (free): names, function and use

Decode a cleaning product's label: what each ingredient is called, what class it is, what it does and what must never be mixed.

15 November 2026 6 min read

## In short

- 69 common detergent raw materials with Arabic, English and INCI names, class, function, products and general safety notes.
- A label reader: type a product's ingredients and the sheet gives each one's class and function, and counts what it cannot find.
- A product-to-roles table (core and optional roles), not recipes, plus calculators for active matter, dilution and litres to kilograms.
- A 32-question self-test and a review tracker; a general reference, not a recipe, and safety follows the competent authority.

You read the label of a dishwashing liquid and find "Sodium Laureth Sulfate", "Cocamidopropyl Betaine" and "Phenoxyethanol", and you want to know what these names are, what each one does, and which ones can or cannot be mixed. Or you are studying detergent making and need a reference that ties the common name to the chemical name and to the class. The free [detergent ingredients sheet](https://softwiro.com/templates/detergent-ingredients-reference) puts all of this in one place and then tests you on it. (The template page is in Arabic only.)

> A general reference; check the supplier's TDS and SDS. The sheet is for learning the names, not a manufacturing recipe or a substitute for the safety data sheet (SDS) from each material's supplier. Safety, registration and use limits follow the competent authority.

## The problem it solves

Detergent names come in many forms: a trade name that changes from supplier to supplier, a common Arabic name, an English name, and an international chemical name (INCI) on the label. Students and small workshop owners often confuse a surfactant, an alkali and a chelant because the names look alike, or do not know that some pairs must never be mixed. The sheet arranges all this in one table with clear steps.

## How to use the sheet, step by step

1. Open Reference and browse the materials by class: surfactants (anionic, nonionic, amphoteric, cationic), builders, alkalis, acids, solvents, thickeners, preservatives, chelants, enzymes and more.
2. In Ingredient lookup pick the name from the list or type it in Arabic or English, and its class, function and safety note appear.
3. In Products and roles see what each product usually needs, for example why a dishwashing liquid combines an anionic surfactant, an amphoteric one, a thickener and a preservative.
4. In Label reader type any product's ingredients line by line and the sheet decodes each one's role.
5. In Calculators try the raw material needed for an active percentage, a dilution and a litre-to-kilogram conversion.
6. Test yourself in Self-test, log your review in Progress, and open Summary.

## What each sheet holds

- Reference: 69 materials with names, class, function, the products they go into and general safety notes. A concentration is written only where it is generally known, such as an SLES paste at about 70% and LABSA at about 96%.
- Products and roles: 11 products with core roles (✔) and optional roles (◐).
- Label reader: searches by chemical name, then English, then Arabic, and counts the ingredients not found.
- Calculators, quiz and progress: seven calculators, 32 questions and a review table.

## Walk-through on the sample numbers

The numbers below are sample data in the sheet:

- Lookup example: picking the SLES entry shows its English name Sodium laureth sulfate, its class "anionic surfactant" and its common commercial concentration (paste about 70% or liquid about 27–28%). Picking "dishwashing liquid" shows its core roles: anionic surfactant, amphoteric surfactant, water or solvent, thickener, preservative, scent and colour, and its optional roles: nonionic surfactant, alkali, acid and chelant.
- Label reader: 12 names from a typical dishwashing-liquid label were typed; the sheet found 11, and could not find "Sodium Cocoyl Isethionate" because it is not in the reference, so it shows "not found".
- Calculators: to get 10% active matter in 1,000 kg from a raw that is 70% active you need 142.86 kg of the raw. A 3 L pack at density 1.03 weighs 3.09 kg. Diluting a 35% concentrate to 5% in 100 kg takes 14.29 kg of concentrate.
- Sample quiz: 32 questions, 31 answered, 24 correct, a score of 75%. The branch with most questions is "Names and classes", with 10 of 13 correct.
- Progress: 6 topics averaging 73.3%, 3 of them due for review.
- Biggest class: surfactants, 19 of the 69 materials (7 anionic, 7 nonionic, 2 amphoteric, 3 cationic), then solvents with 8.

## Safety rules the sheet repeats

- Never mix chlorine bleach with an acid or ammonia: a toxic gas forms.
- Never mix a cationic surfactant with an anionic one: they cancel each other.
- When dissolving caustic soda, add it to water slowly, never water to it.
- Wear gloves and eye protection, ventilate, and read each material's safety data sheet.

## Common mistakes

- Relying on the trade name: a supplier's name can change, the chemical name does not.
- Forgetting the raw material's concentration: 10% "active matter" needs more weight from a 70% raw, not 10% of the weight.
- Treating "not found" as proof of safety: it only means it is not in the reference.
- Mixing two products in one bucket: do not, and review the forbidden pairs.
- Treating the reference as a recipe: it is for learning; your formulas are set by you and your lab.

## Who it suits and when it is not enough

It suits students and small detergent plant owners who want to understand names and roles and read labels. To cost your batches and filling see the [detergent factory sheet](https://softwiro.com/templates/detergent-factory), and to organise your revision see the [study planner](https://softwiro.com/templates/study-planner). If you need the reference tied to your plant's formulas and records in one program with user permissions, a [custom program](https://softwiro.com/contact) can be built around your way of working.

## Next step

Open the [sheet page](https://softwiro.com/templates/detergent-ingredients-reference) and download it. In "Label reader" type the ingredients of a product you have, review what the reference could not find, then take the self-test and log your score in "Progress".

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: detergent ingredients (1/3)](https://softwiro.com/uploads/cheatsheets/detergent-ingredients-reference/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/detergent-ingredients-reference/en-1.jpg)[![Cheat sheet: detergent ingredients (2/3)](https://softwiro.com/uploads/cheatsheets/detergent-ingredients-reference/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/detergent-ingredients-reference/en-2.jpg)[![Cheat sheet: detergent ingredients (3/3)](https://softwiro.com/uploads/cheatsheets/detergent-ingredients-reference/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/detergent-ingredients-reference/en-3.jpg)

0 downloads · 3 pages

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Questions this raises

### Is the reference an official curriculum or a manufacturing recipe?

No. It is a general reference; check each supplier's technical data sheet (TDS) and safety data sheet (SDS). It is for learning the names, not a recipe or a substitute for the supplier's safety data sheet (SDS).

### Where do the concentrations come from?

A concentration is written only where it is generally known, such as about 70% for an SLES paste. Commercial concentrations vary by supplier, so check your material's certificate of analysis.

### What does "not found" mean in the label reader?

It means the name is not in the current reference, not that it is safe or hazardous. You can add the material in Reference and the sheet will then find it.

### Should I mix two cleaners for a stronger effect?

No. Never mix chlorine bleach with an acid, ammonia or alcohol, and do not mix a cationic surfactant with an anionic one. Safety follows the competent authority's requirements.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
