Interpreting CSV Downloads
Erudus makes it easy for you to take data offline by being able to download spreadsheets in CSV format for the product data that you need. Whether you're a manufacturer reviewing the products that you make, a wholesaler reviewing products you stock in your range or a caterer checking the legally required allergen and nutritional information for the products that you use in your business, you can use Erudus to generate all the data you need in a single file.
When reviewing an Erudus CSV download, each column heading is a specific attribute on a product specification and each row of data is related to an individual product. It is important to note that the column headings in CSV downloads don't use the attribute names you find in the Erudus portal. Instead, they use our database attribute labels which don't always read exactly the same as what you would expect to find on an Erudus specification so below you will find a comprehensive list of all of the database labels in alphabetical order with their corresponding attributes should you need to look them up.
Top Tip: you can use the "find text" feature of your web browser (cmd/ctrl + F) to search for the attribute you are looking for without having to scroll.
| CSV Attribute Label | Erudus Specification Attribute |
| acc_bap_cert | Does this product have the Best Aquaculture Practices (BAP) certification? (Yes or No) |
| acc_british_lion | Does this product have the British Lion Mark certification? (Yes or No) |
| acc_eblex | Does this product have the Quality Standard Mark (Beef/Lamb) certification? (Yes or No) |
| acc_fa_welsh_livestock | Does this product have the Farm Assured Welsh Livestock certification? (Yes or No) |
| acc_food_for_life | Does this product have the SOIL Association's Food for Life Supplier Scheme certification? (Yes or No) |
| acc_freedom_food | Does this product have the RSPCA Assured certification? (Yes or No) |
| acc_fssc_22000 | Does this product have the FSSC 22000 food safety management certification? (Yes or No) |
| acc_ifs_food_standard | Does this product have an International Featured Standards (IFS) certification? (Yes or No) |
| acc_iso_14001 | Does this product have an ISO 14001 (Environmental System) certification? (Yes or No) |
| acc_leaf | Does this product have a LEAF Marque (Linking Environment and Farming) certification? (Yes or No) |
| acc_ni_beef_lamb_fqas | Does this product have a Northern Ireland Beef & Lamb Farm Quality Assurance Scheme certification? (Yes or No) |
| acc_quality_meat_scotland | Does this product have a Quality Meat Scotland certification? (Yes or No) |
| acc_rainforest | Does this product have a Rainforest Alliance certification? (Yes or No) |
| acc_rspo |
Does this product have a Roundtable of Sustainable Palm Oil (RSPO) certification? (Yes or No) |
| acc_salsa |
Does this product have a Safe & Local Supplier Approval (SALSA) certification? (Yes or No) |
| acc_school_approved |
Does this product have a Safe & Local Supplier Approval (SALSA) certification? (Yes or No) |
| alcohol_strength_per_vol | What is the alcoholic strength by volume of this product as a % (if applicable) |
| allergen_statement | Additional allergen statement beyond the allergen declarations for the product (if applicable) |
| artifical_flavour_enhancers |
Does this product contain artificial flavour enhancers? (Yes, No or Not Specified) |
| artifical_flavourings |
Does this product contain artificial flavourings? (Yes, No or Not Specified) |
| artifical_preservatives |
Does this product contain artificial preservatives? (Yes, No or Not Specified) |
| artifical_sweeteners | Does this product contain artificial sweeteners? (Yes, No or Not Specified) |
| artificial_antioxidants |
Does this product contain artificial antioxidants? (Yes, No or Not Specified) |
| artificial_colours | Does this product contain artificial colours? (Yes, No or Not Specified) |
| brc_certified | Does this product have a BRCGS certification? (Yes or No) |
| cal_100_kcal | The energy content of this product per 100g/ml (kcal) |
| cal_100_kj |
The energy content of this product per 100g/ml (kj) |
| calcium_100g | The amount of calcium per 100g/ml of this product (mg) |
| carb_100 | The amount of carbohydrates per 100g/ml of this product (g) |
| case_label_name |
The product name (including pack size) |
| category |
The storage category for this product (ambient, chilled, frozen or non food) |
| chol_100 |
The amount of cholesterol per 100g/ml of this product (g) |
| coeliacs_suitable | Is this product suitable for coeliacs? (Yes or No) |
| commodity_code |
What is the commodity code for this product? (if applicable) |
| component_name |
For multipack products, this attribute will state the name of the multipack component the data in the row is related to |
| consumer_units_per_traded | The total number of inner units in an outer case of this product |
| contains_alomond_nuts | Does this product contain almonds? (Yes, No or May Contain) |
| contains_barley |
Does this product contain barley? (Yes, No or May Contain) |
| contains_brazil_nuts | Does this product contain brazil nuts? (Yes, No or May Contain) |
| contains_cashew_nuts | Does this product contain cashew nuts? (Yes, No or May Contain) |
| contains_celery_celeriac | Does this product contain celery? (Yes, No or May Contain) |
| contains_cereal |
Does this product contain any cereals containing gluten? (Yes, No or May Contain) |
| contains_crustacea | Does this product contain crustaceans? (Yes, No or May Contain) |
| contains_eggs |
Does this product contain eggs? (Yes, No or May Contain) |
| contains_fish |
Does this product contain fish? (Yes, No or May Contain) |
| contains_gm_protein |
Does this product contain genetically modified protein/DNA? (Yes or No) |
| contains_hazelnut_nuts |
Does this product contain hazelnuts? (Yes, No or May Contain) |
| contains_hydro_veg |
Does this product contain hydrogenated vegetable oil/fat? (Yes, No or Not Specified) |
| contains_kamut |
Does this product contain kamut? (Yes, No or May Contain) |
| contains_lupin |
Does this product contain lupin? (Yes, No or May Contain) |
| contains_macadamia_nuts |
Does this product contain macadamia nuts? (Yes, No or May Contain) |
| contains_milk |
Does this product contain milk? (Yes, No or May Contain) |
| contains_molluscs |
Does this product contain molluscs? (Yes, No or May Contain) |
| contains_mustard | Does this product contain mustard? (Yes, No or May Contain) |
| contains_oats |
Does this product contain oats? (Yes, No or May Contain) |
| contains_palm_oil |
Does this product contain palm oil? (Yes, No or Not Specified) |
| contains_peanuts | Does this product contain peanuts? (Yes, No or May Contain) |
| contains_pecan_nuts |
Does this product contain pean nuts? (Yes, No or May Contain) |
| contains_pistachio_nuts |
Does this product contain pistachio nuts? (Yes, No or May Contain) |
| contains_queensland_nuts |
Does this product contain queensland nuts? (Yes, No or May Contain) |
| contains_rye |
Does this product contain rye? (Yes, No or May Contain) |
| contains_sesame_seeds |
Does this product contain sesame? (Yes, No or May Contain) |
| contains_soybeans |
Does the product contain soya? (Yes, No or May Contain) |
| contains_spelt |
Does the product contain spelt? (Yes, No or May Contain) |
| contains_sulphur_dioxide |
Does the product contain sulphur dioxide? (>10mg per kg/l, <10mg per kg/l, No, May Contain) |
| contains_tree_nuts |
Does this product contain tree nuts? (Yes, No or May Contain) |
| contains_walnut_nuts |
Does this product contain walnuts? (Yes, No or May Contain) |
| contains_wheat |
Does this product contain wheat? (Yes, No or May Contain) |
| count_per_pack | How many individual items are contained in a single inner pack of this product? |
| country_of_origin |
What is this product's country of origin? |
| country_of_origin_details |
Is there any additional information regarding this product's country of origin? |
| created_at |
What is the date and time that this product specification was first published to Erudus? |
| delivery_lead_time | The number of days lead time for a delivery of this product (if applicable) |
| directions_for_use |
The directions for preparation/consumption of this product as it would typically appear on the packaging of the product |
| eec_number |
What are the identification/health marks related to this product? (if applicable) |
| erudus_id |
What is the Erudus ID of this product? (Every product in the Erudus data pool has a has a unique Erudus ID) |
| fair_trade |
Does this product have a Fairtrade certification? (Yes or No) |
| fat_100 |
The amount of fat per 100g/ml of this product (g) |
| fat_percentage_dry |
The fat percentage in dry matter per 100g of this product |
| fibre_100 |
The amount of fibre per 100g/ml of this product (g) |
| folate_100g |
The amount of folate/folic acid per 100g/ml of this product (µg) |
| food_drink |
Is this a food, drink or non-food product? |
| generic_field |
What is the generic product type for this product? |
| gluten_claim |
Is the gluten content of this product <20ppm? (Yes, No or Not Specified) |
| guaranteed_shelf_life | What is the number of days guaranteed minimum shelf life of this product upon delivery? (if applicable) |
| halal_approved | Is this product approved for a halal diet? (Yes or No) |
| hfss_product | Is this product a product high in fat salt and sugar according to the Department of Health's nutrient profiling model? (Yes, No or Not Specified) |
| ingredients |
The ingredients declaration for this product |
| inner_pack_depth | The height of a single inner unit of this product (mm) |
| inner_pack_length | The length of a single inner unit of this product (mm) |
| inner_pack_width |
The width of a single inner unit of this product (mm) |
| inner_packaging_alu_weight | The total weight of aluminium used in the packaging of a single inner unit of this product (g) |
| inner_packaging_glass_weight | The total weight of glass used in the packaging of a single inner unit of this product (g) |
| inner_packaging_other_weight |
The total weight of packaging of a single inner unit of this product that is not paper/board, glass, aluminium, plastic or steel (g) |
| inner_packaging_paper_weight | The total weight of paper/board used in the packaging of a single inner unit of this product (g) |
| inner_packaging_plastic_weight | The total weight of plastic used in the packaging of a single inner unit of this product (g) |
| inner_recycled_plastic_percentage | What percentage of the plastic used in the packaging of a single inner unit of this product is recycled? |
| inner_packaging_steel_weight |
The total weight of steel used in the packaging of a single inner unit of this product (g) |
| inner_packaging_type |
What type of packaging is used for the inner product? |
| inner_product_weight | What is the weight/volume of a single inner product? |
| internal_gtin | What is the GTIN/barcode number for the inner product? |
| intrastat_taric | What is the Intra Stat/Taric code for this product? (if applicable) |
| iron_100g | The amount of iron per 100g/ml of this product (mg) |
| kosher_approved |
Is this product approved for a kosher diet? (Yes or No) |
| lactose_intolerance_suitable |
Is this product suitable for people with lactose intolerance? (Yes or No) |
| local_product_code |
What local product code/SKU (if any) do you have linked to this product specification? Only visible to wholesalers |
| marine_stewardship |
Does this product have the Marine Stewardship Council (MSC) certification? (Yes or No) |
| max_lifespan | What is the shelf life of this product from the time of production (Days) |
| micro_trend_analysis |
Does this product undergo microbiological testing? (Yes or No) |
| min_order_qty | If applicable, what is the minimum order quantity of this product (cases) |
| mono_fat_100 | The amount of monosaturated fats per 100g/ml of this product (g) |
| net_drained_weight |
If applicable, what is the net drained weight of a single inner unit of this product? (kg) |
| non_milk_extrinsic_sugars_100g | The amount of non milk extrinsic sugars per 100g/ml of this product (g) |
| organic |
Does this product have an Organic certification? (Yes or No) |
| other_accreditation |
Are there any other accreditations related to this product that aren't listed on the specification? |
| outer_case_gross_weight |
What is the weight of a full outer case of this product including all outer case packaging? (kg) |
| outer_case_height |
What is the height of an outer case of this product? (mm) |
| outer_case_length | What is the length of an outer case of this product? (mm) |
| outer_case_net_weight | What is the weight of a full outer case of this product excluding all outer case packaging? (kg) |
| outer_case_width |
What is the width of an outer case of this product? (mm) |
| outer_packaging_alu_weight | The total weight of aluminium used in the packaging of the outer case of this product (g) |
| outer_packaging_glass_weight |
The total weight of glass used in the packaging of the outer case of this product (g) |
| outer_packaging_other_weight |
The total weight of packaging of an outer case of this product that is not paper/board, glass, aluminium, plastic or steel (g) |
| outer_packaging_paper_weight |
The total weight of paper/board used in the packaging of the outer case of this product (g) |
| outer_packaging_plastic_weight | The total weight of plastic used in the packaging of the outer case of this product (g) |
| outer_recycled_plastic_percentage | What percentage of the plastic used in the packaging of a single inner unit of this product is recycled? |
| outer_packaging_steel_weight |
The total weight of steel used in the packaging of the outer case of this product (g) |
| outer_packaging_type |
What type of packaging is used for the outer case of this product? |
| pallet_returnable | Is the pallet used for delivering this product returnable? (Yes, No or Not Specified) |
| pieces_slices_100g | How many pieces or slices of this product typically makes up 100g? |
| pmw_paperboard | The total weight of paper/board used in any additional transport packaging for a full pallet of this product (g) |
| pmw_plastic |
The total weight of plastic used in any additional transport packaging for a full pallet of this product (g) |
| pmw_wood |
The total weight of wood used in any additional transport packaging for a full pallet of this product, including the pallet itself (g) |
| poly_fat_100 |
The amount of polyunsaturated fat per 100g/ml of this product (g) |
| polyols_carb_100 |
The amount of polyols per 100g/ml of this product (g) |
| product_description |
The manufacturers description of this product |
| product_name | The short name of this product. A short name is the name of the product without any branding or pack size information |
| protein_100 | The amount of protein per 100g/ml of this product (g) |
| red_tractor | Does this product have a Red Tractor certification? (Yes or No) |
| salt_100 |
The amount of sodium per 100g/ml of this product (g) |
| sat_fat_100 |
The amount of saturated fat per 100g/ml of this product (g) |
| serving | The average serving size of this product (g/ml) |
| shelf_life_testing | Does this product undergo shelf life testing? (Yes or No) |
| sodium_100 | The amount of sodium per 100g/ml of this product (g) |
| starch_carb_100 |
The amount of starch per 100g/ml of this product (g) |
| storage_instructions | Storage instructions for this product |
| sugar_carb_100 |
The amount of sugar per 100g/ml of this product (g) |
| sulphur_dioxide_sulphites_concentration |
The concentration of sulphur dioxide/sulphites present per kg/ltr of this product (mg) |
| supplier_comments | Any miscellaneous information about this product that can't be communicated using the attributes on the rest of the Erudus specification |
| supplier_id | The Erudus database reference number for the manufacturer of this product |
| supplier_name | The name of the manufacturer of this product |
| suppliers_component_code | For multipack products, this attribute will state the manufacturer's code of the multipack component the data in the row is related to |
| suppliers_product_code | The manufacturer's product code for this product |
| trade_item_splittable | Is this trade item splittable? (Yes, No or Not Specified) |
| traded_items_per_unit_load | The total number of cases of this product on a full pallet |
| traded_unit_gtin |
What is the GTIN/barcode number for the outer case? |
| trans_fats_100 | The amount of trans fats per 100g/ml of this product (g) |
| transport_recycled_plastic_percentage | What percentage of the plastic used in the transport packaging of a full pallet of this product is recycled? |
| unit_load_gross_weight |
The weight of a full pallet of this product including the pallet and all packaging (kg) |
| unit_load_height | The height of a full pallet of this product including the pallet (m) |
| unit_load_layer_items | The number of cases of product per pallet layer |
| unit_load_layers | The number of layers of cases that make up a full pallet of this product |
| updated_by_supplier_at | The date and time the manufacturer last updated this specification |
| variable_weight_consumer_item | Is this product a variable weight consumer item? (Yes or No) |
| vegan_suitable | Is this product suitable for a vegan diet? (Yes or No) |
| vegetarian_suitable | Is this product suitable for a vegetarian diet? (Yes or No) |
| vitamin_a_100g | The amount of vitamin A per 100g/ml of this product (µg) |
| vitamin_c_100g |
The amount of vitamin A per 100g/ml of this product (mg) |
| weightvol_on_inner |
What is the weight/volume of a single inner unit of this product? This attribute will be removed in a future update and replaced with "inner_product_weight" |
| wholesaler | If the brand owner is not the manufacturer of this product the brand owner will be declared here |
| zinc_100g | The amount of zinc per 100g/ml of this product (mg) |
| |