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

24567…15

Replies

  • omma_to_3
    omma_to_3 Posts: 3,265 Member
    Huh...I can't get it to work. Weirdness.
  • Laurayinz
    Laurayinz Posts: 931 Member
    bump for later. Hope it works on my Mac
  • Cassieabc
    Cassieabc Posts: 75 Member
    Thanks, will look more into this when I get home.
  • EvgeniZyntx
    EvgeniZyntx 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!
  • omma_to_3
    omma_to_3 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.
  • Laurayinz
    Laurayinz 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
  • mrsslls
    mrsslls Posts: 41 Member
    Bump
  • samammay
    samammay Posts: 468
    It wont import weight data for me. It imports calorie data as expected.

    Excel 2010, Win 7
  • shadow2soul
    shadow2soul 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.
  • kyleekay10
    kyleekay10 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.
  • ryry_
    ryry_ Posts: 4,966 Member
    Nerd alert
  • Slrajr
    Slrajr Posts: 438 Member
    Bump
  • klynnshuck
    klynnshuck Posts: 33 Member
    Will try this when I get home tonight. Thanks!
  • jollyjoe321
    jollyjoe321 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? =)
  • kimmymayhall
    kimmymayhall Posts: 419 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.
    Same here. Nutrition is good but no weight data. I'll check it on my home computer later. Thanks for sharing!
  • pittdan77
    pittdan77 Posts: 98 Member
    Your Excel abilities are wizard level 100. Well done.
  • conniechappell
    conniechappell Posts: 3 Member
    Awesomesauce. Thank you.
  • sijomial
    sijomial Posts: 19,809 Member
    Very clever Sir!

    I'm also not able to pull in weight data though.... IE 10 and Excel 2010
  • bernied262
    bernied262 Posts: 882 Member
    Thank you, I will download this later!
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 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? =)

    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.
  • Thomasm198
    Thomasm198 Posts: 3,189 Member
    It's totally useless for me. I'm stuck with Excel 2003 both at home and in work. :grumble:
  • EvgeniZyntx
    EvgeniZyntx 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.
  • mazmataz
    mazmataz Posts: 331 Member
    I saw 'export', 'data' and 'excel'...and got a little tingly with excitement! ;)
  • wild_wild_life
    wild_wild_life 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.
  • ElizabethFuller
    ElizabethFuller Posts: 352 Member
    Thank you!
  • samammay
    samammay 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.
  • MandyMason7
    MandyMason7 Posts: 185 Member
    this looks awesome, thanks!
  • Ophidion
    Ophidion Posts: 2,065 Member
    bump and thank you for you are a gold mine of useful information.
  • jofjltncb6
    jofjltncb6 Posts: 34,415 Member
    In.
  • julialdr
    julialdr 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

Categories