I want to generate a spreadsheet of everyone I have in my FamilySearch.org family tree. I want the data associated with these names as well (birth, marriage, death related info). Is there a tool to do this or do I have to go through manually? I am open to all options for this.
-
What would your desired spreadsheet look like? Perhaps you can use a test tree of a few individuals to illustrate your requirement? – PolyGeo♦ Apr 20 '16 at 20:11
-
Just a table with columns for name, DOB,POB, Date of Marriage, Place of Marriage, Date of Death, Place of Death. I want to map out all of the significant events in my ancestors' lives, but I don't want to use one of the programs that will do it for you because I want to do more with it. – cbunn Apr 21 '16 at 15:40
-
If you are planning to map it then putting out lat/long would seem to be important. Rather than go to Excel perhaps you could look for GEDCOM to Geodatabase, Shapefile or KML convertors. – PolyGeo♦ Apr 21 '16 at 23:08
-
If I can get the city/state/country of these events in a spreadsheet I can geocode them to derive lat/lon. – cbunn Apr 25 '16 at 14:08
-
What do you mean by your tree? You don't own anything on FamilySearch, so there is no such thing as your tree. – Enno Borgsteede Apr 26 '16 at 17:54
Looking at the help / FAQ on the FamilySearch site it states that there is currently no way to export your tree from FamilySearch. It goes on to say that this may be possible with a third party application.
So unfortunately it looks as though you may have to do this manually.
-
Yeah it looks like it. I was just hoping someone knew what 3rd party app would do this if any. – cbunn Apr 25 '16 at 14:09
-
Doing some searching on Google has come up with these two links but it isn't easy. support.legacyfamilytree.com/article/AA-00387/0/… and getsatisfaction.com/familysearch/topics/… (read the threads at the bottom of this post). – Colin Apr 26 '16 at 8:24
You can use the Family Search API even though they have no already written tools. This is suggested in the link Colin left in his answer.
Specifically, someone has written a python script that exports to GEDCOM. Not sure how well that translates to a spreadsheet.
-
1Tools do exist that convert GEDCOM to spreadsheets and vice-versa. I'll leave that for you to explore, in case you want to improve the quality of your answer. ;-) Welcome, and have fun exploring the site! – Jan Murphy♦ Feb 24 '17 at 19:35
-
1
-
There is an interesting list here: cyndislist.com/gedcom/gedcom-software/?page=2. I am looking forward to trying the python script exporting to GEDCOM first before recommending anything. This one appears to be free and looks interesting: gedmagic.com/GEDxlate.htm – Dave Neeley Feb 28 '17 at 19:36
-
This one is also free and open source - written in C# it appears - and outputs to xml, which excel can import. gedmagic.com/GEDxlate.htm. But if we're importing from the API, why export to GEDCOM first, and then to xml, and then to excel? It could be easier to import the FamilySearch JSON objects directly into Excel with an addin like this one: excel-requests.pathio.com/en/master. It all depends on your comfort level with technology. – Dave Neeley Feb 28 '17 at 19:45