5

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
4

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.

2

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.

  • 1
    Tools 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
    Maybe you could just answer the question with what you know about this. – cbunn Feb 28 '17 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 – 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.