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.
    – cbunn
    Commented 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.
    – cbunn
    Commented 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. Commented Apr 26, 2016 at 17:54

2 Answers 2


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.


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
    Commented Feb 24, 2017 at 19:35
  • 1
    Maybe you could just answer the question with what you know about this.
    – cbunn
    Commented 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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