This is how you can make a family tree in Excel

Microsoft Office spreadsheets can organize information about users’ families. (photo: hiTechMV)

The program of Microsoft Excel has within its functions the ability to offer different templates of data organization that can benefit users in their work, to organize their personal accounts, to establish an agenda, to generate graphs from dataamong other utilities.

However, the spreadsheet also offers a peculiar selection within the varied list of templates: organize a family tree of the users. In this way, people will be able to learn more about the history of their family, discover distant relatives and the ties that unite them.

Within the program Office people can find up to three tree models that have different characteristics and functions which users can access just by making a click.

How to generate a family tree in Excel (Screenshot)
How to generate a family tree in Excel (Screenshot)

How to generate a family tree

Before you can enter data of close relatives and delve more into the ancestors of fathers, mothers and grandparents, users must generate the template that best suits what they want. For this, the following steps must be performed:

– Open the program Microsoft Excel.

– In the initial menu, click on the option New.

– Write Family tree in the search bar templates online. After a few seconds, the options for that activity will appear.

– Click on one of the templates. Currently only three can be found in the system, but more may be added in the future.

– Once a pop-up window indicating some of the specifications of the template. button can be clicked To create or navigate between the options with the left or right arrows on the keyboard.

Detailed family tree

is the template most complete of the three it has Excel to select after searching online. Not only does it offer the organization of the users’ ancestors, but it also offers a tab specifically dedicated to each level of relationship between people.

Family Tree Model in Excel (Screenshot)
Family Tree Model in Excel (Screenshot)

Within the details, you can include the full names, the year of birththe age what do they have, the relationship they have, the date and place of their death. In addition, users have the option to enter the Photos of each person although these do not appear in the tab where the tree updated.

The tree is generated automatically after completing the data in each of the records specific to the members. Special buttons are located in each work area that make it easier for users to navigate between each of the tabs.

photo family tree

This second model is more appropriate for school works of children and young people because, unlike the template passed, it only has one work area and the information is presented in a simple way.

Family Tree Model in Excel (Screenshot)
Family Tree Model in Excel (Screenshot)

Each member of the tree has a predetermined space to locate a Photographyin addition to a Name and a year of birth. At this time there is no detail of a possible date of death.

In this template there are many limitations for the reason of keeping the registration system simple: you cannot add family members past the third generation and the maximum number of children you can have per record is two due to limited space.

family tree generator

Although its appearance is simple, the way it operates is more complex than the previous example. In this templateusers will need to fill in a series of boxes (again with the third generation as a limit) in which spouses can be entered for each son or daughter.

Family Tree Model in Excel (Screenshot)
Family Tree Model in Excel (Screenshot)

This function not only allows to identify the principal line of the family, but also enables users to register more than two children per couple if applicable.

Once the table is completed, click on the button Generate family tree located in the upper right corner of the table. The result will be registered in the tab of Family tree and, in case of needing modifications, they can be made from the original boxes.


How to create formulas without knowing anything about Excel and with artificial intelligence

Excel templates to keep personal finances and not exceed expenses

Excel Live will allow you to share and edit documents online with other colleagues in Microsoft Teams