Export and analyze your own data in Excel

AmykinsCatfood

I just got super bummed out. My version of excel doesn't work with it. It looks fantastic though!

The_WoIverine

Bump

beckywilliams1967

Bump thank you!

SandySweats

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

bump

DapperKay

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

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

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

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

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

Bump for later

LiftAllThePizzas

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

...
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

bump & thank you

missionskinnynow

bump

omma_to_3

Nevermind LOL.

mumblemagic

Bump for later nerdery

kriscii

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

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

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?