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!

RSS feed for comments on this post. TrackBack URL

Leave a comment