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 ♦Commented Apr 20, 2016 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.– cbunnCommented Apr 21, 2016 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 ♦Commented Apr 21, 2016 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.– cbunnCommented Apr 25, 2016 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 BorgsteedeCommented Apr 26, 2016 at 17:54
|
Show 1 more comment
2 Answers
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.– cbunnCommented Apr 25, 2016 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).– ColinCommented Apr 26, 2016 at 8:24
-
Apparently the API is closed to the public now, so it's not easy/possible to build a tool to use their API to get a spreadsheet from your data :/ Commented Dec 1, 2023 at 2:56
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 ♦Commented Feb 24, 2017 at 19:35
-
1Maybe you could just answer the question with what you know about this.– cbunnCommented Feb 28, 2017 at 15:02
-
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 Commented Feb 28, 2017 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. Commented Feb 28, 2017 at 19:45
-
1@Lance sorry, I haven't made an attempt since a bit after the time I posted this answer. Commented Dec 1, 2023 at 4:47