This free excel template for family tree is useful for research purposes. This comes with six generations by default, however, you can add or reduce the generation count as per your requirement.
This is a new design for personal log of family tree using Excel or Spreadsheet.
About Family tree six generation free excel template
The family tree is printable is in the shape of a fan, with a colorful green tree in the background. Six generations can filled in, spreading out from the center of the semi-circle.
- Add your parent’s age together and divide by 2.
- This is the average generation interval for your immediate family tree.
- Complete this step for your grandparents also, continuing as far as you can be back.
- Take the year of your oldest ancestor’s birthday and subtract it from your own birth year.
Tips to Make a Family Tree with Excel / Spreadsheet
- Start with what you know, you and your living relatives.
- Ask your relatives for using their memories and family documents such as Bibles, birth and marriage certificates, journals and military records.
- Review websites to see what others have discovered about your family lines. Be careful for some of the family trees on line are not accurate.
- Focus on primary sources of tree such as copies of birth, census, death and marriage records. Many of these available on line for free or a nominal fee.
- Be patient – it might take a long time to uncover your genealogy.
- Consider CAPITALIZING the surname – this will help it stand when reviewing your records
- List dates as on 1 Jan 1890 to avoid confusion over the formats such as dd/mm/yy or mm/dd/yy
- List locations as City/Township, County, State, Country. For example: Las Vegas, Harris County, Texas, USA
Download and use Excel Family Tree Template
To use this free printable family tree excel template, you should have Microsoft Office/ Microsoft Excel installed in your system.
After installing Excel or Spreadsheet, download the zip file of this template, extract the template using WinRAR or 7Zip decompressing software.
Once extracted, you can open the file using Excel and start entering data or customizing the template.
