Import Foods and Ingredients Using a CSV File
You can easily import hundreds of foods and ingredients into Foodzilla using a CSV file. Follow these simple steps to get started. 👏
Step 1: Download the CSV Template
First, download our CSV template file. This template will guide you on how to format your food data.
Step 2: Prepare the CSV File
Enter your food data into the template.
Ensure that all nutrition information is based on a 100-gram measurement unless you provide a BaseMeasurement value. See the table below for more information.
Important Notes:
- Numeric Values: Values can be zero, a decimal, or a whole number. If the value of a nutrient is unknown, leave it blank.
- Valid Values 👍:
- 0
- 23.5
- 30
- 40.0
- 66.485
- Invalid Values 👎:
- 0g
- five
- 32 grams
Field Descriptions:
Below is a list of each field in the CSV template, its description, and an example. The "Name" field is required; all others are optional.
Note: Do not change the field names or add new ones.
| Field Name | Description | Example |
|---|---|---|
| Name | The name of the food | Acai Berries |
| Energy_KCAL | Calories per 100 grams or BaseMeasurement | 450 |
| Water | Grams of water | 6 |
| TotalFat | Total fat in grams | 32.5 |
| TotalProtein | Total protein in grams | 35 |
| TotalFiber | Total fiber in grams | 5 |
| TotalCarbs | Total carbohydrates in grams | 35 |
| TotalStarch | Total starch in grams |
|
| TotalSaturatedFat | Total saturated fat in grams |
|
| TotalTransFat | Total trans fat in grams |
|
| TotalMonoFat | Total monounsaturated fat in grams |
|
| TotalPolyFat | Total polyunsaturated fat in grams |
|
| TotalCholesterol | Total cholesterol in mg |
|
| TotalSugar | Total natural sugar in grams |
|
| TotalAddedSugar | Total added sugar in grams |
|
| TotalSodium | Total sodium in mg |
|
| TotalCalcium | Total calcium in mg |
|
| TotalMagnesium | Total magnesium in mg |
|
| TotalIron | Total iron in mg |
|
| TotalPotassium | Total potassium in mg |
|
| TotalIodine | Total iodine in µg |
|
| TotalSelenium | Total selenium in µg |
|
| TotalZinc | Total zinc in mg |
|
| TotalPhosphorus | Total phosphorus in mg |
|
| TotalVitaminA | Total vitamin A in µg |
|
| TotalVitaminC | Total vitamin C in mg |
|
| TotalVitaminD | Total vitamin D in µg |
|
| TotalVitaminB6 | Total vitamin B6 in mg |
|
| TotalVitaminB12 | Total vitamin B12 in µg |
|
| TotalVitaminE | Total vitamin E in mg |
|
| TotalVitaminK | Total vitamin K in µg |
|
| TotalThiamin | Total thiamin (B1) in mg |
|
| TotalRiboflavin | Total riboflavin (B2) in mg |
|
| TotalNiacin | Total niacin (B3) in mg |
|
| TotalFolate | Total folate in µg |
|
| TotalFolateFood | Total folate (food) in µg |
|
| BaseMeasurement | The base measurement where all the nutrient values are based on. If this value is not provided, the base measurement will be assumed to be 100 grams. |
The value of this field must follow this pattern:
For example:
|
| CustomMeasurementOne | An additional measurement to be displayed as an option in the measurement list for this food. | Must follow the same pattern as the BaseMeasurement label_amount_unit |
| CustomMeasurementTwo | An additional measurement to be displayed as an option in the measurement list for this food. | Must follow the same pattern as the BaseMeasurement label_amount_unit |
| CustomMeasurementThree | An additional measurement to be displayed as an option in the measurement list for this food. | Must follow the same pattern as the BaseMeasurement label_amount_unit |
| CustomMeasurementFour | An additional measurement to be displayed as an option in the measurement list for this food. | Must follow the same pattern as the BaseMeasurement label_amount_unit |
| CustomMeasurementFive | An additional measurement to be displayed as an option in the measurement list for this food. | Must follow the same pattern as the BaseMeasurement label_amount_unit |
| BrandOwner | The name of the brand owner |
|
| Ingredients | The list of ingredients of this food product (if applicable) |
|
| AllergenWarnings | The list of allergen warnings or advice as presented on the food product (if applicable) |
|
Step 3: Import Foods
Once your CSV file is ready, follow these steps to import it:
- Go to the Food Databases tab.
- Click on the Import Foods button.
- Upload your prepared CSV file and click Import Foods.
- A popup will notify you of the number of foods imported. You can view your imported foods under the Food Data tab, and your food database will be named after your business.
You can import hundreds of foods in seconds using this method. If you need any assistance, please contact our support team. 🙌