10 Generation Excel Family Tree Chart - Currach

Feb7

21 Comments

10 Generation Excel Family Tree Chart

Posted in: Technology

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.

21 Comments

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

Thanks – this is a HUGE help in organizing my tree. Much appreciated!
Comment by Eva Kujawa — May 31, 2020 @ 12:01 pm

Bless your Heart!!! You are AWESOME!!!
Comment by John — June 12, 2020 @ 1:43 pm

🙂 Glad you find it useful!
Comment by patti davis — February 9, 2021 @ 10:15 am

Thank you so much! This is going to be quite helpful to me!!
Comment by John — February 9, 2021 @ 10:18 am

You are welcome!
Comment by Paulette — April 28, 2021 @ 1:09 pm

Thank you so much, John. You’ve saved me hours of frustration!
Comment by MJ — August 12, 2021 @ 12:38 am

This is so helpful. Thank you so much!!
Comment by John — August 12, 2021 @ 11:07 am

My pleasure! 🙂
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?
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!
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
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. 🙂
Comment by Elaine — April 27, 2022 @ 9:53 pm

Hi John,
I have been looking for a 10 generation excel family tree spreadsheet for quite some time and am thrilled to find this one. Thank you so very much! You have saved me a ton of time, and now I can get on with adding family members.
With much gratitude,
Elaine in Ann Arbor, MI.
Comment by John — April 28, 2022 @ 11:17 am

Glad you find it useful, Elaine! 🙂
Comment by Carolyn — June 4, 2023 @ 3:24 pm

Wow! Thank you. This is not a small thing you did! Sharing it with us for free, you have blessed us, but no doubt you will be blessed to for your selfless act of kindness.
Comment by John — June 7, 2023 @ 11:27 am

My pleasure! 🙂
Comment by Aviva — October 12, 2023 @ 8:48 pm

Thanks for this, I am getting started with recording our tree digitally. Stupid q, but I’m not sure how to input the info?
Comment by John — October 12, 2023 @ 8:57 pm

Hello! You’ve probably seen that the link takes you to the file shared on Box.com – you have to download it there and open it in Microsoft Excel to edit.

If you don’t have Excel, you should be able to upload the file to Google Docs and open it there, although I haven’t tested that. It is a pretty simple file so I’d expect it to work fine, but sometimes Google formats Excel files a little weirdly.

Good luck! 🙂
Comment by Aviva — October 12, 2023 @ 9:23 pm

Thank you! Got it!
Comment by Stephen — April 16, 2024 @ 8:44 pm

Nice work, John. I appreciate your generosity in posting it for free distribution.
Comment by John — April 17, 2024 @ 11:20 am

My pleasure, Stephen! Always happy to help out the genealogy community. 🙂

RSS feed for comments on this post. TrackBack URL

Leave a comment

Return to the Homepage