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)