Someone on The Facebook was looking for an Excel spreadsheet to enter 10 generations of ancestors. The Google did not provide. So I whipped one up.

If you find such a large spreadsheet enticing, you may download one here for your own use.

Nothing fancy in it – no scary macros or any such thing.


  • avatar

    Comment by Niocole — September 15, 2017 @ 7:00 pm

    Thanks – this is a HUGE help in organizing my tree. Much appreciated!

  • avatar

    Comment by Eva Kujawa — May 31, 2020 @ 12:01 pm

    Bless your Heart!!! You are AWESOME!!!

  • avatar

    Comment by John — June 12, 2020 @ 1:43 pm

    🙂 Glad you find it useful!

  • avatar

    Comment by patti davis — February 9, 2021 @ 10:15 am

    Thank you so much! This is going to be quite helpful to me!!

  • avatar

    Comment by John — February 9, 2021 @ 10:18 am

    You are welcome!

  • avatar

    Comment by Paulette — April 28, 2021 @ 1:09 pm

    Thank you so much, John. You’ve saved me hours of frustration!

  • avatar

    Comment by MJ — August 12, 2021 @ 12:38 am

    This is so helpful. Thank you so much!!

  • avatar

    Comment by John — August 12, 2021 @ 11:07 am

    My pleasure! 🙂

  • avatar

    Comment by Bill Bone — October 19, 2021 @ 9:45 am

    Hi John,
    I’m a Leukemia Cancer patient. I have plenty of hand written Genealogy information. . . 7 generations in some family areas.

    I have family members ask me to put it in a Excel format. I ran across your site referencing 10 generations in Excel. Can I use your software on my personal computer or is it online? I would prefer software that can be installed on my computer and I can back up. Your thoughts?

  • avatar

    Comment by John — October 19, 2021 @ 9:52 am

    Hi Bill,
    Yes, the sheet in this blog post is an Excel file that you can download. If you click on the link and look at the top right of the page there, you should see a Download button.

    Then you can make a copy on your own system and edit it there. The file is hosted on Box.com, but I have it set up so you shouldn’t need to login there.

    Best of luck!

  • avatar

    Comment by Tracy — November 28, 2021 @ 5:12 pm

    Hi John,

    This is amazing. Thank you so much for doing this and providing it for others to use. I have recently been tracking my family tree and have traced back 15 generations to around 1100 AD in Wales. Is it possible to add to the spreadsheet to accommodate more gens?

    Again thank you for your generosity,
    Tracy, British Columbia, Canada

  • avatar

    Comment by John — November 30, 2021 @ 9:08 am

    Hi Tracy, Glad you like the sheet!

    You can add to the sheet yourself if you download it, but would take a fair amount of time to expand that another 5 generations. Sorry, I don’t have the cycles to do that right now.

    If you don’t have the Excel skills to add that many generations yourself, you could make a note to the left of each 10th generation person entry to go see another sheet name – then create a new 10 generation sheet that starts with that person as the source person and work back from there. 🙂

RSS feed for comments on this post. TrackBack URL

Leave a comment