Analyze Food Tracker Data in Excel

To keep track of what I’m eating, I use the LoseIt food tracker app on my iPhone and iPad. It’s easy to use, and creates nice summaries for each day and week. To see how things are going, I’d like to analyze that food tracker data in Excel, instead of being limited to the preset options in LoseIt.

Analyze Food Tracker Data in Excel

Here’s an overview of how I got my LoseIt data into Excel. For more details, go to the Food Tracker Workbook page on my website.

You can get my master workbook there too, and links to a couple of other workbooks, where you can enter your own data, if you don’t use LoseIt.

The First Step

I couldn’t see any way to export the weekly stats from LoseIt on the iPad, but a Google search showed that it was possible from the online version, at LoseIt.com.

NOTE: I use the free version of LoseIt, so things might look different in the premium version.

Enter or Edit Data

The Home page on the website showed the current day’s data, and you can add your food information there, for today’s meals. It’s actually easier to enter things on that screen, than it is on the iPhone. It doesn’t fit in your pocket as easily though!

There is a Goals tab too, where you can set a target weight and other details, and there are several other tabs that you can explore.

 

Get the Insights

If you want to export the data, click the Insights button at the top of the screen. It looks discouraging at first, because the Food Insights option is selected by default, and the report is covered with an “Upgrade Now!” message.

Ignore that (unless you really want to upgrade), and click the Weekly Summary option in the list of Summaries.

 

LoseIt Weekly Summary

 

The Weekly Summary page shows charts for calories, weight and steps. There is also a list with a few nutrients – fat, cholesterol, sodium, carbs, and protein, and your totals for those.

I won’t bore you with a screen shot of my Weekly Summary page. Just imagine that the calorie count is exactly on goal, and I walked 10K steps every day.

Choose a Week

At the top of the Weekly Summary , use the arrows to select a week. I wish the calendar started on Sunday, but I can’t find any way to change that.

loseitstats04

Export the Data

Next, to export the Weekly Summary data for the selected week, click the “Export to Spreadsheet” button at the top right of the page.

Export LoseIt food tracker data to Excel

Every time that I download weekly data, I change the number in the file name, so it shows the year, month and day. That way, I’ll be able to find the export files easily, when I need to use them.

loseitstats03

Other Reports

While you’re on the Insights page, you can look at a the other reports, and there are few that have “Export to Spreadsheet” buttons. Don’t get too worried though, if you look at the Weight report. I was shocked to see that I’d had a drastic weight loss during the week before Christmas. I’m lucky to be alive!

Oh, never mind – it was only a one pound change. That’s another good reason to analyze food tracker data in Excel – you can make sure the y-axis starts at zero.

loseitstats05

Open the Data in Excel

After you’re finished exporting the data, log out of LoseIt, and open one of the files that you exported. The files are in CSV format, and should automatically open in Excel.

Here are the blurry details from one of my downloads. I’m sure it was mostly tofu and kale.

loseitstats06

Create a Master Workbook

Since you can only download one week’s per report, you’ll need to create a master file, to collect all the data in a single workbook.

  • Copy all the data and headings from one of your download files, and paste it into a blank Excel file.
  • Format the list as a named Excel table, and save it as your Master Workbook.
  • Later, paste in the latest data each week, after you download it, and sort it by the Date column.

Create Your Excel Reports

After all the data is added to the Master Workbook, you can create some pivot tables, to summarize the data. In my workbook, there are 3 reports:

  • Total calories per week
  • Average nutrients per daily meal
  • Top 5 foods, based on total calories

You can copy one of the existing reports, and change the fields, to create a new report, if you’d like to see another view of the data.

analyze food tracker data in Excel with pivot table

Get the Master Workbook

Instead of creating your own Master Workbook to analyze your LoseIt food tracker data in Excel, you can download a blank copy of my Master Workbook.

To get the file, go to the Food Tracker Reports page on my website, and go down to the “Get the Food Tracker Workbook” section.

Other Ways to Track Food Data in Excel

If you don’t use a food tracker app, you can do your tracking and reporting in Excel. I have an Excel Calorie Counter that you can download. Read about it in this blog post, and in this update article.

  • You can download a zipped copy of the Excel Calorie Counter with Recipe Calculator on my Contextures website. Go to the Sample Excel Files page, and in the “UserForms, VBA, Add-ins” section, look for  UF0016 – Excel Calorie Counter With Recipe Calculator
  • There is a free  Weight Loss Tracker workbook too, if you’re interested in that.

_________________

Save

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *