Data export gives you the raw diary as a CSV file: every entry over the dates you pick, with every nutrient as a column. It is for people who build their own reports or analysis in Excel, Google Sheets or their own software. For a report to read or share, use the nutrition report or the meal report instead.
Data export is available on Professional and Team plans.
Download the file
- Open the diary you want to export — on a Professional plan, select the person from the People page.
- Select Report in the diary header, then the Data export tab.
- Pick a date range with the two date pickers. It can be up to 1 year.
- Under Include, tick what goes in the file: Food (foods and recipes), Exercise, Measurements and Notes. Only Food is ticked when the tab opens.
- Check the line under the card, for example 412 entries over 99 days · 152 columns, then select Export CSV.
The file is named after the profile, what you ticked and the dates — for example sarah-jones-data-export-food-20260601-20260907.csv. If nothing is ticked, or the range has no entries of the ticked types, the button stays greyed out.
What is in the file
Each row is one diary entry. The columns are the same whatever you ticked, apart from any extra nutrients described below:
| Column | What it holds |
|---|---|
| Date | The day it was logged, as 2026-06-01, in the profile's time zone. |
| Time | The time it was logged, as 07:30. |
| Group | The diary group it sits in, such as Breakfast or Morning session. Empty for an entry outside a group. |
| Name | The food, exercise or measurement. Empty for a note. |
| Brand | The brand, where the food has one. |
| Type | food, recipe, exercise, measurement or note. |
| Amount and Unit | How much was logged: 1 and cup (250 ml) for a food, 30 and min · moderate (5 km/h) for exercise, 72.4 and kg for a weight. |
| Weight (g) and Volume (mL) | What a food's amount works out to: grams for most foods, millilitres for a drink logged by volume. Both are empty for a counted serve such as a capsule. |
| Nutrients | One column for every nutrient and food-group serve in the profile's food database, with the unit in the heading, such as Added sugars (g). Energy is in the profile's energy unit, kJ or kcal. Filled for foods and recipes only. |
| Energy burned | The energy an exercise entry burned, in the same unit. |
| Note | The text of a note. |
A few things work differently from the reports:
- There are no total rows. Every row is an entry, so the file sorts, filters and pivots cleanly. Add totals in your spreadsheet.
- A recipe is one row. Its nutrients are the recipe's, for the amount logged; the ingredients are not listed separately.
- A food with no value for a nutrient in the database shows
0. - Extra nutrients that a food carries beyond the database's list — from a supplement or a product label — get a column only when a food in the export records them, and the cell is empty unless the food has a value.
- Exercise energy is never in the Energy column. It goes in Energy burned, so totalling Energy adds up only what was eaten.
Opening the file
Double-click it and it opens in Excel with the columns in place. Google Sheets and Numbers open it too: use File → Import in Sheets.
A food name that starts with =, +, - or @ has a ' added in front of it, so a spreadsheet shows it as text rather than running it as a formula.