Sunday, June 25, 2017

How to Visualize Your Ancestor-Finding Progress

I've seen lots of graphics lately showing how many direct ancestors we each have. Two parents, four grandparents, eight great grandparents, etc. It adds up fast!

Since I've been lucky enough to find a handful of 5th great grandparents lately, I thought it would be a good exercise to see where I stand.

I made a spreadsheet you can download with placeholders for grandparents in one column, great grandparents in the next column, and so on through 10th great grandparents.

Update: I've made a revised spreadsheet to include color coding for your four basic tree branches: one color for each grandparent. I've also created a row at the top to show how many ancestors you have for each generation.

Then I used my family tree software to create a chart of my ancestors, labeling the generations. I scrolled across my chart and filled in the blanks on the spreadsheet.

My results are mixed. When I identified four of my 8th great grandparents and four of my 9th great grandparents, I couldn't have been happier. But now I can see that they aren't even the tip of the iceberg. They're a crystal of the iceberg!

Color coding the 4 branches helps a lot.
To focus on the plus side, I'm missing only three of my 32 3rd great grandparents. That's pretty good considering they never came to America.

I'm missing 23 of my 64 4th great grandparents. After that, I'm not even counting. Yet.

On the plus side, now I can focus my work on finding as many of the missing "younger" generations as I can. (See "5 Steps to Grow Your Italian Family Tree" and "How I Gained 2 More Generations in 1 Day".)

See what this progress report can tell you about your research!


  1. Is there a way to download your color coded tree - but not to Dropbox?
    Thanks for any help!

    1. Hi, Sunny. On that Dropbox page you can choose to download the file to your computer. IOr, if you want to email me, I can reply with the spreadsheet.


Want to receive email notifications about new posts? Email me at