Message Boards » Website Suggestions/Feedback

TOPIC: Ability to exports summary data to excel / improved reports

« Prev 1
« Prev 1
 
Ic_disabled_photos
Topic has been inactive for 30 days or more and images have been disabled.
Display All Images
November 11, 2012 8:43 AM
I cut and past from the printable daily report into an excel spreadsheet. I then do some math and calculate my exact daily metabolic rate. This is a far more reliable number than the estimates provided in the goals section as it is based on my personal history so it takes into account my genetics, etc...

I would be happy to send you a copy of the spread sheet so you can see what I'm talking about. It would be nice to have this report or something similar that let's you see your empiric BMR on an ongoing basis. Or at the very least - the abilty to take the printable daily log output as a csv to more easily paste into excel. Right now, it takes a while to cut and paste each day, then strip off the formatting and g / mg suffixes.

I think empiric BMR is or should be what drive's peoples nutritional and exercise choices and having it more readily available would make the data we so compulsively enter that much more useful.

In any case, thanks for a great site!
November 11, 2012 9:11 AM
Compleely agree on that
  29317034
November 11, 2012 12:00 PM
I am looking for much the same thing - I want to export weekly sugar figures to Excel to chart them. I see the daily numbers in the Food Diary, but not the weekly ones, which are nevertheless available on the iPhone. And I can get a chart out of the Reports tab, but only per day, and I want per week. Having a link for exporting weekly data as CSV would be so helpful.
November 11, 2012 9:25 PM
I agree! MFP absolutely needs an export feature to take all of our detailed data to Excel to view & manipulate how WE WANT TO SEE IT. Please, please give us an export to CSV format!
  24406553
November 13, 2012 6:03 AM
Agreed. My weight fluctuations vs the scale of the weight graph in MFP are so small they're almost impossible to see on the graph. I'd love to be able to export to Excel and analyze my progress with easier to read graphs.
November 16, 2012 12:38 PM
I agree 100%. I'm looking to do some Analysis in excel and I don't see any efficient way of doing that at the moment.
November 22, 2012 8:00 AM
I agree, and I would pay more for the service, if they wanted to make that a premium option or something. The calories report on the Reports tab don't tell you how much you are over/under target for the 7 day or 30 day periods. It seems a more reporting page, or ideally, the ability to export your data would be great.
November 22, 2012 2:55 PM
Ability to export food diary and weight information as a simple csv is essential. I am a new user and I like what I've seen so far, but this is a must have. Without it I simply don't own my own data. Please add this asap. I'm not sure if I should stick with myfitnesspal or go to a competitor based on this missing feature.

Please at least let us know if you plan on adding this or if you are working on it. Is this something a programmer could do with the api?
November 22, 2012 3:43 PM
I'll jump on this petition. Please, MFP, allow for exporting to Excel so that we can create our own reports. Everyone is tracking different things: Calories, Macronutrients, Calcium intake, Weight, Bloating due to TOM, Strength training/weight correlations, etc... The ability to extract the raw data reduces the need for MFP staff to write more code and gives users more flexibility.

What say ye?
November 23, 2012 9:51 AM
Agree. One mass export of all data for a specified period would be a HUGE help.
November 23, 2012 1:02 PM
Yes add me as a 'me too'. I'm not all that bothered if it's Excel export but MFP definitely needs better reporting - it's the weakest part of what's an otherwise great service.
November 24, 2012 11:08 AM
Does myfitnesspal respond to these posts?
November 28, 2012 5:03 AM
I'll go along with the above. Was looking to be able to separate out how much of my intake is from Snacks & Alcohol (added this to the food diary). Should be able to do this myself if I could export to excel.
  18880339
November 28, 2012 6:58 AM
QUOTE:

Does myfitnesspal respond to these posts?


I asked that a month or two back, and actually did get a sort-of answer: "You should have read the forum sticky." I rarely go directly to the list of topics in a specific forum, I just hit the "Recent Posts" and "My Topics", so I didn't know there was a sticky. Here's the link:

http://www.myfitnesspal.com/topics/show/387296-thank-you-for-your-great-suggestions

To answer your question: Almost never. They won't tell anyone what they're working on at any given time, nor will they announce when they've pushed out a change to the Web site. They do announce new versions of the mobile apps.

The reports look like something I would have written in Comp Sci 101 back in the day. They work, but they aren't user-friendly; and while they do provide data, I wouldn't say they provide useful information.

Please, may we have CSV export?
Edited by castlerobber On November 28, 2012 6:59 AM
  18241374
November 29, 2012 12:25 PM
This is the ONLY down side I have to MFP. I realized this would be great when i first started but had gotten over it. Lets revisit!
  29400808
November 29, 2012 1:09 PM
I agree, this definitely needs to be added. I've been looking for it, now I know why I couldn't find it.
Please MFP - add the ability to export to CSV.
  31683556
November 29, 2012 1:26 PM
+1
  25631519
December 5, 2012 6:08 PM
Cool, I just noticed this post http://www.myfitnesspal.com/post/new/716679-need-data-export-feature?quote=11946400

From this MFP person http://www.myfitnesspal.com/tommy

QUOTE:

Hello,

Thank you for all of the feedback regarding reports and export options, we know that this component of our service is in serious need of an overhaul and will be reworked. We want to make sure you know that there is no need for petitioning because we agree on the value of exportable data and more robust reporting, we have many projects going and once this one is completed we hope you enjoy the update. Since I cannot give you a timeline, I must thank you for your patience in the mean time. I am locking this thread so that attention can be mainly paid to technical support issues and helping the MyFitnessPal community successful in reaching and maintaing their goals.

Regards,

Tom
MyFitnessPal Staff
December 30, 2012 11:21 AM
Just figured out little hack to get the XML data that is used in the various charts that are produced under Reports/View. If you look at the code for http://www.myfitnesspal.com/reports/view after selecting one of the charts to review, you'll see that there is an embedded Flash object, and the url it's pulling the data from is http://www.myfitnesspal.com/reports/results/progress/1/90 (in the case of getting 90 days of weight data). That URL returns an XML file with however many days of data are requested in the URL. Not exactly CSV or Excel data, but it's a start....
December 30, 2012 12:02 PM
Just to make this point even more clear, you can get all of the data that is displayed in the reports section using this hack. So say for instance you wanted 90 days of nutrition data reported for protein consumed, the url to get the data as XML is http://www.myfitnesspal.com/reports/results/nutrition/Protein/90.

The dates are for each data point are encoded in string tags, and the actual protein values are in number tags.
January 5, 2013 12:14 PM
Wow, wstsdblks, you're a genius! THANK YOU!! It's a little effort but I can finally get at all the data I've entered!

Thanks so much for the helpful trick. I tried it on a variety of my data and you can extract as many days as you want, not just the preset 7, 30, 90, 180 days on the webform. I'm grabbing 250 days in all of the examples below. Then I open it in Excel 2010.

SOME ADDITIONAL HINTS:
======================
- Save XML file, open as read-only workbook.
- Column AD has date in AD3-AD252 (for 250 days)
- Column AC has value of selected report in AC253-AC502 (for 250 days).
- Copy the data from these two ranges into a new workbook.
- Cut/Paste data values in AC253-AC502 to column & row next to date.
- Then graph away!!!

I grabbed "net calories", then "progress" (weight) and graphed my weight loss to net calories - very interesting. Then, I compared to "calories burned". To get these, the URLs are pretty self explanatory.

They all start with:
==============
http://www.myfitnesspal.com/reports/results/
Then, "nutrition", "progress", or "fitness"
Then, the value you want like "Net%20Calories", "Saturated%20Fat", etc. that are straight from the names in the pulldown list on the webform. Then, the number of days ("250" for mine below).

http://www.myfitnesspal.com/reports/results/nutrition/Carbs/250
http://www.myfitnesspal.com/reports/results/nutrition/Fat/250
http://www.myfitnesspal.com/reports/results/nutrition/Sugar/250
http://www.myfitnesspal.com/reports/results/nutrition/Fiber/250
http://www.myfitnesspal.com/reports/results/nutrition/Protein/250
http://www.myfitnesspal.com/reports/results/nutrition/Net%20Calories/250 (%20 should be space in URL)
http://www.myfitnesspal.com/reports/results/nutrition/Saturated%20Fat/250 (%20 should be space in URL)

http://www.myfitnesspal.com/reports/results/progress/1/250 (WEIGHT)

http://www.myfitnesspal.com/reports/results/fitness/Calories%20Burned/250 (%20 should be space in URL)

Awesome! Thanks again wstsdblks!
Edited by NoJustTheDude On January 5, 2013 12:20 PM
  24406553
January 8, 2013 8:08 AM
Has anyone been able to build a script that pulls the carbs data or any other data and do custom calculations based on food input in the myfitnesspal app.

simplexml_load_file('http://username:password@www.myfitnesspal.com/reports/results/nutrition/Protien/1');

I have a special need calculate Proteins consumed in a single day and ensure that I am not exceeding my doctors recommendation.
I would like a simple script that pulls the food consumed, protein count, then subtract from the recommended protein from my Dr. and email that value out at lunch and dinner. Any help would be greatly appreciated.

Currently when I run the above login link I get the login page and not the actual XML file.
October 4, 2013 9:18 AM
This page was too confusing to me, but it looks like Google Docs Spreadsheet can handle this?
http://nicksuch.wordpress.com/2011/06/03/adventures-in-self-tracking-my-quest-to-export-data-from-myfitnesspal-quantifiedself/
October 23, 2013 5:21 AM
Here is a tool that exports that data from the web queries directly. It does not use the hack here but thanks for that, will also look into that.

http://www.myfitnesspal.com/topics/show/1122752-export-and-analyze-your-own-data-in-excel?hl=export#posts-17401805
  26854327
April 13, 2014 4:24 PM
(for: Microsoft Word Excel File)
You can go to "food" and scroll to the bottom to view the printable report. Specify the range of dates at the top of the screen. Go to edit -> select all in the browser menu at the top of your computer screen. Go to edit -> copy

Open a blank Microsoft Word Excel Sheet
Go to edit -> paste
Delete the top columns until you get to the first date (should be about 10 rows or so)
Highlight the columns with information in them by clicking and dragging on A, B, C etc.
Go to the filter button (or Data -> Filter)
drop down menus should appear on the top row under A, B, C etc
Click on the fist drop down button
Click the box that says "select all" to remove all checks from the labeled boxes
Scroll down to TOTAL and check the box
This will make everything disappear except for the totals (calories, fat, sugar, etc) from each day that was specified in the report.

Now you can do calculations, graphs, etc as you wish!

Hope this helps! :)

Reply

Message Boards » Website Suggestions/Feedback

Posts by members, moderators and admins should not be considered medical advice and no guarantee is made against accuracy.