HELP - TREE - EXPORT

This form gives you (2) options to export the data in your Tree.

1. BLANK WORKBOOK = Moves the index data over to a new excel workbook. There will be no connection to the Tree workbook so you can modify this data as you wish.  Helpful to see all the people in your tree and to use Excel's pivot table and power query tools to analyze your tree in more depth.

2. GEDCOM FILE = Exports your data into a GEDCOM file.  You can use this to upload your data to another software or website.  You must have at least 2 people in your tree for this to work.

 

BLANK WORKBOOK:

1. Click on the "BLANK WORKBOOK" button (A). 
2. Read the prompt then press "Yes" (B).

*Be patient - may take a little while depending on the size of the tree.

The data in the new Excel workbook is Macro free and completely independent of the Tree workbook. Therefore you can edit it as you wish but any changes made to the Tree afterwards will have to be manually made to this index OR re-exported.

The Index will be formatted to print in the new workbook.

The table will have hidden columns that you can hide and unhide to use for more detailed analysis of your Tree.

 

GEDCOM FILE:

*The GEDCOM will use your current Font setting

1. Click on the "GEDCOM FILE" button (A). 
2. Read the prompt then press "Yes" (B).
3. Enter a filename and location to save the GEDCOM file.
4. A prompt will display when finished.

*Be patient - may take a little while depending on the size of the tree.

*Currently no sources will be included with the GEDCOM - only names, dates, places, relationships, and profile photos.