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

Do you eat all your calories?
I eat around 10-12 carbs/day ... it easy to keep track if you use the calculator on site ... you don't have to weigh anything its all been done for you ...if you don't keep track its much harder ...
by Firefish51 on 25 Nov 15 02:47 PM
I suffered from suicidal depression for over 30 years. I took every pill they ever made. It would help for a few weeks, then bam, right back in the pit. I don't have that problem any longer. The s ...
by SheaDlady on 10 Nov 15 05:04 PM
Fatsecret food diary CSV export tool
Unable to find the print function...why is FS so adamant about not adding this functionality?
by Monique 1 on 05 Nov 15 12:29 PM
Getting back in shape
I'm making a decision to get back in shape. I started yesterday and I will keep up the eating healthy and exercising until I loose a few pounds. My wedding is coming up in June next year and I would ...
by Chubs Magee on 03 Nov 15 11:16 AM
update on weight loss
Hi - no idea of your weight etc (as you have it set to private) but I was 155lbs and wanted to lose 14lbs (I've now increased that a bit) I lost 1lb a week on diet alone, no excercise, and nothing ...
by Tatmummy on 22 Oct 15 09:21 AM