Is it possible to export "My Weight History" to Excel/CSV?

previous topic · next topic
zaxxon

Joined: Feb 10
Posts: 1

      quote  
Posted: 19 May 2010, 08:20
Hi,

Is it possible to export the "My Weight History" data to a spreadsheet? I would like to do some analysis in excel offline.

Thanks!
Pegleged

Joined: Sep 10
Posts: 20

      quote  
Posted: 27 Sep 2010, 08:55
I see no export functionality, but you can highlight chart area on screen and paste into Excel.
zzkaftan

Joined: Jan 11
Posts: 4

      quote  
Posted: 25 Jan 2011, 10:59
I agree! Exporting to excel would be very helpful for example; calculating ww points.
dixie2bird

Joined: Jun 14
Posts: 1

      quote  
Posted: 08 Sep 2014, 13:00
I see this post is quite old. Has anyone done this. I also agree it would be helpful. I would like to show a trend analysis.
getagb

Joined: May 15
Posts: 2

      quote  
Posted: 22 Jun 2015, 17:54
There's no CSV export, but you can get JSON data by visiting your history page (https://www.fatsecret.com/Default.aspx?pa=memh), opening a web console, and typing `JSON.stringify(lineChartData)`.

You can try using a JSON to CSV converter (like http://www.convertcsv.com/json-to-csv.htm), but you'll probably still need to do some stuff by hand to get the data exactly the way you want.
howzat4u

Joined: Jan 15
Posts: 614

      quote  
Posted: 22 Jun 2015, 21:36
this post is 5 years old getagb, the author of it is no longer interested I am sure LOL
===================================================================================


"If losing weight were easy, we would all be walking around with a six pack"

Jan
getagb

Joined: May 15
Posts: 2

      quote  
Posted: 22 Jun 2015, 22:12
I was posting it for future readers
fatboy99

Joined: Aug 09
Posts: 1

      quote  
Posted: 28 May 2017, 14:40
Also for future readers of this on-going thread:

You can export to Excel, if you're a bit computer savvy.

Briefly, for Excel2003 (other versions may vary):
- Go to your My Weight History page on Fat Secret.
- With your mouse, highlight the entire table of data (located below the chart). You'll wind up grabbing the columns for Date, Weight, How Closely Followed, the colored bars, and the little X's.
- Do a Copy, then Paste into Excel (into cell 1A of a blank worksheet). All the data you just grabbed will show up in nice columns.


To convert the weight column to numeric data:
- Hilite column B (weight), then do Data>TextToColumns>Delimited>Next>Space>Next>Finish>OK(OK To Replace).
- If you want a graph, you can now hilite columns A and B, and do Insert>Chart


If you need to strip out the colored arrows from the weight column:
- Hilite column B (weight)
- Edit>Copy
- Hilite any blank column
- Edit>PasteSpecial>Values

This method is a bit sloppy, but does make the weight data available (and provides a backup!)
mattsingley

Joined: May 17
Posts: 1

      quote  
Posted: 15 Apr 2019, 12:56
@fatboy99 thanks, great advice, works wonderfully.



Forum Search
Advanced forum search


Latest Posts

Garmin Connect Integration
Totally agree, we need Garmin integration.
by BillMurphy123 on 16 Apr 19 10:37 AM
Is it possible to export "My Weight History" to Excel/CSV?
@fatboy99 thanks, great advice, works wonderfully.
by mattsingley on 15 Apr 19 12:56 PM
Terminate my account
Would like to delete account. Good luck to all of you.
by Nola Everton on 15 Apr 19 12:19 PM
Hesap silme
degisenadam wrote: Kullanmak istemiyorum
by trpk24 on 15 Apr 19 12:08 AM
Delete account
Apparently 1845 days ago I signed up here, I don't see evidence of sticking around at all, and forgot all about this app let alone signing up. Checking it out today and it telling me I already have ...
by Becky1971 on 13 Apr 19 05:02 PM