Frequently Asked Questions

General questions

What is The New Zealand Food Composition Database?

The New Zealand Food Composition Database is a reference database with the primary role to provide reliable nutrient values for foods commonly consumed in New Zealand. Plant & Food Research and the Ministry of Health jointly own the New Zealand Food Composition Database, the most comprehensive collection of high-quality nutrient data for New Zealand foods. The Database is managed and maintained by dedicated Plant & Food Research staff.

The New Zealand Food Composition Database contains nutrient information for over 2,700 foods. The majority of foods have been analysed in New Zealand with a smaller percentage of data coming from other sources such as recipe calculations or by borrowing from other countries.

Who manages and runs the New Zealand Food Composition Database?

Subathira Sivakumaran, Zane Gilmore, Siva Sivakumaran and Kris Tham are the key people responsible for managing and maintaining of the database.

How is the New Zealand Food Composition Database data published?

Data from the New Zealand Food Composition Database is available through three different formats:

  1. Our online Search , which allows users to search the database of over 2,700 foods and produce a tailored report
  2.  New Zealand FOODfiles™, which includes data for up to 363 components for over 2,700 foods, downloadable as Microsoft Office Excel or tilde delimited ASCII text files
  3. The Concise New Zealand Food Composition Tables, which are printable tables for 38 components for over 1,100 foods in pdf or Microsoft Office Excel

All three formats contain the same core food and nutrient data.

Can I reproduce the nutrient data published in any of the New Zealand Food Composition Database formats?

Yes, you are free to copy and communicate data as long as you comply with the Terms of Use for the use of the New Zealand Food Composition Database and you correctly reference the database format as given below. The data must not be modified.

How do I reference the New Zealand Food Composition Database formats?

Suggested citations for New Zealand Food Composition Database formats
New Zealand New Zealand Food Composition Database Online Search
New Zealand Food Composition Database 2022. New Zealand Food Composition Database Online Search. The New Zealand Institute for Plant & Food Research Limited and Ministry of Health. https://www.foodcomposition.co.nz/search

New Zealand FOODfiles™ 2021 Version 01
New Zealand Food Composition Database 2022. New Zealand Food Composition Database: New Zealand FOODfiles™ 2021 Version 01. The New Zealand Institute for Plant & Food Research Limited and Ministry of Health. https://www.foodcomposition.co.nz/foodfiles

The Concise New Zealand Food Composition Tables, 14th Edition 2021
New Zealand Food Composition Database 2022. The Concise New Zealand Food Composition Tables, 14th Edition 2021. The New Zealand Institute for Plant & Food Research Limited and Ministry of Health. https://www.foodcomposition.co.nz/concise-tables

New Zealand FOODfiles™ 2021 Manual
New Zealand Food Composition Database 2022. New Zealand FOODfiles™ 2021 manual. The New Zealand Institute for Plant & Food Research Limited and Ministry of Health. https://www.foodcomposition.co.nz/foodfiles

About the data sets

What data are used for the New Zealand Food Composition Database?

All three New Zealand Food Composition Database formats use the same core data set – FOODfiles™ 2021 Version 01. The majority of the entries in the New Zealand Food Composition Database have been analysed in New Zealand with a smaller percentage of data coming from other sources, such as recipe calculations or by borrowing from other countries.

To generate the data, most foods are purchased through supermarkets and other retail channels, just as the consumer would purchase. The majority of the data were derived from analysis of a composite sample of varieties, regions, and/or seasons or, for processed products, similar products from different brands within a category. Samples are prepared for analysis, which is then conducted by accredited laboratories in New Zealand and Australia. Files are available that show details of the food sampling and source of the individual nutrient data. Details can be found in the New Zealand FOODfiles™ 2021 Manual [PDF 4.2 MB] and in selected files downloaded with New Zealand FOODfiles.

How is FOODfiles™ 2021 Version 01 different from FOODfiles™ 2018 Version 01?

FOODfiles™ 2021 incorporates the most recent analytical data (2017–21) or significant data updates for 380 Food Records. A total of 384 Food Records have been archived from the FOODfiles™ 2018 Version 01 and are not available in the FOODfiles™ 2021 Version 01. Most of these Food Records were replaced with new Food Records generated from the New Zealand Food Composition Database 2017–21 analytical programme. Errors identified in the FOODfiles™ 2018 Version 01 have been amended in the FOODfiles™ 2021 Version 01. Details of the updates appearing in FOODfiles™ 2021 can be found in the New Zealand FOODfiles™ 2021 Manual and in the supplementary files here.

What are the limitations of the data set?

Users need to be aware that the data do not represent absolute values due to natural variability and formulation changes by manufacturers. Data are provided are typically representative of foods available in New Zealand. The majority of the data were derived from analysis of a composite sample of varieties, regions, and/or seasons or for processed products similar product from different brands within a category. Details about the foods analysed (description and sampling details) can be found in the file ‘NAME.FT’ downloaded with New Zealand FOODfiles™.

What is the quality of the data?

The New Zealand Food Composition Database is unique in New Zealand with regards to data quality. Unlike some databases where information is obtained from labels only, the majority of values are based on New Zealand analysis (or recipe calculation based on New Zealand data). An enormous amount of effort goes into producing the data – everything from sampling and analytical plans to validation, all in accordance with international best practice.

Why don't the polyunsaturated, monounsaturated and saturated fatty acids add up to the total fat value?

The classes of fatty acids may not add up to the total fat value provided in the database because of differences in analytical methods. Lipid conversion factors for specific fats define the amount of fatty acid (in grams) per gram of fat. The lipid conversion factors used in the New Zealand Food Composition Database are available on request from Plant & Food Research ().

What are the differences of the various energy calculations used?

In FOODfiles™ 2016 Version 01, energy values are calculated according to standards issued by two authorities: FAO/INFOODS guidelines (FAO/INFOODS 2012) with and without inclusion of dietary fibre and Standard 1.2.8 (Food Standards Australia New Zealand 2013) with two means of including the carbohydrate contribution to energy. In addition the energy values can be expressed as either kilocalories (kcal) or kilojoules (kJ). The appropriate data for your use will depend on its purpose; for labelling purposes in Australia and New Zealand the FSANZ data should be used.

The calculations for various energy values are explained below.

Energy based on FAO/INFOODS

Energy based on FSANZ Standard 1.2.8

Further details can be found in the New Zealand FOODfiles™ 2021 Manual [PDF 4.2 MB].

How do I find out more about the analysis methods used for the data?

Further details about methodology and calculations can be found in the New Zealand FOODfiles™ 2021 Manual [PDF 4.2 MB].

How can I find out more about the source of each of the data points (e.g. analytical, calculated, borrowed, etc)?

Further details about the source of the data can be found in the file ‘Unabridged DATA.FT’ which is downloaded with New Zealand FOODfiles. The detailed descriptions of the codes are provided in the New Zealand FOODfiles™ 2021 Manual [PDF 4.2 MB].

What do the different sugar values mean?

Total sugars are determined analytically and the values in the database are the sum of the free individual monosaccharides (glucose and fructose) and disaccharides (lactose, maltose and sucrose). Added sugars are defined according to the United States Food and Drug Administration (US FDA) definition: “sugars that are either added during the processing of foods, or are packaged as such, and include sugars (free, mono- and disaccharides), sugars from syrups and honey, and sugars from concentrated fruit or vegetable juices that are in excess of what would be expected from the same volume of 100 percent fruit or vegetable juices of the same type. The definition excludes fruit or vegetable juice concentrated from 100 percent fruit juice that is sold to consumers (e.g. frozen 100 percent fruit juice concentrate) as well as some sugars found in fruit and vegetable juices, jellies, jams, preserves, and fruit spreads”. Free sugars are defined according to the World Health Organisation (WHO) definition: “free sugars include monosaccharides and disaccharides added to foods and beverages by the manufacturer, cook or consumer, and sugars naturally present in honey, syrups, fruit juices, and fruit juice concentrates”.

Why is it important to distinguish between total sugar and added or free sugar?

The reduction of added or free sugar intake (sugars added to food and drinks as a sweetener) is almost universally recommended to reduce the risk of obesity-related diseases and dental caries. The World Health Organisation recommends intakes of free sugars of less than 10% of energy intake. However, estimating and monitoring intakes at the population level is challenging because free sugars cannot be analytically distinguished from naturally occurring sugars. Total sugar measures do not distinguish if those sugars are naturally occurring or have been added during processing. University of Otago developed added and free sugar estimates for the New Zealand Food Composition Database by adapting a method developed for Australia (see New Zealand FOODfiles™ 2021 Manual [PDF 4.2 MB]). Having these data provides more direct estimates of the added and free sugar contents of New Zealand foods than previously available, and will enable monitoring of adherence to free sugar intake guidelines in future.

For vitamin A, what is the difference between retinol equivalents (RE) and retinol activity equivalents (RAE)?

There are various ways that vitamin A intake can be expressed, taking into account the conversion of carotenoids, such as beta-carotene, to retinol. Retinol equivalents (RE) in the database are calculated by multiplying beta-carotene equivalents by the conversion factor (1/6, i.e. 0.167) and adding retinol. Retinol activity equivalents (RAE) in the database are calculated by multiplying beta-carotene equivalents by the conversion factor (1/12, i.e. 0.083) and adding retinol. This latter value should be used for FSANZ labelling purposes.

Where can I find the added and free sugar data?

When using the SEARCH feature for a food the data is included under the basic and detailed reports (find these under ‘select component set to display’). You can also use the ‘Search for a nutrient’ feature and select these components as a nutrient. In the Concise Tables the added/free sugar data is not in the body of the report (because many foods don't have them) and so you can find it in Appendix III.

Why have so many data points changed in FOODfiles 2021 compared with those in earlier versions?

Over 22,000 food composition data points have been updated in the current version. The majority of these updates are minor data changes (<5% difference that the original value). These changes are due to the replacement of the old NZFCD software (Food Information Management System, FIMS) with FoodCASE (Food Composition And System Environment). Food Records from FOODfiles 2018 were migrated from FIMS to FoodCASE and adapted using the FoodCASE standardised rules (e.g. rounding rules, Yield Factor (YF) application in recipes, actions for missing component values for ingredients). Data values changed from 2018 to 2021 are listed in ‘Data added to or updated in the Food Records in the latest version of FOODfiles.xlsx’.

Why are there gaps in data provenance codes?

Derivations of all the component values in the NZFCD are now described with data provenance codes. In FOODfiles 2021 there are two sets of data that differ in their value derivation descriptions. At present the full set of new data provenance codes are used only for the 380 new and updated foods added since the 2018 release. Note that these Food Records do not have ‘Source Code’, since that is the old way of recording data derivation. The remaining foods migrated from FOODfiles 2018 are still using the old description ‘Source Code’ along with ‘Unit Code’ and ‘Matrix Unit Code’. The full list of data provenance descriptions can be found in FOODfiles 2021 downloadable files (‘Data provenance.xlsx’).

Have any new components been added to the FOODfiles 2021 dataset?

Sorbitol has been added to the unabridged DATA file for the first time. At present data are available only for a small number of foods. These were analysed because the proximate total was low, and sorbitol is not included in the standard carbohydrate analyses in the Core Component set. Note that other foods in the database may actually contain sorbitol but we do not currently have data for them.

There has also been a correction to one of the fatty acid component identifiers: F18D2CN9TN11 replaces F18D2CN9T11.

Why is the number of food components lower in FOODfiles 2021 than in FOODfiles 2018?

There are several reasons for the change in the number of food components:

Therefore, the standard version of FOODfiles now contains 85 food components (down from 86 in FOODfiles 2018) and the unabridged version contains 260 food components (down from 263 in FOODfiles 2018).

Using the online Search

Does the online Search provide the most recent data available?

The dataset that is searched and extracted from for the web access format is the most up-to-date published data – FOODfiles™ 2021, Version 01. Note we will be making continuous improvements to the search functionality. This iteration of the search tool has been developed with a focus on the food industry and is based on FSANZ standards for food labelling. Future releases will be tailored to meet the needs of other user groups.

How are the percentage daily intakes calculated?

At present percent daily intakes presented in the search results are calculated using the reference values used for food labelling purposes as given by FSANZ. These are based on an average adult diet of 8700 kJ. Your individual requirements may be different depending on your life stage and gender group. It is important to note that these daily intakes are different from the Nutrient Reference Values (NRVs) for Australia and New Zealand published by the National Health and Medical Research Council of Australia (NHMRC). Future versions of the search tool will provide these more personalised daily intakes.

Can I use the online Search to produce a Nutrient Information Panel (NIP)?

The first format that a search delivers is a nutrient information panel. By selecting a nutrient claims report, you can also add addition nutrients to your NIP. For the NIP reports we have ensured data are presented using the FSANZ calculations (e.g. for energy). Please make sure you are familiar with FSANZ labelling requirements. FSANZ also provides a useful Nutrition Information User Guide.

Why can’t I find the food I want?

There are many more foods on the market in New Zealand than available in the New Zealand Food Composition Database. Our priority is to analyse the most commonly consumed foods but there are so many new and/or imported foods that we can’t analyse everything. You can try looking at other international food composition databases as provided in the Useful Links. In particular, the USDA database is very comprehensive and includes a large database of branded products, although just a limited number of nutrients are provided for these.

Why isn't the search function working for me?

Here are some troubleshooting ideas:

How do I access datasets for multiple foods?

The online online Search will allow you to compare up to three foods. If you want more than this, you can download:

  1. New Zealand FOODfiles™ (data for up to 363 components for over 2,700 foods) Microsoft Office Excel or tilde delimited ASCII text files
  2. The Concise New Zealand Food Composition Tables (printable tables for 38 components for over 1,100 foods) in PDF or Microsoft Office Excel

What does a ■ in a cell mean?

A ■ does not necessarily mean that a food does not contain that nutrient (i.e. a blank cell is not the same as a zero). There is a core set of nutrients that are always analysed, calculated or in some cases presumed zero. If this is the case, a value will be recorded. Other nutrients may not be analysed for every food. If appropriate data cannot be sourced in other ways then the cell will remain blank.

What does a blank cell in the %DI column mean?

Not all nutrients have established recommended daily intakes. If no recommendation is published in the FSANZ regulations/and or there is no nutrient composition data then the cell will be blank.

Why can't I find the food component I want?

At present the online search provides composition data for around 200 food components. These include the set of core nutrients that are routinely analysed for all foods. Some additional data (e.g. less common minerals and selected contaminants) is not provided via the online search but is available in the Unabridged data set of FOODfiles™ which you can download here.

Use for commercial products

Why are some of the data in the New Zealand Food Composition Database different from the information on product labels?

There is natural variability in all foods. The New Zealand Food Composition Database provides representative data founded on a sampling methodology to best represent the food in distribution through typical retail channels. For fresh produce the composition may vary by many factors including variety, season and source location. Composite (manufactured) product Nutritional Information Panels may be derived from calculating the composition from recipe components, or might be specifically analysed for their nutrient composition. Differences between New Zealand Food Composition Database values and the NIP may occur where the NIP is for an individual product whereas the New Zealand Food Composition Database is often a composite of similar products.

Can I use the data provided for a Nutrient Information Panel (NIP) in New Zealand?

Yes, in some cases you can. In the FSANZ regulations it states that there are a number of methods commonly used to derive food composition data to develop a nutrition information panel. Amongst these authorised sources is “food composition tables or databases”. The New Zealand Food Composition Database provides data that complies with FSANZ requirements. It is your responsibility to make sure your product matches the description provided in our database if you plan to use this data for a label declaration. For the NIP reports we have ensured data are presented using the FSANZ calculations (e.g. for energy). Please make sure you are familiar with FSANZ labelling requirements. FSANZ also provides a useful Nutrition Information User Guide.

How do I add my food product to the New Zealand Food Composition Database?

Individual product data can be included in the New Zealand Food Composition Database and provided on this website (www.foodcomposition.co.nz).

If you are thinking of making a nutrient content or health claim for your product and promoting the product on this basis, then having your product’s data in an internationally-recognised independent database like the New Zealand Food Composition Database will help underpin your promotional activities and provide a point of difference for your product.

To include a product in the New Zealand Food Composition Database, a complete composition and nutrient profile is required to be independently generated. To meet the international standard for food composition databases, the product is analysed by accredited laboratories in New Zealand and Australia using recognised protocols. To meet these standards, our scientists source the product from its normal distribution chain then organise the submission of product samples for analyses, validate the results, and add the product’s composition and nutrient data to the New Zealand Food Composition Database.

If you would like to discuss the inclusion of your product in the New Zealand Food Composition Database and on this website along with the cost of doing this please contact us at: .

Which vitamin A value should I use on a NIP?

Vitamin A, total: expressed as retinol activity equivalents (VITA_RAE) value should be used for FSANZ labelling purposes.

Which energy value should I use on a NIP?

There are a number of ways by which energy is calculated. There are two different methods for calculating energy allowed under the FSANZ standard:

  1. Energy, total metabolisable, carbohydrate by difference (ENERC_FSANZ1): energy-producing food components taken into account are: protein; carbohydrates by difference; total fat; alcohol; dietary fibre and organic acids.
  2. Energy, total metabolisable, available carbohydrates (ENERC_FSANZ2): energy-producing food components taken into account are: protein; available carbohydrates; total fat; alcohol; dietary fibre and organic acids.

Other

If I have a question that has not been answered here, who should I contact?

Please read the New Zealand FOODfiles™ 2021 Manual (PDF 4.2 MB) or contact us at: .

How do I provide feedback or report an issue?

If you wish to provide us with feedback on our search tool or report an issue please complete our online form: Submit here.