Jump to content

Reusing Open Food Facts Data: Difference between revisions

CSV export details
No edit summary
(CSV export details)
Line 8: Line 8:
Then use the advanced search. The Open Food Facts advanced search feature allows to download selections of the data. See: https://world.openfoodfacts.org/cgi/search.pl
Then use the advanced search. The Open Food Facts advanced search feature allows to download selections of the data. See: https://world.openfoodfacts.org/cgi/search.pl


When you search is done, you will be able to download the selection in '''CSV or Excel format''', just give a try!
When your search is done, you will be able to download the selection in '''CSV or Excel format''', just give a try!


=== Looking for the whole database? ===
=== Looking for the whole database? ===
The whole database can be downloaded at https://world.openfoodfacts.org/data
The whole database can be downloaded at https://world.openfoodfacts.org/data


It's very big. Open Food Facts hosts more than 1,200,000 products (as of April 2020). So you will probably need skills to reuse the data.
It's very big. Open Food Facts hosts more than 1,400,000 products (as of July 2020). So you will probably need skills to reuse the data.


You'll be able to find there different kinds of data.
You'll be able to find here different kinds of data.


==== The MongoDB daily export ====
==== The MongoDB daily export ====
Line 26: Line 26:


==== The CSV daily export ====
==== The CSV daily export ====
It represents a subset of the database but it is generally fitted to the majority of usages. It's a 2.3GB file (as of April 2020), so it can't be opened by Libre Office or Excel with an 8GB machine.
It contains all the products, but with a subset of the database fields. [https://world.openfoodfacts.org/data/data-fields.txt This subset is very large] and include main characteristics (EAN, name, brand...), many tags (such as categories, origins, labels, packaging...), ingredients and nutrition facts. Thus, it is generally fitted to the majority of usages. It's a 2.3GB file (as of April 2020), so it can't be opened by Libre Office or Excel with an 8GB machine.


== How to reuse? ==
== How to reuse? ==