Fatsecret food diary CSV export tool

1 | 2
previous topic · next topic

Joined: Oct 09
Posts: 14

Posted: 04 Nov 2009, 06:52
Hello Everybody.

Having just joined a week ago I immediately liked the site. However found myself searching for an alternative way to display the food diary or export it.

Searching trough the forums I found several people looking for the same thing but no one was successful. so I have taken it up on myself to create a CSV export tool.

The first version is now finished and working:

Fatsecret2csv was created to address the issue of missing export functionality. Many people have the need to use the data they have entered to display it in a variety of ways for many reasons. Maybe you want to use excel to graph your fat intake over time? Maybe you need to print a food log to bring to your doctor? Maybe you just want to store the data save somewhere for use later.

The tool uses your Internet Explorer (which needs to be logged in to www.fatsecret.com) to launch the www.fatsecret.com website. From their on it goes trough specified number of days and collects all your items out of your food log and add's them to a comma eperated list. Alternatively you can also use tab seperation for easy copy paste into excel. At the end the tool copies the output to your clipboard so you can simply paste (ctrl + v) the output into any text editor or application. It also offers you to store the results in a file.

You need the Microsoft .net framework version 2 installed. You also need to have logged in to www.fatsecret.com via Internet Explorer.

You can download the app here:
http://baddogs.de/fatsecret2csv.zip (Size 7 KB)

I have decided to use a stand alone application rather than a web app as this way my app does not require you to enter your login details as it simply uses your own web browser.

Thanks to fatsecret.com for their great website.

Please feel free to provide feedback in this thread.


Joined: Oct 09
Posts: 14

Posted: 24 Jan 2010, 05:29
Wonder if anyone found it useful so far...

Joined: Oct 09
Posts: 1

Posted: 29 Jan 2010, 14:33
Yes, quite useful. I discovered your post just today. BIG thanks.

I use it to pull the data and put it in an easily emailable format so I can send to my friend who is helping me with my diet.

I would LOVE it if it could also pull the data from the Diet Calendar and Excercise Journal too.

Joined: Oct 09
Posts: 1

Posted: 03 Feb 2010, 15:13
VERY glad to find this! A doctor wanted a diet diary and I was using fatsecret to keep track (just assuming I'd be able to export it somehow - apparently not a built in feature).

I'm very happy I can use your tool to export the data to something useful to submit. Thank you!

Joined: Oct 09
Posts: 14

Posted: 05 Feb 2010, 01:56

Thank you very much for your feedback. Similar to chizUFL I created the tool as I wanted a way to create a printable food log broken down per day in order to give it to my doctor.

GoodApollo, so far I had not thought about including it as personally I don't like the exercise tracker so I am not using it (the calorie burnt estimations seem just to overoptimistic for me).

If I got a few hours spare I might look into adding this to the export tool. If there is demand it surely is worth it. Just not sure when... Will let you know if I get around to it.


Joined: Dec 09
Posts: 139

Posted: 05 Feb 2010, 02:08
would LOVE this.... sadly however am on mac Sad but great app!

Joined: Nov 09
Posts: 1

Posted: 07 Feb 2010, 10:33
Definitely a useful tool; being able to pull the details out for analysis in a spreadsheet is great.

Joined: Jan 10
Posts: 660

Posted: 07 Feb 2010, 11:48
awesome awesome awesome! My trainer wnats to see my food diary and this will be way easier than scrolling through my phone! Thank you

Joined: Nov 09
Posts: 8

Posted: 10 Feb 2010, 15:37
Is there any way to get it to show future dates, like a week?

Joined: Jun 08
Posts: 13

Posted: 10 Feb 2010, 16:26
There must be some good developers out there who can use the API to get some good reports from our data happening. Come on technerds Wink

Joined: Oct 09
Posts: 14

Posted: 12 Feb 2010, 20:38
Thanks again for all the feedback.

Sorry that I can not be of more help for you. Maybe you have a friend where you can simply go to once a week / month and quickly use the app then paste it into excel or a textfile and mail it to yourself?

I had a look at the API initially and decided not to use it. Mainly as I do not want to have a website that other users have to login to. I felt this is something people might feel more comfortable using "on their own" not risking to share the data. Beside this it was in the end easier to simply write a plugin to the browser for me (did that several times).

Well fatsecret only shows you today and tomorrow tops. There is a trick to access it regardless however. Go to tomorrows day then look at your browser, it will read something like:
simply increase the number at DT by 1.

However I doubt it to be useful to export future days as CSV as you will never be absolutely sure if you really end up all that you planned for.

Joined: Jan 10
Posts: 44

Posted: 14 Feb 2010, 02:47
Thanks !

EDIT: works great with open office too
Fred Silva

Joined: Jan 10
Posts: 1

Posted: 15 Feb 2010, 12:20
Just downloaded and started to play with it. Helps a lot for those wanting to look at graphs for carbs/etc vs weight change. Suggestion: could you toss in a subtotal by day, or perhaps an option to just download each day's total kcal, fat, carbs, prot *and* weight? So we could organize our spreadsheets easier?

Joined: Oct 07
Posts: 43

Posted: 18 Feb 2010, 13:10
Thank you, thank you DerFelix! It's so great to be able to summarize my food journal. I've got a follow-up appointment with a nutritionist next week and this will really help. Hopefully FS will develope some reporting tools, so this information can be easily available to everyone. Thanks again.

Joined: Feb 10
Posts: 3

Posted: 18 Feb 2010, 14:20

Thank you very much. I have been trying FatSecret, plus two other food and exercise tracking programs two days now to see which one I want to use on a permanent basis. I like FatSecret the best but not having a convenient way to export the data would have killed it for me. I found I could copy the daily tracked total amounts and paste it into Excel and then parse the data which is put in just one cell using the text to columns feature, but that did not capture the individual food entries.

Thanks to you I may select FatSecret as the program I keep. (I like the Android barcode input and sync capability.)

I can't imagine why FatSecret does not have an export capability (nor a graphing one to show visually over time the level of the different food intakes).

Joined: Feb 10
Posts: 1

Posted: 28 Mar 2010, 14:17
Thanks a lot! This is wonderful!

Joined: Mar 10
Posts: 1

Posted: 01 Apr 2010, 16:37
Thanks this is great-- How difficult is it to add a similar thing for exercise and weight diaries?

Joined: Jan 09
Posts: 18

Posted: 01 Apr 2010, 23:23
hey, thanks for your hard work on this app, running Linux at home but can sneak in on the office Windows box if I need to. Would be nice if Fatsecret incorporated something similar right in the site for food, excercise, weight, etc... that way you wouldn't have to do the work Smile thanks again though!

Joined: May 10
Posts: 1

Posted: 10 Jun 2010, 15:26
Hey man, nice work.
Any chance you could share the source files?
or give a heads up on the api you used?


Joined: Dec 09
Posts: 7

Posted: 16 Jun 2010, 19:34
Hey fyi there's a print function in the food diary now that you can generate spreadsheets on. Cool.

Forum Search
Advanced forum search

Latest Posts

Fitness Tracker syncing to FS
i linked FatSecret via google fit with my android phone which allowed me to sync with my mi-band account, check in settings of your Virgin Pulse account for third party accounts. https://play.google. ...
by bft12 on 17 Jun 18 06:54 PM
Entering current weight in weight history
I can get today's in, but not yesterdays! I realized that I hadn't clicked "100%" when following the diet completely, so I deleted yesterday's weigh-in and tried to change it using ...
by SoCalPam on 16 Jun 18 01:36 PM
My Exercise Diary
I gave up and just use the calorie burn from my fitbit.
by abbadabba on 05 Jun 18 02:18 PM
June UPdate: Kidney Surgery
Two months since the surgery...Total weight lose since: 15 lbs., set a new goal of 195. Met with Dietician, who indicated no special diet required... one kidney can do the work of two...now doing a daily ...
by Dacemac on 05 Jun 18 12:10 PM
Post-Op Cancerous Kidney Surgery
Bob-- I haven't seen any recent posts from you and wondered how you are doing?
by Kenna Morton on 04 Jun 18 10:18 AM