Spreadsheet Supported Fields
When uploading your spreadsheet you might get a notification that there are "Unrecognised Fields" or "Fields Not Found". This will most likely be due to the headers in your spreadsheet not matching the specific field in Allergen Intelligence.
Below is a list of the fields in Allergen Intelligence which can be uploaded via spreadsheet. Please use one of the corresponding supported "known names" as your column/header title in your spreadsheet.
Example: "Name" corresponds to the Ingredient Name field, but using "Product Name" or "Ecommerce Product Name" will also match to that field.
| Field Name | Known Name(s) |
| Item Name | Name |
| Product | |
| Product Name | |
| ProductName | |
| Ecommerce Product Name | |
| Sub Name | SubName |
| Sub Name | |
| Description | Description |
| EAN | EAN |
| Barcode | |
| Country Of Origin | CountryOfOrigin |
| Country Of Origin | |
| Use By Days | UseByDays |
| UseBy | |
| Purchase Weight (g) | PurchaseWeightGrams |
| PurchaseWeight | |
| Weight | |
| PortionSizeGrams | |
| Code | Code |
| Product Code | |
| Purchase Price (ex vat) | PurchaseCost |
| Cost | |
| Price | |
| PortionPrice | |
| VAT% | VAT |
| vat | |
| Ingredients | Ingredients |
| Kcal | Energy Per 100g (kcal) |
| Energy Per 100g | |
| kcal | |
| Kj | Energy Per 100g (kJ) |
| Energy Per 100g | |
| kj | |
| Fat | Fat per 100g (g) |
| Fat per 100g | |
| Fat | |
| SaturatedFat | Fat of which Saturates |
| Fat of which Saturates per 100g (g) | |
| Fat of which Saturates per 100g | |
| Saturates | |
| SaturatedFat | |
| Carbohydrates | Carbohydrate Per 100g (g) |
| Carbohydrates Per 100g (g) | |
| Carbohydrate Per 100g | |
| Carbohydrates Per 100g | |
| Carbohydrate | |
| Carbohydrates | |
| Carbs | |
| SugarCarbs | Carbohydrate of which Sugars |
| Carbohydrate of which Sugars per 100g (g) | |
| Carbohydrate of which Sugars per 100g | |
| Carbohydrates of which Sugars | |
| Carbohydrates of which Sugars per 100g (g) | |
| Carbohydrates of which Sugars per 100g | |
| Sugars | |
| SugarCarbs | |
| Protein | Protein per 100g (g) |
| Protein per 100g | |
| Protein | |
| Salt | Salt per 100g (g) |
| Salt per 100g | |
| Salt | |
| Sodium per 100g (g) | |
| Sodium per 100g | |
| Sodium | |
| Celery | Celery |
| Crustaceans | Crustaceans |
| Crustacea | |
| Crustacean | |
| Eggs | Eggs |
| Egg | |
| Fish | Fish |
| Lupin | Lupin |
| Molluscs | Molluscs |
| Mustard | Mustard |
| Peanuts | Peanuts |
| Peanut | |
| Soya | Soya |
| Soy | |
| Sulphites | Sulphites |
| Sulphates | |
| Sulphur Dioxide | |
| Nuts | Nuts |
| Nut | |
| Cereals Containing Gluten | Gluten |
| Cereals Containing Gluten | |
| Sesame Seeds | Sesame |
| Sesame Seeds | |
| Milk | Milk |
| Almonds | Almonds |
| Brazil | Brazil |
| Cashews | Cashews |
| Hazelnuts | Hazelnuts |
| Macadamia | Macadamia |
| Pecan | Pecan |
| Pecan Nuts | |
| Pistachio | Pistachio |
| Walnuts | Walnuts |
| Wheat | Wheat |
| Rye | Rye |
| Barley | Barley |
| Oats | Oats |
| Fibre | AOACFibre |
| Fibre | |
| Fibre per 100g | |
| Fibre per 100g (g) |
A blank spreadsheet template can be downloaded on the "Import" screen of Allergen Intelligence, or you can download one here: