How to Make a Family Tree in Excel

Generate My Free Template Blog Templates Blog Templates in word Blog Templates in google-docs Blog Templates in pdf Blog Templates in illustrator Blog Templates in pages Blog Templates in psd Blog Templates in publisher

Jan 09, 2023

Most people would list family as one of their top priorities in life. Some take their heritage or genealogy seriously enough to map out an entire family tree. Most family tree diagrams stop at the third generation; but some can go as far down as the fourth or fifth generations. If mapping out your family history is one of your goals, you can create one that’s both simple and quick with the use of pre designed Excel templates. This tutorial guide will walk you through the basics of creating and customizing your own family tree!

SUMMARY:

For Windows: Click the New document icon. Type in ‘family tree’ in the search bar. Choose a template from the selection and click Create.
For Mac: Go to New, then type ‘family tree’ in the search bar. Pick a template and click Create.

How to Make a Family Tree Using Templates in Microsoft Excel

To customize your own family tree for posterity, it would definitely be more convenient to use an existing template. Microsoft Excel offers ready-made templates for you to use. Follow the steps below to get started.

1. Open Microsoft Excel, and click New on the menu bar on the left. Type in ‘family tree’.

New

2. Pick a template and click Create.

Family Tree Template

3. You can keep the title or change it by clicking the cell then editing the text inside. Feel free to remove or add persons in your family tree. Click on the box to add or remove ancestors, as seen in the sample template below. In every box, input each family members’ names and birth year.

Family Tree Diagram

4. To add images for each family member, simply select and right click the headshot. Click Change Picture to upload a photo from your computer or an online source.

Family Tree Excel Spreadsheet

5. The sample template below features artwork of a tree. You can replace the photo by right clicking it and selecting Change Picture from the menu.

Printable Family Tree Template

6. After editing, save your Excel file. You may choose to share and print it to other members of your family.

Note: Microsoft Office only has limited family tree templates in Excel, be sure to check out Template.net for more designs.

How to Create a Family Tree for Mac Using Microsoft Excel

Learn how to create a basic family tree with this quick tutorial for Mac users. By using a predesigned template, you’ll be able to come up with a family tree more quickly and efficiently.

1. Select the New document icon, then type ‘family tree’ in the search bar. Pick a template and click Create.

Family Tree Template Excel for Mac

2. Edit the title or leave it as is. Insert the names of your family members in the boxes provided. Add or delete boxes, as needed.

Family Tree Excel Template

3. Feel free to change the image of the tree as well. To replace the image, select it then right click. Click Change Picture and upload your own photo.

Sample Family Tree