In this article:

Free Family Tree Template for Google Sheets (2024 Update)

May 8, 2024

Google Sheets Family Tree Template

A family tree template for Google Sheets is useful for organizing genealogical information, preserving family history, and fostering connections across generations.

Access our free family tree template for Google Sheets here.

google sheets family tree template

How to Make a Family Tree on Google Sheets

Follow the steps below to make a family tree template for Google Sheets. 

1. Make a Copy of the Template

Please do not request edit access. To make a copy, go to 'File' and select 'Make a copy’.

family tree template google sheets

2. Open Your Family Tree Template

Start by opening the Google Sheets family tree template. This template includes placeholders like "First Middle Lastname" that you'll edit to fit your family tree.

google sheets family tree

3. Edit Text Placeholders

Click on a cell with placeholder text, such as a name you want to update. Type the real name of your family member over "First Middle Lastname."

how to make a family tree on google sheets

4. Select Cell for Photo

Choose the cell where you'd like to add a photo, typically near the family member's name. Click on it to select. With the cell selected, go to the menu and navigate to "Insert" > "Image" > "Image in cell". Then, select the photo file from your computer. It will resize to fit the cell.

5. Continue Adding Information

Repeat the steps for each family member you want to include in your tree. Replace placeholders with their names and insert photos in the corresponding cells.

7. Review and Customize

After adding all necessary information and photos, review your family tree. Make any necessary adjustments to names, photos, or the overall layout to ensure it looks good.

8. Share or Print Your Family Tree

You can share your completed family tree directly from Google Sheets with other family members or download it as a PDF/print it for a physical copy.

We hope that you now have a better understanding of how to make a family tree on Google Sheets and use our Google Sheets family tree template. If you enjoyed this article, you might also like our article on our free nonprofit budget template for Google Sheets or our article on our free Google Sheets meeting agenda template.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->