We are pleased to announce that on March 4, 2025, an updated Rich Text Editor will be introduced in the MyFitnessPal Community. To learn more about the upcoming changes, please click here. We look forward to sharing this new feature with you!

Export and analyze your own data in Excel

1…34689…15

Replies

  • GarthBear
    GarthBear Posts: 51 Member
    Bump!
  • DopeItUp
    DopeItUp Posts: 18,771 Member
    Checking back in, I'm glad you made a blog with an updated download link. You keep making this thing better and better.
  • Buddhasmiracle
    Buddhasmiracle Posts: 925 Member
    Bump and thank you
  • julie2407
    julie2407 Posts: 44 Member
    Yay.
  • ingoiolo
    ingoiolo Posts: 104 Member
    No mac :(
  • foodfastfit
    foodfastfit Posts: 154 Member
    Hi. I wrote a tool to export the reports data as .csv files for use in Excel or similar programs. No fancy graphs, but it should work on both Mac and PCs. I just finished writing it a few hours ago, so with your feedback, I'd love to make it a better tool. Thanks! http://foodfastfit.com/myfitnesspal-x-foodfastfit/
  • Debbie_Ferr
    Debbie_Ferr Posts: 582 Member
    Fantastic ! thanks.
  • LiftAllThePizzas
    LiftAllThePizzas Posts: 17,857 Member
    Thanks again for this. With the data I've been able to work out this:
    Over 269 days, total cals in = 752901
    Lost = 10 lbs
    Deficit = 35000 calories
    Cals out = 752901 + 35000 = 784401
    Over 269 days, observed TDEE = 2929 calories per day.
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    Hi. I wrote a tool to export the reports data as .csv files for use in Excel or similar programs. No fancy graphs, but it should work on both Mac and PCs. I just finished writing it a few hours ago, so with your feedback, I'd love to make it a better tool. Thanks! http://foodfastfit.com/myfitnesspal-x-foodfastfit/

    Thanks for this. That's a neat way of doing it!

    I'm not currently running chrome on my machines for various reasons and am focusing on the next version of my tool. But afterwards, when I have a moment I'll install it and take a look!
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    Thanks again for this. With the data I've been able to work out this:
    Over 269 days, total cals in = 752901
    Lost = 10 lbs
    Deficit = 35000 calories
    Cals out = 752901 + 35000 = 784401
    Over 269 days, observed TDEE = 2929 calories per day.

    Very cool!
  • AmykinsCatfood
    AmykinsCatfood Posts: 599 Member
    I just got super bummed out. My version of excel doesn't work with it. It looks fantastic though!
  • The_WoIverine
    The_WoIverine Posts: 367 Member
    Bump
  • beckywilliams1967
    beckywilliams1967 Posts: 58 Member
    Bump thank you!
  • SandySweats
    SandySweats Posts: 38 Member
    This is very cool. I can't get any of the weight data to download, but the meal log, macros, etc. downloads fine.
    I use excel 2010 in windows 7. Not sure what the problem is.... I will reread through the thread to see if I missed something.

    Thank you again.
  • LesaDave
    LesaDave Posts: 1,480 Member
    bump
  • DapperKay
    DapperKay Posts: 140 Member
    Hi. I wrote a tool to export the reports data as .csv files for use in Excel or similar programs. No fancy graphs, but it should work on both Mac and PCs. I just finished writing it a few hours ago, so with your feedback, I'd love to make it a better tool. Thanks! http://foodfastfit.com/myfitnesspal-x-foodfastfit/

    Thats pretty cool, thanks. Wondering if the dates are messed up on purpose? For example:

    Nov-13 - 01/11/2013
    Nov-14 - 01/11/2014
    Nov-15 - 01/11/2015
    Nov-16 - 01/11/2016

    Incrementing by years and not days?
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    This is very cool. I can't get any of the weight data to download, but the meal log, macros, etc. downloads fine.
    I use excel 2010 in windows 7. Not sure what the problem is.... I will reread through the thread to see if I missed something.

    Thank you again.

    Try the different export methods and see if one of them works, please also see the setting notes in the blog.
  • delicious_cocktail
    delicious_cocktail Posts: 5,797 Member
    Hi. I wrote a tool to export the reports data as .csv files for use in Excel or similar programs. No fancy graphs, but it should work on both Mac and PCs. I just finished writing it a few hours ago, so with your feedback, I'd love to make it a better tool. Thanks! http://foodfastfit.com/myfitnesspal-x-foodfastfit/

    Thats pretty cool, thanks. Wondering if the dates are messed up on purpose? For example:

    Nov-13 - 01/11/2013
    Nov-14 - 01/11/2014
    Nov-15 - 01/11/2015
    Nov-16 - 01/11/2016

    Incrementing by years and not days?

    Depending on the way excel interprets dates, it could think that 11/13 is actually 1/11/13, and 11/14 is 1/11/14; misinterpreting the day for years
  • foodfastfit
    foodfastfit Posts: 154 Member
    Hi. I wrote a tool to export the reports data as .csv files for use in Excel or similar programs. No fancy graphs, but it should work on both Mac and PCs. I just finished writing it a few hours ago, so with your feedback, I'd love to make it a better tool. Thanks! http://foodfastfit.com/myfitnesspal-x-foodfastfit/

    Thats pretty cool, thanks. Wondering if the dates are messed up on purpose? For example:

    Nov-13 - 01/11/2013
    Nov-14 - 01/11/2014
    Nov-15 - 01/11/2015
    Nov-16 - 01/11/2016

    Incrementing by years and not days?

    Hi. I just made a small change to explicitly set the 4-digit year. This should help Excel correctly infer the date. Please let me know if this works for you. Thanks. http://foodfastfit.com/myfitnesspal-x-foodfastfit/
  • DapperKay
    DapperKay Posts: 140 Member
    Hi. I wrote a tool to export the reports data as .csv files for use in Excel or similar programs. No fancy graphs, but it should work on both Mac and PCs. I just finished writing it a few hours ago, so with your feedback, I'd love to make it a better tool. Thanks! http://foodfastfit.com/myfitnesspal-x-foodfastfit/

    Thats pretty cool, thanks. Wondering if the dates are messed up on purpose? For example:

    Nov-13 - 01/11/2013
    Nov-14 - 01/11/2014
    Nov-15 - 01/11/2015
    Nov-16 - 01/11/2016

    Incrementing by years and not days?

    Hi. I just made a small change to explicitly set the 4-digit year. This should help Excel correctly infer the date. Please let me know if this works for you. Thanks. http://foodfastfit.com/myfitnesspal-x-foodfastfit/

    Much better now. Now follows: MM/DD/YYYY. I'll just re-configure it to DD/MM/YYYY myself, thanks!
  • SlinkyAndHerAmazingBunsOfSteel
    SlinkyAndHerAmazingBunsOfSteel Posts: 434 Member
    Bump for later :smile:
  • LiftAllThePizzas
    LiftAllThePizzas Posts: 17,857 Member
    Hi. I wrote a tool to export the reports data as .csv files for use in Excel or similar programs. No fancy graphs, but it should work on both Mac and PCs. I just finished writing it a few hours ago, so with your feedback, I'd love to make it a better tool. Thanks! http://foodfastfit.com/myfitnesspal-x-foodfastfit/

    Thats pretty cool, thanks. Wondering if the dates are messed up on purpose? For example:

    Nov-13 - 01/11/2013
    Nov-14 - 01/11/2014
    Nov-15 - 01/11/2015
    Nov-16 - 01/11/2016

    Incrementing by years and not days?

    Hi. I just made a small change to explicitly set the 4-digit year. This should help Excel correctly infer the date. Please let me know if this works for you. Thanks. http://foodfastfit.com/myfitnesspal-x-foodfastfit/
    You can download ky2k, that will make it easier to insert 4 digits into your date.
  • coolraul07
    coolraul07 Posts: 1,606 Member
    ...
    This Excel program exports weight, calorie, macro and dairy data, provides some trend and projection analysis and takes a look at your macros. It provides reference TDEEs and calculates an observable TDEE from your own data.

    The current file is MFP2v4.xlsm
    ...
    It can be downloaded here: http://www.fileswap.com/dl/jIALndWL1T/
    ...
    Thanks!:drinker:

    *ETA: Old version (v4) wouldn't open in Excel 2013, but newer version (v13) did. I got the link from OP's profile:
    http://www.myfitnesspal.com/evgenizyntx
  • pinkstp
    pinkstp Posts: 220 Member
    bump & thank you :D
  • missionskinnynow
    missionskinnynow Posts: 88 Member
    bump
  • omma_to_3
    omma_to_3 Posts: 3,265 Member
    Nevermind LOL.
  • mumblemagic
    mumblemagic Posts: 1,090 Member
    Bump for later nerdery :smile:
  • kriscii
    kriscii Posts: 2
    Just tried it and its not getting any weight data on any of the options. Getting "there was a problem with your request" on option 3 from MFP when I log in.

    Running on Excel 2013. Not sure if it is just a temporary problem?
  • minizebu
    minizebu Posts: 2,716 Member
    I think I'm in love.

    Bumping to entertain my inner nerd later.

    Seriously, are you taken? Oh, wait. I'm already married. :P
  • DaveInFL
    DaveInFL Posts: 84 Member
    Just tried it and its not getting any weight data on any of the options. Getting "there was a problem with your request" on option 3 from MFP when I log in.

    Running on Excel 2013. Not sure if it is just a temporary problem?

    Just downloaded this today and I am getting the same issue. I'm wondering if this is because I have only 7 days of data so far?

Categories