You can import hundreds of foods/ingredients into Foodzilla using a CSV file.
To get started, download our CSV template file and fill in your food data following the format below.
Prepare the CSV file
Please note that the nutrition information must be entered for a 100-gram measurement.
Number values can be zero, a decimal number, or a whole number. If the value of a nutrient is unknown, leave it empty.
The following values are valid 🆗 :
-
0
-
23.5
-
30
-
40.0
-
66.485
The following values are invalid 🔴 :
-
0g
-
five
-
32 grams
The following table explains what each field does and the expected format in order to import foods correctly. Name is the only required field.
Field Name
Description
Example
Name
The name of the food
Acai Berries
Energy_KCAL
The total number of calories for a 100-gram measurement.
450
Water
The total number of grams of water
6
TotalFat
The total fat (measured in grams).
32.5
TotalProtein
The total protein (measured in grams).
35
TotalFiber
The total fiber (measured in grams).
5
TotalCarbs
The total carbohydrates (measured in grams).
35
TotalStarch
The total starch (measured in grams).
TotalFiber
The total fiber (measured in grams).
TotalSaturatedFat
The total saturated fatty acids (measured in grams).
TotalTransFat
The total trans fat (measured in grams).
TotalMonoFat
The total monounsaturated fat (measured in grams).
TotalPolyFat
The total Polyunsaturated (measured in grams).
TotalCholesterol
The total Cholesterol (measured in mg).
TotalSugar
The total natural sugar (measured in grams)
TotalAddedSugar
The total added sugar (measured in grams)
TotalSodium
The total Sodium (measured in mg).
TotalCalcium
The total Calcium (measured in mg).
TotalMagnesium
The total Magnesium (measured in mg).
TotalIron
The total Iron (measured in mg).
TotalPotassium
The total Potassium (measured in mg).
TotalIodine
The total Iodine (measured in µg).
TotalSelenium
The total Selenium (measured in µg).
TotalZinc
The total Zinc (measured in mg).
TotalPhosphorus
The total Phosphorus (measured in mg).
TotalVitaminA
The total Vitamin A (measured in µg).
TotalVitaminC
The total Vitamin A (measured in mg).
TotalVitaminD
The total Vitamin A (measured in µg).
TotalVitaminB6
The total Vitamin B6 (measured in mg).
TotalVitaminD
The total Vitamin D (measured in µg).
TotalVitaminB12
The total Vitamin B12 (measured in µg).
TotalVitaminE
The total Vitamin E (measured in mg).
TotalVitaminK
The total Vitamin K (measured in µg).
TotalThiamin
The total Thiamin (B1)(measured in mg).
TotalRiboflavin
The total Riboflavin (B2)(measured in mg).
TotalNiacin
The total Niacin (B3)(measured in mg).
TotalFolate
The total Folate (measured in µg).
TotalFolateFood
The total Folate (food)(measured in µg).
Note: do not change the field names or add new ones.
Import Foods
Once the data is ready to be imported, go to the Food Data tab and click on the Import Foods button. After that, upload the CSV file you prepared earlier and click "Import Foods".
Once the foods are imported, you will be notified with a popup to tell you how many foods have been imported and that you can view them from Food Data and select your database (your food database name matches your business name).
That's it, you can import hundreds of foods this way in a matter of seconds. Contact our support team if you need help doing this.