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

    24567…15

    Replies

    • Posts: 3,265 Member
      Huh...I can't get it to work. Weirdness.
    • Posts: 931 Member
      bump for later. Hope it works on my Mac
    • Posts: 75 Member
      Thanks, will look more into this when I get home.
    • Posts: 24,208 Member
      Huh...I can't get it to work. Weirdness.

      Let me know what is the problem - and I'll try to address it. It was developed on Excel 2010 and requires that you have a Internet Explorer on your machine - not sure it will work on a Mac.

      And thanks all for the positive feedback. Glad it is useful!
    • Posts: 3,265 Member
      I have Excel 2007 and IE. PC based. If I try to pull in the calories, it populates all the dates, but doesn't pull back any other data. If I try to pull the weights, it doesn't do anything. No error message.
    • Posts: 931 Member
      Let me know what is the problem - and I'll try to address it. It was developed on Excel 2010 and requires that you have a Internet Explorer on your machine - not sure it will work on a Mac.
      I have Safari, Firefox and Chrome on the Mac. Guess it won't work, then? And I don't want to fire up the Windoze VM either. hmmmm
    • Posts: 41 Member
      Bump
    • Posts: 468
      It wont import weight data for me. It imports calorie data as expected.

      Excel 2010, Win 7
    • Posts: 7,692 Member
      Looks awesome :drinker:

      Sadly, I only have the starter edition of excel and as such I can't make use of this awesomeness.
    • Posts: 1,812 Member
      It wont import weight data for me. It imports calorie data as expected.

      Excel 2010, Win 7

      Same here. Calorie/macro data is fine, but it won't pull my weight data.
    • Posts: 4,966 Member
      Nerd alert
    • Posts: 438 Member
      Bump
    • Posts: 33 Member
      Will try this when I get home tonight. Thanks!
    • Posts: 529 Member
      Nerd alert

      Naaawh, it's not done in C# ;)

      Now, if he developed web app with a sql database back end and imported the data in on the other hand... ;)

      Nice stuff, though the download link is dead, anyone else upload it please? =)
    • Posts: 419 Member
      show previous quotes

      Same here. Calorie/macro data is fine, but it won't pull my weight data.
      Same here. Nutrition is good but no weight data. I'll check it on my home computer later. Thanks for sharing!
    • Posts: 98 Member
      Your Excel abilities are wizard level 100. Well done.
    • Posts: 3 Member
      Awesomesauce. Thank you.
    • Posts: 19,809 Member
      Very clever Sir!

      I'm also not able to pull in weight data though.... IE 10 and Excel 2010
    • Posts: 882 Member
      Thank you, I will download this later!
    • Posts: 24,208 Member
      show previous quotes

      Naaawh, it's not done in C# ;)

      Now, if he developed web app with a sql database back end and imported the data in on the other hand... ;)

      Nice stuff, though the download link is dead, anyone else upload it please? =)

      New version

      http://bit.ly/HhXhfF

      I've done web apps, and more dev languages than I can think of but I do not want to do this on a web service because I don't want to store people's data.

      I've seen that a few people have issues with exporting the weight data so I will look into that.
    • Posts: 3,189 Member
      It's totally useless for me. I'm stuck with Excel 2003 both at home and in work. :grumble:
    • Posts: 24,208 Member
      For those having issues with the weight import, is someone interested in participating in a "debug session" ?
      I would send you a special version and we would walk through the steps of importing (via a webex session) so that I could see the issue and attempt to solve it.

      PM me or post here if interested.
    • Posts: 331 Member
      I saw 'export', 'data' and 'excel'...and got a little tingly with excitement! ;)
    • Posts: 1,334 Member
      It's totally useless for me. I'm stuck with Excel 2003 both at home and in work. :grumble:

      I have 2003 also and it's not working. Bitter tears are shed. Luckily I have 32 calories left today so I can drown my sorrows in a third of a shot of whiskey.
    • Posts: 352 Member
      Thank you!
    • Posts: 468
      For those having issues with the weight import, is someone interested in participating in a "debug session" ?
      I would send you a special version and we would walk through the steps of importing (via a webex session) so that I could see the issue and attempt to solve it.

      PM me or post here if interested.

      Im not able to do a webex session tonight (dealing with kids), but would be happy to debug/walk through if you wanted to send directions as I run around.
    • Posts: 185 Member
      this looks awesome, thanks!
    • Posts: 2,065 Member
      bump and thank you for you are a gold mine of useful information.
    • Posts: 34,415 Member
      In.
    • Posts: 100 Member
      Thanks! This is awesome! The only problem I have is the TDEE data... where do you put that in? On the graphs page you say to use the "Config" tab but there isn't one in the sheet.

      Edit - Works in the updated version you posted!! Thanks

    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