Estimating Food Nutrition Composition with Excel

Ever wondered how much calorie there is a waffle or how much protein to put in a nutrition bar? With consumers becoming ever more health conscious, its imperative that food adheres to the nutrition standards that they expect. Consumer have expectations around both macro nutrients, like carbs starch etc. and micro nutrients like Vitamins, trace minerals etc. However, the many ingredients add to the complexity of its nutrition profile and and cooking processes modify the nutrition composition. While a true nutritional analysis results requires chemical analysis of the end product, one can approximate the nutritional content via standardized databases. As food habits differ across the world, almost every country has their own food composition database . These databases detail both the macro as well as the micro nutrients. Some databases even callout brands, exotic foods and ingredient list. For example if you searche for a Waffle in the USDA database you will get complete nutritional profile of waffle as well as the ingredient list. In many countries they also characterize standard of identities of food and beverages. Thus they form the basis of regulations world over. You can plugin the nutrition values from the database into the our simple nutrition calculator to estimate nutrition content. We listed some of the more popular databases below, as provided by the global Food and Agriculture Organisation (FAO). As a best practice , it is best to use nutrition values for ingredients from the tables corresponding to the country in which you will be selling your product. Asia China China Food Composition 2002 Institute of Nutrition and Food Safety, China CDC, Beijing 2002* 393 pp (Chinese & English) mailto:nutri@163.com India Indian Food Composition Tables (2017). T. Longvah; R. Ananthan; K. Bhaskarachary; K. Venkaiah. The PDF file can be downloaded from http://www.ifct2017.com/ Japan About Standard Tables of Food Composition in Japan (outline), Office for Resources, Policy Division, Science and Technology Policy Bureau, Ministry of Education, Culture, Sports, Science and Technology (MEXT), Japan Standard Tables of Food Composition in Japan, Office for Resources, Policy Division, Science and Technology Policy Bureau, Ministry of Education, Culture, Sports, Science and Technology (MEXT), Japan. This page provides access to the following documents: Korea Korean Standard Food Composition Table - Rural Resources Development Institute - Rural Development Administration, Suwon - 8th ed 2011* (Korean with English) Malaysia Malaysian Food Composition Database (MyFCD) Nepal Food Composition Table for Nepal 2012. Nepal Government, Ministry of Agriculture Development, Department of Food Technology and Quality Control, National Nutrition Program. Kathmandu, Nepal (English) (2012) Singapore Energy and Nutrient Composition of Food (2011) Thailand Thai Food Composition Database 2015 SMILING Food composition table for Thailand (2013): table a, 142 foods with references at value level table b, 142 foods with quality assessment at value level Nutritive values of Thai foods (Thai version) published by the Nutrition Division, Ministry of Public Health (2001) Amino acids composition, published by Ministry of Public Health Fatty acids and cholesterol, published by Ministry of Public Health Vietnam SMILING Food composition table for Vietnam (2013): table a, 162 foods with references at value level table b, 162 foods with quality assessment at value level Vietnamese Food Composition Table (2000) North America United States of America USDA National Nutrient Database for Standard Reference (English) (2016) Alaska Traditional Knowledge and Native Foods Database Atwater and Woods: The Chemical Composition of American Food Materials, USDA 1896 All tables USA Tables Canada Canada's national food composition database (2015) CINE's Arctic Nutrient File All tables Canadian Europe Armenia Food Composition Table for Armenia - Karine Babikyan. 74 pp. (Armenian and English) (2010) Belgium NUBEL - Belgian Food Composition Data (2012) NUBEL - Database of trade names Bulgaria Tables of the Composition of Bulgarian Food Products - T Tashev, G Shishkov Medizina y Fizkultura, Sofia (Russian) (1975) Croatia Tablice o Sastavu i Prehrambenoj Vrijednosti Namirnica i Pica - A Brodarec Institute of Public Health of SR Croatia, Zagreb - 3rd ed,* 134 pp (Serbo-Croatian) (1976) Czech Republic Centre for Food Composition Database - Czech Food Composition Database, Version 2.11 Food Composition Database at National Institute of Public Health All tables Denmark Food data (frida.fooddata.dk), version 4, 2019, National Food Institute, Technical University of Denmark All tables Estonia Estonian food composition database, online version (available in Estonian, Russian and English) (2012) Finland Fineli Finnish Food Composition Database (2019) All tables France ANSES-CIQUAL French food composition table version 2020 All tables Georgia Food Composition Tables (National Association of Nutritionists) 139 foods, 49 nutrients, 104 pages, in Georgian and English languages For more information contact Robizon Tsiklauri (2009) Germany Food composition tables (2012) German Nutrient Database: BLS online portal Greece Food composition tables (2004) Medical School of Crete: Food composition tables of Greek foods Greenland Nogle undersogelser af gronlandske levnedsmidler og kostforhold, appendix tables - Beretninger vedrorende Gronland, No 3-11 Statens Praktisk-Sundhedsmaessige undersogelser og Vitamin-laboratori, Copenhagen, Denmark 47 pp (Danish) (1955) Hungary Tápanyagtáblázat/Tápanyag szüks‚glet és tápanyag összetétel [Food Composition Tables/Composition and Requirements of Nutrients] G Biró, K Lindner Medicina, Budapest 11th ed (Hungarian) (1988) Iceland Icelandic food composition database - ÍSGEM [Matís] (2003) Ireland University College Cork, Department of Food and Nutritional Sciences: Irish Food Composition Database Italy Banca Dati di Composizione degli Alimenti INRAN (1993) Food Composition database for Epidemiological Studies in Italy (online searchable, Italian and English) Latvia Latvian Food Composition Database Lithuania Composition of Foods - S.Suciliene, A.Abaravicius, K.Kadziauskiene et al. 324 pp. (Lithuanian and English) (2002) Netherlands Dutch food composition data (2016) NEVO online 2016. For background information and downloads use the NEVO website Norway Food composition tables (2007) Norwegian Food Composition table (2018) National Institute of Nutrition and Seafood Research - NIFES Seafood Data All tables Poland Food composition tables (2005) Portugal Food composition tables (2019) Romania Nutritional Evaluation of Wheat Milling Variants [L'Analyse Nutritionnele des Variantes de Mouture du Blé] (1983) All tables Russia Marine Fishes: Chemical Composition and Processing Properties (1985) All tables Serbia *Serbian Food and Nutrition Database Slovakia Slovak online food composition database with free access for public (2002) All tables Spain Food composition tables (2010) CESNID - Tablas de Composición de Alimentos de CESNID Mineral Content in Milk and Dairy Products Olga Moreiras - Tablas de Composición de Alimentos SEH-LELHA - Tablas de Nutrición Universidad de Granada - Tabla de Composición de Alimentos Sweden Food composition tables (version 2020) Switzerland Schweizer Nährwertdatenbank (Swiss Food Composition Database) Swiss Federal Office of Public Health - V 5.2 Available in German (www.naehrwertdaten.ch), Italian (www.valorinutritivi.ch) and French (www.valeursnutritives.ch) (2015) Turkey Turkish Food Composition Database (beta version) United Kingdom Finglas P., Roe M., Pinchen H., Berry R., Church S., Dodhia S., Powell N., Farron-Wilson M., McCardle J. & Swan G. (2015) McCance and Widdowson’s The Composition of Foods Integrated Dataset 2015. London: Public Health England. Finglas P.M., Roe M.A., Pinchen H.M., Berry R., Church S.M., Dodhia S.K., Farron-Wilson M. & Swan G. (2014) McCance and Widdowson’s The Composition of Foods, Seventh summary edition. Cambridge: Royal Society of Chemistry. Food composition tables (2002) The global food and agriculture organisation (FAO) details links to several international food composition databases. You can access the FAO links here Download nutrition composition calculator by clicking here.

Estimating Food Nutrition Composition with Excel

Ingredient solutions used in similar applications