Message Boards » Website Suggestions/Feedback

TOPIC: Export To Excel

« Prev 1
« Prev 1
 
Ic_disabled_photos
Topic has been inactive for 30 days or more and images have been disabled.
Display All Images
March 6, 2012 11:32 AM
First let me say how much I like the current site and phone app.

I would love to be able to export all of my daily data to Microsoft Excel for charting and graphing.
This would include all food names and all their nutrition values by meal.
Give us everything in the data base and let us decide what we don't want.

I currently do this manually and I'll tell you it is a lot of work to enter it all.
A simple export cvs file or similar would be great!
I use the data to show my doctors what I am eating and the effect it has on my glucose levels (Diabetes).
March 6, 2012 11:37 AM
How are you doing it manually? I just tried copy and paste and it carries the formatting over. Seems simple enough to chart from this work around.
  17909147
March 23, 2012 8:27 PM
+ to this request

Even having an option to export the raw data instead of a report would be a huge help to me :)
March 24, 2012 10:10 AM
That is my only complaint with this site! I would love export to Excel or CSV. I love dissecting and looking for patterns, but it's pretty impossible to do with this site unless I want to manually copy all the data, which is silly since an export shouldn't be too hard.
March 27, 2012 9:32 AM
Great suggestion!! I'd love this option as well.
March 27, 2012 9:44 AM
I copy and paste mine, but it would be much simpler to be able to export directly.
April 6, 2012 2:55 PM
please add this option!
April 11, 2012 8:20 AM
I agree with all of the above posts. The utility of the app would immensely increase with a download data option.
April 11, 2012 10:07 AM
Problem w/ copy and paste is that it copies the units (g, mg) in the same cell which makes it impossible for Excel to handle it as a number. If the units were only in the header and the cells were numbers only copy and paste would work well.
April 13, 2012 10:39 AM
After checking out several nutrition apps / websites I'm thinking that myfitnesspal could be the one for me.

The only drawback so far seems that users data can't be exported as an xl or csv.

Would be great if this could be added.
April 15, 2012 2:21 PM
Mark, to get rid of the units (ex. "mg" in the "45.3mg"), use the following formula: "=VALUE(LEFT(RefCell,LEN(RefCell)-NrUnitsChar))", where RefCell is the cell that you want to extract the value from and NrUnitsChar is the number of characters of the units (in the example NrUnitsChar = 2). Hope this helps!

Supposedly, there are websites that do the whole extraction automatically... The ones I've tried, generated blank CSV files. Still, the best way to process the MFP data is to copy-paste and then use the good old Excel...
April 15, 2012 2:27 PM
The complain about downloading data is years old!!! It looks like is the policy of this website to not offer this option. I am guessing, for the fear that you might take the data and go to another place!
April 16, 2012 8:03 AM
There wouldn't be a need for exporting to excel if the internal tracking were better. I don't have the Iphone version (using a BB) but I can only get one day's data at a time. The 'report' function is just the bar chart for the last 7/30/90 days doesn't really help as it isn't aligned at all with my personal goals. I should be able to easily see the days when I met my goal and the days I didn't over the 7/30/90 day span. Right now I can't.

Of course I am complaining about a free service which is not cool (though they are getting ad revenue). I would be happy to pay $1.99 or more for the basic functionality mentioned in this thread though. (this would only be a few hours of coding max)
April 16, 2012 8:15 AM
QUOTE:

Mark, to get rid of the units (ex. "mg" in the "45.3mg"), use the following formula: "=VALUE(LEFT(RefCell,LEN(RefCell)-NrUnitsChar))", where RefCell is the cell that you want to extract the value from and NrUnitsChar is the number of characters of the units (in the example NrUnitsChar = 2). Hope this helps!

This is great. But if you are uncomfortable using a formula, highlight the cells that contain "g" or "mg", and do a find and replace. (Replacing them with nothing.)
April 17, 2012 2:36 PM
This works as well! I use the formula in a spreadsheet that calculates the average nutrients in a given period of time. It works well for me!
April 17, 2012 2:38 PM
This entire thread excites me.

I would love an export option as well. Pretty please!!
  113243
April 17, 2012 3:26 PM
My vote also for an export function. I currently copy and paste each day from my food diary to Excel. That gets tedious, and I'm limited to only the columns that show on the screen. If I copy and paste from the report, I get more columns, but have to find and replace to get all the g/mg out.
  18241374
April 17, 2012 3:52 PM
Would love this function as well!
  2812191
April 17, 2012 4:13 PM
Add my vote!
April 17, 2012 4:17 PM
I have only been around for a month. Do they ever add some of these suggestions they receive from all its followers.

How often do they update the site and do they send notices that something is new????

Thanks from a Newbie.
  4640842
May 24, 2012 10:23 AM
QUOTE:

I have only been around for a month. Do they ever add some of these suggestions they receive from all its followers.

How often do they update the site and do they send notices that something is new????

Thanks from a Newbie.


I'd like to hear on this too,

Please add my vote for excel export.
May 25, 2012 6:04 PM
Great Idea. I have made some Excel macros to copy/paste the data here but having an export feature would be a great addition to an already great site.

Or even a feature to export to a txt or csv file formats. Nice generic format that can easily be opened in any program one may use.
May 30, 2012 5:19 AM
http://www.fileswap.com/dl/rEJFvAR50L/mfp.xls.html

works for me
  220785
June 2, 2012 4:22 PM
QUOTE:

http://www.fileswap.com/dl/rEJFvAR50L/mfp.xls.html

works for me


Very nice script, whoever may have written it!! It does what mfp should have incorporated in the site... Well, it is never too late..;)
June 5, 2012 2:15 AM
+1
  19864792

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.