How to Make a Family Tree in Microsoft Excel
Share your family stories for free
Microsoft Excel is one of the most versatile data visualization tools available today. It can be used to create easy-to-understand charts, graphs, and diagrams — including family tree charts. Since Excel is so widely used, it’s the perfect way to create your own family tree.
In this article, we’ll explain how to make a family tree in Excel.
How to Make a Family Tree Chart in Excel
There are two easy ways to make a family tree chart in Excel. You can use a pre-made family tree maker template from Microsoft, or create your own family tree from scratch. There are also dozens of additional free family tree templates available online to meet your needs.
The easiest way to make a simple family tree diagram is by using Microsoft’s built-in family tree templates. The simplest of these is the Family Tree Generator. To use this template:
FreePowerPoint Templatesprovides a template that lets you create a six or seven-generation family tree, meaning you can add great-grandparents and even great-great-grandparents. This is much more powerful than Microsoft’s template and allows you to add additional information to create an in-depth genealogy chart.
To use this template:
If you want to create your own free-form family tree, it’s fairly easy. It might not look as nice as the family tree examples shown above, but it’ll be sufficient — especially if you just need a starting point for some basic genealogical research and you don’t need added functionalities.
Share Family Stories for Free
Don’t forget, if you don’t have access to Microsoft Excel, you can use the web version of the app (orGoogle Sheets) for free to create an online family tree. This is even easier to share with your family and will help you easily visualize and share your family history.
Jake Harfield is an Australian freelance writer whose passion is finding out how different technologies work. He has written for several online publications, focusing on explaining what he has learned to help others with their tech problems. He’s an avid hiker and birder, and in his spare time you’ll find him in the Aussie bush listening to the birdsong.Read Jake’s Full Bio
Welcome to Help Desk Geek- a blog full of tech tips from trusted tech experts. We have thousands of articles and guides to help you troubleshoot any issue. Our articles have been read over 150 million times since we launched in 2008.
HomeAbout UsEditorial StandardsContact UsTerms of Use
Copyright © 2008-2024 Help Desk Geek.com, LLC All Rights Reserved
