Use this free workbook to analyze the data from your LoseIt food tracker app. How to get your data, and create custom reports.
If you use the LoseIt food tracker app on your iPhone or iPad, you can see daily and weekly summaries of your data. To get more control over the reports, you can export that data to Excel. Follow the steps below, to see how to do that, then analyze your LoseIt food tracker data in Excel, instead of being limited to the preset options in LoseIt.
You can set up your own data analysis workbook in Excel, or download the free workbook and paste your own data into it.
To export the weekly stats from LoseIt, log in to the online version, at LoseIt.com.
NOTE: I use the free version of LoseIt, so things might look different in the premium version.
To see your weekly data:
At the top of the Weekly Summary , there is a drop down for the "Week of", and by default it shows the Monday of the current week.
NOTE: Weeks in LoseIt start on a Monday, and I don't see any way to change that setting.
To export the Weekly Summary data for the selected week, click the "Export to Spreadsheet" button at the top right of the page.
Depending on which web browser you use, you should see a dialog box that lets you choose where to save the data file. I change the number in the file name, so it shows the year, month and day.
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.
Each file contains a list, with all the food that you logged for the selected week, and the nutrition information for each item.
Since you can only download one week's data per report, you'll need to create a master file, to collect all the data in a single workbook.
This step is optional, but I added fields to the downloaded data. These will make it easier to summarize the data in the pivot tables.
At the right side of the Food Data table, add two new fields, to use in reports.
The 2nd argument in the WEEKNUM formula is 2, so the week starts on Monday, to match the LoseIt statistics.
If you downloaded more than one week's data, you can add the data from those files too.
Repeat those steps every time you download data.
After all the data is added to the Master Workbook, you can create some pivot tables, to summarize the data.
You can create more pivot table and pivot charts, to show other information about your food data. For example:
In my master workbook, there are 3 reports:
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.The zipped workbook is in xlsx format, and there are no macros in the file.
If you don't use a food tracker app, download one of the following workbooks, to do your tracking and reporting in Excel.
For regular Excel news, tips and videos, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.
Search Contextures Sites
Last updated: January 9, 2017 3:00 PM