Make Family Tree in Excel  Step by Step Guide ▷ 2020

The family trees are very useful tools that can be used to unite the family and understand the origins of each person. With Excel you can create these types of graphics in a simple way.

You will have the possibility to use different functions that will help you to establish the evolution of your ancestors with quick steps. For example, you can use SmartArt as a good option.

If you want to become an expert in custom creation of a family treePay attention to the following paragraphs of this article. We will teach you the steps you will do with each of the available tools.

What Excel tools are useful for creating a family tree?

For create a family tree you will have to use tools that you can find in the function “Shapes”. In this group you can use circles, rectangles, lines and any other figure to help you unite the different levels.

In addition, you can use “SmartArt”. Especially the “Hierarchy” category, with which you will be able to quickly and easily introduce the different members of the genealogical line.

To the above you can add predesigned images that you will have to download from the Internet or search for them from your computer. In this way, you can give it a certain background, be it a familiar image or whatever you like the most. This will make your family tree have a custom design.

Finally, you will be able to use predesigned templates that you can find them in the menu “Archive” Microsoft Excel, as well as you can download them from the Internet. If you want to know where you can find them, don’t worry, because in the paragraphs that follow we will offer them to you for free.

Steps to create a family tree in Microsoft Excel fast and easy

The steps you must do to create a family tree using different Excel tools can be found below:

With a template

With a template

To use a template you will have to follow this guide:

  • Find the tab “Archive” and click on it.
  • Go to option “New”.
  • You will find the right of options panel, a bar to search for different templates. Writes “family tree” and click on the magnifying glass.
  • You will see a listing with different templates, choose the one you like the most by clicking on it.
  • Then click “Create”.
  • A new spreadsheet in which you can edit all the data in a simple way.

With SmartArt

With SmartArt

Follow these steps to create a family tree with SmartArt:

  • Click on the menu “Insert” find the function “SmartArt” Within the group “Illustrations”.
  • When you have clicked on it, will open a window in which you must go to the category “Hierarchy”.
  • Choose the graphic that you like the most and that suits your needs.
  • Once you have the smart drawing in spreadsheet you can edit it quickly by adding or removing elements.

With basic shapes and figures

To create a family tree in Excel with basic shapes and figures you will have to follow these steps:

  • Choose “Illustrations” and later “Shapes”.
  • A pop-up window will be displayed in which you can find different types of objects, classified by categories. Choose the shape “Rectangle” and with the mouse locate it in an area of ​​the spreadsheet.
  • Modify the fill or outline style color by right clicking on the figure. Choose the option “Shape format …” and choose the aspects that interest you the most.
  • Do this same step several times until you have all members of the family. Or, a shorter step would be to copy and paste the edited rectangle as many times as necessary.
  • When you have the levels you’re going to have to join them with lines. To do this, you will have to follow the step of add a shape, as we show you with a rectangle.
  • Once you have the previous steps ready, you will have to select all the shapes by pressing the key “Ctrl” and select them with the mouse. Next, you will have to right click and choose the option “Group”. This will allow you to move and resize the tree as a whole.

List of the best templates to make a family tree in Microsoft Excel

We will show you the best templates that you can use to create a family tree in Excel in a quick way for you to become a professional.

Some of them are:


With this template you can put all your family members by adding photos and details for up to 5 generations. His design horizontal allows a broader view of the evolution of the different stages of the family.

Download Detailed Model

Family Tree Photos

You will have the possibility to include photos of each of the members who occupy the different generations of the family. Like the previous template, it is also found vertical way standing out a nice graphic design of a tree in a rural area. You can add different characteristics of each person in a simple way.

Download Family Tree of Excel Photos


its minimal look and design offer the reader a very simple to read, since they can add a good number of people that make up the genealogical tree. It stands out for a soft green color, but if you prefer you can modify it for any other that is to your liking. You will not be able to include images in this template due to its limited space.

Download Simple Excel Model


You will be able create a family tree based on tables that will include up to 3 generations of a family. It is characterized by having a dynamic design with colors that allow you to modify the references to include multiple marriages. At header of this template you will find a graphic of a tree, but you can change it for another design.

Download Modern Excel Model

Editable template

In this complete template you can and modify and add members of your family in a very simple way. This is because the design it presents allows that with a few steps you can incorporate the names of the different people and the degree of kinship.

Download Editable Excel Template

If you have any questions, leave them in the comments, we will answer you as soon as possible, and it will also be of great help to more members of the community. Thank you! 😉

You may be interested:

Rate this post

Leave a Comment