How to Create a Family Tree Chart in Excel

Creating a family tree can feel like a huge undertaking, but it’s a rewarding way to connect with your history. While there are dedicated software options, you already have a powerful and flexible tool for the job: Microsoft Excel. This guide will show you several ways to build a visually appealing and organized family tree chart right within a spreadsheet.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

We’ll cover simple drag-and-drop methods for beginners and more structured approaches for larger trees, along with practical tips for keeping your ancestry project neat and scannable.

Why Use Excel for Your Family Tree?

Before jumping into the how-to, it’s worth asking: why Excel? The answer comes down to accessibility and control.

• Nearly everyone has it. Excel is part of the standard Microsoft Office Suite, so you likely already have access without needing to buy new software.
• It’s completely customizable. You have full control over the layout, colors, shapes, and connections. You’re not limited by a template's pre-defined structure, which is perfect for representing complex family relationships.
• It scales with you. You can start with a simple, small tree and expand it over time without hitting a wall. Plus, you can keep your raw data neatly organized in one tab and your visual chart in another.
• It’s easy to share. You can easily save your tree as a PDF to print for family gatherings or email a copy to relatives to collaborate.

Step 1: Gather and Organize Your Family Data

Before you draw a single box or line, the most important step is to collect your information. Creating a simple data table first will save you tons of time later. Open a new Excel sheet, name it "Family Data," and create columns for essential information.

Just think of this as your central database for the project. Every person in your tree should have their own row.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Key Information to Gather:

• Full Name: Including maiden names for clarity.
• Date of Birth: (e.g., YYYY-MM-DD or Month Day, Year).
• Date of Death: If applicable.
• Relationship to You: (e.g., Mother, Father, Paternal Grandmother). This helps you stay anchored as you build the tree.
• Spouse(s): You can list names here.
• Notes: A great place for brief stories, locations, or other details you uncover.

Your simple table might look something like this:

Having this data organized first makes building the visual chart exponentially easier, no matter which method you choose.

Method 1: The Shapes and Connectors Method (Full Custom Control)

This method treats a blank Excel sheet like a canvas. You manually place shapes for each family member and draw lines to connect them. It’s perfect for smaller trees or for those who want absolute control over the layout.

Step-by-Step Instructions:

1. Set Up Your Canvas: Open a new sheet in your workbook and name it "Family Tree Chart." It helps to switch the view to "Page Layout" (go to the View tab > Page Layout) to better visualize the space. You can also turn off the gridlines (View > uncheck "Gridlines") for a cleaner look.
2. Insert a Shape: Go to the Insert tab, click on Shapes, and choose a simple rectangle or oval. Click and drag on the sheet to draw the shape. This will represent one person.
3. Add Information: Right-click on the shape and select "Edit Text." Type in the person's name and key dates (like 'b. 1955'). You can format this text just like you would in any other document (change font, size, and alignment). Under the Shape Format tab, you can change the shape’s fill color, outline, and effects.
4. Duplicate Shapes for Others: Once you have a format you like, just copy and paste the shape (select it, press Ctrl+C, then Ctrl+V) for other family members. This keeps styling consistent.
5. Connect Family Members: Go back to Insert > Shapes > Lines. Choose a connector line (like the "Elbow Connector") to link parents to children. A straight line can be used between spouses.

Pro Tip: Hold down the Shift key while drawing lines to keep them perfectly straight. You can format the lines to be thicker, thinner, or even dotted (a common way to represent a marital relationship versus a direct descendant line).

Pros and Cons of This Method:

• Pros: Highest level of customization, simple interface, and great for visual thinkers. Non-standard family structures are easy to accommodate.
• Cons: Can become time-consuming for large families, as aligning everything perfectly is a manual process. It’s not "smart" - if you move one shape, you have to manually move the corresponding connectors.

Method 2: Using SmartArt Graphics (Quick and Structured)

If the manual shape method sounds tedious, Excel's SmartArt feature is your new best friend. It’s designed to quickly create hierarchy charts, which is exactly what a family tree is.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step Instructions:

1. Insert SmartArt: On a new sheet, go to the Insert tab and click SmartArt.
2. Choose a Hierarchy Layout: In the pop-up window, select the Hierarchy category on the left. An "Organization Chart" is the perfect starting point. Select it and click OK.
3. Add Your Data in the Text Pane: A basic hierarchy will appear, along with a "Text Pane" to its left. If you don't see it, click the small arrow on the left edge of the SmartArt box. This pane is the easiest way to build your tree.

Work your way through your family data, using the Enter, Tab, and Shift+Tab system. Excel will automatically resize, rearrange, and connect the boxes for you.

1. Customize the Look: Once your data is entered, you can easily change the aesthetic. Select the SmartArt, and two new tabs will appear: SmartArt Design and Format. Here you can change colors, apply visual styles (like 3D effects), and switch to a different hierarchy layout to see what looks best.

Pros and Cons of This Method:

• Pros: Incredibly fast and easy to build. Shapes are always perfectly aligned and spaced. Great for a clean, professional look.
• Cons: Can be rigid. Representing divorces, remarriages, or second cousins can be tricky within the strict hierarchical structure. You have less fine-tuned control over the layout compared to the manual shapes method.

Tips for Better Family Tree Charts

As your tree grows, a few best practices can keep it readable and full of life.

Use Color Coding for Clarity

Assign a specific color to different branches of your family. For instance, make all ancestors on your paternal side blue, all on your maternal side green, and in-laws a neutral gray. It instantly tells people which part of the family they’re looking at.

Go Deeper with Comments and Hyperlinks

Your chart doesn't have to be limited to names and dates. You can add more context without cluttering the view.

• Use Comments: Right-click any shape and select "New Comment." You can add stories, occupations, or fun facts that will appear when you hover over the shape.
• Use Hyperlinks: Right-click a shape and choose "Link." You can link to a photo of the person stored in a folder, a Google Doc with their biography, or even a scan of a historical document. This makes your family tree a truly interactive hub of information.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Sharing and Printing Your Creation

Once you're happy with your family tree, sharing it is simple. Go to File > Save As and change the File Type to PDF. This creates a high-quality, universally readable document that's perfect for printing and sharing online. For large trees, you may need to use a professional printing service that can handle oversized paper.

Final Thoughts

Building a family tree in Excel is a perfectly achievable project that combines data organization with creative presentation. Whether you opt for the total control of manual shapes or the structured speed of SmartArt, you can create a detailed and beautiful chart that visually tells the story of your family’s history.

On our team, we believe that bringing data to life shouldn't require steep learning curves. While Excel is fantastic for tasks like this, the experience of trying to visualize connections - whether in families or in business metrics - can often feel manual. Working with data day-in and day-out is why we built Graphed. When you're ready to switch from visualizing personal history to analyzing business performance, it does the heavy lifting for you. You can connect sources like Google Analytics or your CRM, then just ask in plain English for a dashboard visualizing your sales funnel or ad performance, and Graphed creates it for you in real-time.