Updated August 22, 2023
Family Tree in Excel (Table of Contents)
Introduction to Family Tree in Excel
Making Family trees is great fun during our school days and a popular project too. It would be a great idea to present the entire family tree to your relatives and surprise them with the work you did by digging up the roots of your entire family hierarchy. However, though you might be able to dig out the roots, it is equally important to present them visually appealingly. If I tell you, Microsoft Excel has all you need to present your family tree to relatives visually pleasingly. Don’t get surprised; it is possible. Thanks to the rich variety of subjects Excel can touch. In this article, we will see how a Family Tree can generate in Excel from scratch using the inbuilt template provided under Excel.
Examples of Family Tree in Excel
Let us now begin exploring different ways to sum multiple rows in Excel with the help of the following examples.
Example #1 – Creating a Family Tree in Excel from Scratch
Let’s create a simple family tree in Excel from scratch. To do that, follow the steps given below:
Step 1: Open a new blank Excel sheet and click the Insert tab.
Step 2: As soon as you click on the Insert tab present at the topmost ribbon in Excel, you will see a range of operations added under it. Click on the Illustrations option inside. This option will allow you to insert Pictures, Shapes, Icons, etc., under your Excel file. Click on Shapes to see the range of different shapes available to add under the Excel sheet.
Step 3: Navigate through the available shapes and select any that you feel will be good while representing the family tree. I will go on with Rectangle: Diagonal Corners Rounded. Once you select the shape, draw it under your Excel sheet, as shown below.
Step 4: Add the shapes with text as Grand Father and Grand Mother, respectively. These are the roots of our Family Tree. See the screenshot below.
Step 5: Go to Illustrations and select a connector line connecting these two roots.
Step 6: Connect the two shapes with this connector line. You will see it in the screenshot below.
Step 7: You can add the shapes next to both based on the number of children your grandfather and grandmother have. The method for adding the shapes will be the same as in the previous steps. I will add three shapes, as my grandparents have three kids: Ramesh, Subhash, and Usha. See the screenshot below for better visualization.
Step 8: Now, all three kids of my grandparents are married. Therefore, let’s add the names of their wives and husband. Eventually, we are going to add new shapes, which are associated with Uncle Ramesh (his wife), Father Subhash (his wife), and Aunty Usha (her husband). See the below screenshot for your reference.
Mugdha is Ramesh’s wife, Ratna is Subhash’s wife, and Keshav is the husband of Usha.
Step 9: Now, add the kids, each of Ramesh & Mugdha, Subhash & Ratna, and Usha and Keshav. Some more branches are coming.
If you can see the structure now, the tree is as follows:
- Uncle Ramesh and Aunty Mugdha has one daughter Ananya.
- My father, Subhash, and mother, Ratna, have two daughters, Monali & Pooja, and a son named Lalit.
- Aunty Usha and her uncle Keshav have two kids, Vineet and Reha.
In this way, my family tree is completed. We have used basic shapes and some lines to connect all the branches with the roots (Grand-Father & Grand-Mother). This is how we can generate the family tree in Excel through scrap.
Example #2 – Creating Family Tree Using Online Excel Template
We have seen how to create the family tree through a scrap with the help of some built-in shapes in Excel. However, there are ready templates under Excel, using which you can generate and customize the family tree in a few minutes. Let’s see how we can do that.
Step 1: Go to the File menu (present at the leftmost corner) from your Excel ribbon and click on New.
Step 2: As soon as you click on New, you’ll see a range of Excel templates for different purposes. You can always use a search box if the one you are looking for is not visible. Type Family Tree under the search box and hit Enter button/click on the Find option. You’ll see a bunch of templates customized for this purpose.
Step 3: Select the first template and download it so that you can use this template to create a family tree of your own in a jiffy. If you already have downloaded this template, you probably will see an option as Create when you select the template. Click on that option.
Step 4: Once you click the Create button, the template will be loaded under Excel, and you can use it now to make your own family tree.
Step 5: Fill in the details per your requirements in the block of Grand Parents, First Generation Children, Second Generation Children, etc. See the screenshot below, where I have filled in the details for my family.
Step 6: Once you are done filling in the family member names, there is a Create Family Tree button. Click on that button, and Bingo!
Click on this button to create a Family Tree with provided Information; you can see a family tree diagram in the screenshot below.
This is how we can create a family tree with an automated built-in template present under Excel. This is it from this article. Let’s wrap things up with some points to be remembered:
Things to Remember About Family Tree In Excel
- While creating a family tree using a built-in Excel template, make sure you are connected to the internet to download the template from the library. If you are offline, you cannot use the template’s built-in.
- While creating a family tree without any built-in template, you can copy and paste the leaves and branches to save your precious time.
This is a guide to Family Tree in Excel. Here we discuss How to Create a Family Tree in Excel, practical examples, and a downloadable Excel template. You can also go through our other suggested articles-