Skip to content
  • Register
    • We are pleased to announce that as of March 4, 2025, an updated Rich Text Editor has been introduced in the MyFitnessPal Community. To learn more about the changes, please click here. We look forward to sharing this new feature with you!

    Export and analyze your own data in Excel

    1…5681011…15

    Replies

    • Posts: 380 Member
      Just seen this. In to download later - looks amazing!
    • Posts: 24,208 Member
      Updated today:

      V3.13 - Corrected issue with secondary axis in 8 week Macro graph, age issue and Activity Level calculation. Rewrote oTDEE Graph to only show one maximal value per weight

      Tool can be found here: http://www.myfitnesspal.com/blog/EvgeniZyntx/view/new-mfp-data-export-tool-major-update-659927

      I'm also taking advantage of this post to explain two graphs:

      It is possible to review how much protein and fat one is "leaving on the table" by tracking these macros versus objective. With my own date, here is much fat and protein I've been off from my goals (ignore pre 5/13 data, wasn't tracking well)
      H4rUsEql.png

      Also, in a single place, I have average daily Carbs/Fats/Protein and Cals for the last 8 weeks.
      This tells me my protein and fats tracked have been going up over this period - once I have consistent tracking for an 8 week period I can evaluate the direction of these macros and total cals.

      mCcD4Ncl.png
    • Posts: 93 Member
      bump to come back to
    • Posts: 404 Member
      Tagging for finding again later - jic
    • Posts: 24,208 Member
      Updated Again

      v4.01 - Configuration is improved. Import method rewritten to speed up and reduce queries. Now exports cholesterol, sugar, sodium and fiber. Layout and configure changes. Added ignore today button, not fully supported yet.

      Tool can be found here: http://www.myfitnesspal.com/blog/EvgeniZyntx/view/new-mfp-data-export-tool-major-update-659927
    • Posts: 2,716 Member
      I can't use the tool because I'm on a Mac, but it gladdens my heart just knowing that someone out there has created this tool (namely, you, EvgeniZyntx).

      Thanks for making this tool available to those you have longed for this very capability.
    • Posts: 1,606 Member
      *bump* and to track in my own feed... Many thanks!!
      Updated Again

      v4.01 - Configuration is improved. Import method rewritten to speed up and reduce queries. Now exports cholesterol, sugar, sodium and fiber. Layout and configure changes. Added ignore today button, not fully supported yet.

      Tool can be found here: http://www.myfitnesspal.com/blog/EvgeniZyntx/view/new-mfp-data-export-tool-major-update-659927
    • Posts: 135 Member
      This is awesome! Thank you for taking the time to make and share this with the world :)
    • Posts: 245 Member
      BUMP
    • Posts: 1,413 Member
      BUMP!

      THANK YOU for doing this!
    • Posts: 2,525 Member
      *bump* and to track in my own feed... Many thanks!!
      show previous quotes

      This is my first time seeing this! Thanks!!! Now I have a reason to set my actual macro goals in mfp... I always just leave them set to default but keep my real goal in my mind :wink:
    • Posts: 81 Member
      This looks awesome. Looking forward to downloading later. Thanks!
    • Posts: 358 Member
      bump to find later
    • Posts: 413 Member
      Bump to download after work :)
    • Posts: 127 Member
      Bump to get this download this evening. Thanks in advance!
    • Posts: 24,208 Member
      Here is one example of the graph you can create with this.

      H7pm3Y0l.jpg
    • Posts: 42 Member
      Bump. Tagging for later!
    • Posts: 59 Member
      Bump
    • Posts: 132 Member
      Bump
    • Posts: 24,208 Member
      If you uploaded the worksheet yesterday, and had no data from a year ago, the export would have crashed. This is now repaired. Program update is available at the same link

      https://www.dropbox.com/s/biixuaat0ysj2ji/mfp4v01.xlsm
    • Posts: 302 Member
      What can I say....you are a superstar for all your hard work on this! Thanks a million :drinker:

      I feel bad to bother you....however this did not work for me....I got an error message that said:

      "Error: After location 6 in function ImportXMLdataMFP. The most recent error number is 5. Its message text is: invalid procedure call or argument."

      I tried at 365 days and then at 29 days as I've only just got back into loggin for the last 30 days after taking quite a long break. Neither worked. Do I need to change some settings perhaps?

      All my good data is from a few years back when I was loggin consistantly (just getting back into it) but I believe the report works for the last year only?

      Again, thank you sooooo much for putting this together!! Really appreciated by everyone here from the looks of it!
    • Posts: 24,208 Member
      Ok, I believe I've resolved your issue - the program crashed during the reading of settings when someone used "stone/lbs". This is now resolved. Also, the program should now work with Excel 2007/2010/2013.

      Updates are at the usual location:
      http://www.myfitnesspal.com/blog/EvgeniZyntx/view/new-mfp-data-export-tool-major-update-659927
    • Posts: 302 Member
      It worked!!! :smokin:

      I can't believe how clever you are - the info on there is amazing!

      Thank you ever so much - can't tell you how much I appreciate this!!!
    • Posts: 24,208 Member
      You are welcome!
      And thanks for the feedback!:flowerforyou:
    • Posts: 55 Member
      This looks incredible! Replying to download when I get home. Thanks!!!
    • Posts: 68 Member
      Tagging for later.
    • Posts: 58 Member
      I am going to have to try this! Thanks!!!
    • Posts: 974 Member
      Bumping for later!
    • Posts: 48 Member
      Bumping so I can check this out later.
    • Posts: 88 Member
      this is an awesome tool. Can't let this one go unnoticed, too great!!!! Wonderful job on that, I still have to read a little closer to correctly interpret what some of the charts display. But this is incredible ;)

    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Sign In
    Register

    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Sign In
    Register

    Quick Links

    Categories