Skip to content
Radish — back to home
← All articles Data

Vitamins and minerals: what the Ciqual 2025 table leaves blank, by food group

How much vitamin and mineral data is missing from the Ciqual 2025 table?

In the Ciqual 2025 table (3,484 foods), 41.1% of the cells in the 33 vitamin and mineral columns hold a dash, meaning the content is not known: 29.7% for the 12 minerals and 47.6% for the 21 vitamin columns. Vitamin K2 has a numeric value for only 102 foods out of 3,484, vitamin D for 1,437. A dash does not mean zero: the Anses documentation asks users not to treat it as a zero value.

Source: Anses, Ciqual French food composition table 2025, DOI 10.57745/RDMHWY (version of 19 Nov 2025). Radish calculations on the official Excel file, retrieved 16 Nov 2026. Published .

Radish · 6 min

A "foods rich in iron" ranking built on the Ciqual table can only rank the foods that have a value. Here is the map of the cells without a value, constituent by constituent and group by group, computed on the official Anses file.

What the Anses documentation says about its own gaps

The official documentation (section 3.2.2, in French) states that when a content is not known, a dash stands in place of the value; that users must take missing values into account and not treat them as zeros; and that 30% of mean values are missing across the whole table, 0.1% for alcohol and 95% for vitamin K2. Our recount finds the same extremes (alcohol 0.1%, vitamin K2 95.0%). Across all 74 constituent columns of the Excel file we count 32.3% dashes against 30% in the documentation, which does not state how it counts: we publish our figure with its method rather than reuse theirs.

Which constituents are the least documented?

The table ranks the 33 vitamin and mineral columns by share of dashes across the 3,484 foods. Several columns are forms of the same vitamin (vitamin E and alpha-tocopherol, four folate columns, vitamin D and its D2 and D3 forms): they are counted separately, as in the file. Two pairs are mutually exclusive: no food has a content in both "vitamin E" and "alpha-tocopherol", nor in both "total folates" and "total folates in DFE". A dash in one of them therefore does not mean the information is missing: it may sit in the other. Neither vitamin E column is filled in for 1,155 foods (33.2%), neither total folate column for 1,051 (30.2%).

Constituent (per 100 g)Dash (not known)“traces”“< threshold”Numeric value
Vitamin K295.0 % (3,309)1.5 %0.6 %2.9 %
Vitamin E82.9 % (2,889)0.1 %0.1 %16.8 %
Vitamin B9, total folates in DFE73.9 % (2,576)0.0 %0.0 %26.1 %
Intrinsic folates73.8 % (2,572)0.6 %0.5 %25.1 %
Vitamin B9, total folates56.2 % (1,959)0.1 %2.6 %41.1 %
Vitamin D2 (ergocalciferol)55.7 % (1,942)9.2 %9.2 %25.8 %
Chloride55.7 % (1,939)0.0 %4.4 %39.9 %
Vitamin K154.8 % (1,910)0.0 %8.0 %37.2 %
Folic acid (fortification)53.7 % (1,870)0.0 %4.5 %41.8 %
Alpha-tocopherol (vitamin E)50.2 % (1,750)0.1 %4.8 %44.9 %
Vitamin A activity (retinol equivalents)44.8 % (1,562)0.0 %0.0 %55.2 %
Beta-carotene41.2 % (1,434)0.4 %11.3 %47.1 %
Selenium39.7 % (1,383)0.2 %27.6 %32.5 %
Vitamin D3 (cholecalciferol)39.6 % (1,379)4.6 %13.2 %42.6 %
Iodine39.5 % (1,376)0.0 %23.5 %37.1 %
Vitamin B1238.1 % (1,328)0.2 %3.4 %58.3 %
Vitamin D37.6 % (1,310)3.8 %17.3 %41.2 %
Vitamin B5 (pantothenic acid)33.3 % (1,159)0.1 %1.2 %65.4 %
Manganese31.2 % (1,086)0.4 %9.0 %59.4 %
Vitamin C31.2 % (1,086)0.8 %16.3 %51.8 %
Copper29.2 % (1,018)0.1 %9.5 %61.1 %
Vitamin B2 (riboflavin)28.6 % (997)0.1 %10.1 %61.2 %
Vitamin B1 (thiamin)28.1 % (980)0.1 %8.5 %63.2 %
Vitamin B3 (niacin)27.4 % (956)0.0 %9.3 %63.2 %
Vitamin B627.2 % (947)0.0 %5.1 %67.7 %
Phosphorus27.0 % (942)0.1 %1.5 %71.4 %
Retinol25.8 % (900)0.4 %10.0 %63.8 %
Magnesium25.8 % (899)0.0 %0.5 %73.7 %
Zinc25.7 % (897)0.5 %6.0 %67.8 %
Potassium24.9 % (867)0.0 %0.4 %74.7 %
Iron23.9 % (831)0.2 %5.4 %70.6 %
Calcium22.5 % (784)0.0 %0.7 %76.8 %
Sodium11.5 % (402)0.1 %4.3 %84.1 %

Reading: vitamin K1 has a dash for 54.8% of foods. "< threshold" = a value below a limit given in the file; "traces" = detected but not precisely quantifiable, or, without analysis, a content estimated as very low but not zero (documentation, section 3.2.3; see also see How to read the Ciqual table). The four columns may not sum to exactly 100% because of rounding.

Do the gaps differ by food group?

Yes, and the spread can be wide for a single constituent. Share of dashes (%) for eleven constituents, by Ciqual food group (groups are the table's own, translated by us; the last column pools all 33 columns).

Group (foods)IronIodineSeleniumVit. A (RE)Vit. DAlpha-tocopherolVit. K1Vit. CFolates (DFE)Total folatesVit. B12Mean of the 33
Meat, eggs, fish (791)18.542.038.759.439.754.560.940.198.937.526.346.0
Fruit, vegetables, legumes and oilseeds (653)20.240.741.227.940.736.434.89.625.096.247.632.1
Starters and composite dishes (407)34.640.043.754.143.266.370.340.896.643.545.751.2
Sugary products (361)26.938.037.138.834.942.749.632.174.254.037.140.6
Dairy products (356)31.734.336.552.832.346.159.848.978.456.238.845.2
Water and other beverages (325)22.532.635.432.032.970.568.320.976.945.533.834.6
Culinary aids and miscellaneous ingredients (235)23.449.449.447.731.955.350.629.476.254.042.140.0
Cereal products (214)24.339.340.248.647.238.848.138.870.159.853.340.5
Fats and oils (72)11.136.144.423.620.827.847.216.758.361.116.731.0
Infant foods (39)0.025.610.328.22.628.259.07.7100.02.62.626.1
Ice creams and sorbets (30)46.746.743.346.746.766.770.050.0100.043.350.053.5
All foods (3,484)23.939.539.744.837.650.254.831.273.956.238.141.1

Iodine and selenium: about one food in four is "< threshold"

For iodine, 23.5% of foods have a value of the form "< threshold" and 39.5% a dash; for selenium, 27.6% and 39.7%. Sodium is the least incomplete of the list (11.5% dashes).

How to read this table without being misled

Method

  1. File: Table Ciqual 2025_FR_2025_11_03.xlsx, downloaded on 16 Nov 2026 from the official repository (DOI 10.57745/RDMHWY, version 1.0 of 19 Nov 2025). MD5 checksum 0d9758ce23f3f13dd63a005bc1bb4f2c, identical to the one published by the repository.
  2. Scope: the 3,484 food rows, sheet "composition nutritionnelle". One row ("Dessert (aliment moyen)", code 24999) has no group: it counts in "All foods" but not in the 11 groups (3,483 foods). The 33 columns kept are the 12 minerals (calcium, chloride, copper, iron, iodine, magnesium, manganese, phosphorus, potassium, selenium, sodium, zinc) and the 21 vitamin columns. Salt, energy and macronutrients are excluded.
  3. Cell classification: a dash ("-"), the word "traces", a value preceded by "<", or a numeric value. No other form exists in these columns; the script stops on any unknown form. For each column the four counts sum to the number of foods.
  4. Limits: we read the file's mean values (not minimums, maximums, confidence codes or sources). Counts depend on the file version; an Anses update may change them.
  5. Reproduce: Python (standard library only) on the official file; the script is published with the page: ciqual-2025-lacunes.py (Etalab 2.0 licence; MD5 of the source file given above).

Download the table (CSV)

ciqual-2025-lacunes-vitamines-mineraux-en.csv (396 rows: 33 constituents × 12 levels, all foods and 11 groups). Semicolon separator, decimal point, UTF-8. Columns: INFOODS code, constituent, group, counts (numeric value, traces, "<", dash) and percentages. Group and constituent names are translated by Radish; the French original is in the French CSV.

Licence and citation

The Anses dataset is published under the Etalab Open Licence 2.0 (stated on the dataset record, DOI 10.57745/RDMHWY). The counts and percentages on this page and in the CSV are Radish calculations based on that data, not Anses data; we make them available under the same licence (licence notice shipped with the CSVs). Anses has neither validated nor endorsed these calculations. To cite them:

Radish, based on Anses, Ciqual French food composition table 2025, https://doi.org/10.57745/RDMHWY (version of 19 Nov 2025), calculations of 16 Nov 2026.

Frequently asked questions

How much of the Ciqual 2025 table is missing?

According to the Anses documentation, 30% of mean values. Across the 33 vitamin and mineral columns we count 41.1% dashes.

Which vitamin is the least documented?

Vitamin K2: 102 foods out of 3,484 have a numeric value (95.0% dashes).

Does a dash mean zero?

No. It means the content is not known; the documentation asks users not to treat it as zero.

General information about published data, not nutrition advice.

Ready to try Radish?Private calorie counter, Nutri-Score, no ads. Free.Get Radish →