10+ Sample Family Tree Templates in Excel

There are those people who have an extensive family history that they’ll want to share it with the future generation of family members. If they want to do that, then they’ll need something that contains information on all of the previous generations and how they were all connected to one another.

That’s why they create family trees in the event one wishes to learn all about his/her lineage. This article will teach you all that you need to know in regards to how you can create your own family tree in Excel.

Elements of a Family Tree

Remember that the point of a family tree is for it to provide extensive knowledge on a person’s family history. So should you make one, you must learn about the basic elements to ensure that the family tree contains all the information it needs. The elements of a family tree would be the following:

1. Title: You’ll most likely create more than one family tree as you’ll most likely want to have separate ones that focus on different generations. So what you’ll need to do is to come up with an appropriate title for each of them. It’s important that the title has something to do with the contents of the family tree. For example, if you’re going to make a family tree that covers five generations, then you’ll want the title to consist of your last name and the number of generations whose information is being shared.

2. Names: The names that you will place into the document will depend on the generations that your family tree document will be covering. Make sure that you write down the first, last, and middle name of each person you will be including. Also, be sure to check that they are all spelled correctly as you don’t want to be presenting readers with the wrong information.

3. Date of birth/death: For every name that you put into the family tree, you’ll also have to include their date of birth and the date in which they have passed away. Make sure that you put in the exact month, day, and year for either so that there won’t be any questions regarding “when”.

4. Relationship ties: Those who go through your family tree chart will want to know the relations of each and every single person in the document. That’s why you’ll have to make it clear as to who is tied in with who. Point out things like who your mother and father are if you have any siblings, uncles, and aunts that made their way into the family, etc.

10+ Family Tree Templates in Excel

Free Blank Family Tree Template

Template Details

Available File Formats
  •  
  •  
  •  
  •  
Size: A4, US

Get This Template

Sample Family Tree Template

Template Details

Available File Formats
  •  
  •  
  •  
  •  
  •  
Size: A4, US

Get This Template

Genealogy Family Tree Template

Template Details

Available File Formats
  •  
  •  
  •  
  •  
  •  
Size: A4, US

Get This Template

Free Third Generation Family Tree

Template Details

Available File Formats
  •  
  •  
  •  
  •  
Size: A4, US

Get This Template

Four Generation Family Tree Template

Template Details

Available File Formats
  •  
  •  
  •  
  •  
Size: A4, US

Get This Template

Simple Family Tree Format

Template Details

Available File Formats
  •  
  •  
  •  
  •  
Size: A4, US

Get This Template

Modern Family Tree Template

Template Details

Available File Formats
  •  
  •  
  •  
  •  
Size: A4, US

Get This Template

Family Tree Chart Example

Template Details

Available File Formats
  •  
  •  
  •  
  •  
Size: A4, US

Get This Template

Free Photo Family Tree Template

Template Details

Available File Formats
  •  
  •  
  •  
  •  
Size: A4, US

Get This Template

Basic Family Tree Example

Template Details

Available File Formats
  •  
  •  
  •  
  •  
Size: A4, US

Get This Template

How to Create a Family Tree

1. Make use of Microsoft Excel: Take note that it’s highly recommended that you use Microsoft Excel as it has generally been accepted as the standard program for making just about any documents in the Excel format. Once you have access to the program, then here’s what you’ll need to do:

  • Open up Excel.
  • Click on the “File” tab and select “New”.
  • From here, choose whether you ‘ll start from a blank document or if you would like to use a family tree template.

You may use other alternative Excel programs should you not have access to Microsoft Excel. Just know that the process for creating the document will most likely differ.

2. Create your family tree: Now that you know how to use Microsoft Excel to create one, you still have to put in the information it needs. So here are the things that you’ll need to do:

  • Make use of the tables and graphs: Since you’ll be using Excel, you’ll want to utilize the tools at your disposal to help you create a proper family tree. Organize each family member in the order that they’re supposed to be presented and place them in the spreadsheet table accordingly.
  • Cover all of the people that you’re supposed to: If you’re looking into making a family try that covers until a particular generation of your family history, then that most likely means a large number of names that you’ll need to include. You have to make sure that you don’t miss out on even one person as that could potentially lead to confusion, especially if you miss someone who had important ties with other family members.

Tips for Making a Family Tree

  • Place pictures of family members: If you want to make your family tree look more presentable, then it’s highly advised that you include pictures of each family member. It’s best that you use high-quality photos so that family members can be easily identified.
  • Always check to see that you have all the right information: You want to avoid mistakes when it comes to your family history. Be sure to go through the names of each person in the tree, as well as other important information such as the dates or their relations with one another.

Types of Family Trees

  • Children’s Family Tree
  • Blended Family Tree
  • Basic Family Tree
  • Detailed Family Tree
  • Modern Family Tree
  • Extended Family Tree
  • Adoptive Family Trees

We have more information on family trees and how to make them. All you have to do is to visit our site and search for those articles with the information you need.

Family Tree FAQs

Is there a limit to the number of people I can put into the family tree?

Although there is no limit to how many you can place, you want to make sure that you can fit them all into the document. You may just have to make separate sheets or you can just focus on a particular generation to guarantee that everything fits into one sheet.

What if I can’t find anything on my family’s history?

If the internet cannot help you, then you’ll have to directly ask your other family members for help. They will most likely have all of the information you’ll need. Just make sure to compare the information you’ve gathered from different sources to see if there are any inconsistencies.

Use the information this article has presented you to guarantee that you create a family tree that properly covers the history you want it to present.