19 October 2021

This New Template Charts 5 Generations

Even after finding the Family Tree Generator Excel template, I needed another template. You see, the Excel template works best when you already know the names of the eldest generation. But while researching, you often know only the youngest generation.

When I research someone else's family, I create an Excel chart to keep track of their ancestors as I find them.

It was confusing—and a hassle—to build that chart from scratch each time. So I made my own Ancestor Chart template in Excel. It starts with the main person at the bottom, center. (The center is way over in column AH.) It has "father" and "mother" placeholders for five generations of ancestors. It goes all the way back to the main person's 3rd great grandparents.

This new template is perfect for use while researching an unrelated family tree.
This new template is perfect for use while researching an unrelated family tree.

Each generation is color-coded. Plus, the first column always tells you which generation is which. As you're researching, replace "father" or "mother" with the full name of the ancestor you've found.

I do more than keep track of my research in a spreadsheet like this. I give the finished chart to my client so they can visualize their ancestry. It's so helpful when they're reviewing the documents, translations, and explanations I provide.

This template is very wide, but you can print it if you like. Set your printer to landscape mode and this tree will span six pages.

Imagine using this template to work up from your DNA match until you reach your own ancestor.
Imagine using this template to work up from your DNA match until you reach your own ancestor.

Keep in mind that the main person doesn't have to be living. Often it's my client's grandparent or great grandparent. You can use this template to visualize any particular branch of a family. You can duplicate the chart to make separate trees for a husband and wife.

Download your copy of the file from Dropbox and let me know how you've used it. If you don't have spreadsheet software, you can copy and use this Google Sheets version of the same template.

2 comments:

  1. You are so generous! Thank you!

    ReplyDelete
  2. Thank you! I've been looking for something to do just this very thing!

    Have a blessed day. :)

    ReplyDelete