I’ve been wanting to celebrate my ancestors’ birthdays for some time now, and I’ve finally figured out exactly how to accomplish this goal in a really fun way.
Being reminded once a year about their birthday and the anniversary of their death reminds me to work on their genealogy, and in particular, genetic genealogy. With more people testing every single day, meaning different people at every vendor, we need to check often with specific ancestors in mind. You never know who’s going to be the person who puts the chink in that brick wall.
With this in mind, I’ve put together a spreadsheet to track what I know about each ancestor. This makes it easy to schedule those dates in my calendar, with a reminder of course, and then to check my spreadsheet to see what information might have been previously missing that might be able to be found today.
It’s like a birthday present for them, but now for me. I am, after all, their heir, along with the rest of their descendants of course! If I’m lucky, I inherited part of their DNA, and if not, their DNA is still relevant to me.
Checking the List
Here’s my spreadsheet checklist for each ancestor:
- Birth date
- Birth place
- Death date
- Death place
- Y DNA haplogroup (if male)
- Mitochondrial DNA haplogroup
- Autosomal confirmed
- Ancestry Circle
New information becomes digitized every year making new information available.
Additionally, some items may change. For example, if a base haplogroup was previous known, a deeper haplogroup might be available a year later if someone has taken a more detailed test or the haplogroup name might have been updated. Yes, that happens too.
I originally had a triangulation column on the spreadsheet too, but I pretty quickly discovered that column was subject to lots of questions about interpretation. Is the actual ancestor triangulated, or the line? I decided that “autosomal confirmed” would suffice to cover whatever I decide constitutes confirmation and a comment column could hold the description. For example, my grandparents are autosomal confirmed because I match (and triangulate) with cousins who are descended from ancestors upstream of my grandparents. If my grandparent wasn’t my grandparent, I wouldn’t be related to those people either. In particular, first cousins.
I also added an “Article Link” column to paste the link to that ancestor’s 52 Ancestors article so I can quickly check or maybe even provide this spreadsheet to a family member.
Here’s an example of what the first several entries of my Ancestor Birthday Spreadsheet look like.
Ancestor Birthday Presents for You
In order to remind myself to check on my ancestors’ status, on their birth and death days, I schedule reminders in my phone calendar. Every morning when I wake, I’m greeted by my ancestor – well – at least this much of them.
- First, I check at Family Tree DNA for new matches, haplogroups and the presence of my family lines in surname projects.
- Then it’s off to Ancestry to see if I have any new green leaf DNA or record hints, to add or update the circle for this particular ancestor, and to see if any of my matches would be a candidate for either Y or mitochondrial DNA testing, assuming they reply to messages and agree to test at Family Tree DNA. I keep a separate spreadsheet of each person that I’ve identified as a match with an identified ancestor. I know it’s extra work, but that spreadsheet is invaluable for determining if the ancestor is autosomal proven and if the match is a candidate for Y or mtDNA testing.
- Then I get another cup of coffee and check at MyHeritage for new record matches for that ancestor, along with new DNA SmartMatches.
- GedMatch and 23andMe aren’t as easy to check for matches specific to ancestors, but I still check both places to see if I can find matches that I can identify as descending from that ancestor.
- While I’m at it, sometimes I run over to FamilySearch to see if there’s anything new over there, although they don’t deal with DNA. They do, however, have many traditional genealogical records. I may add another column to track if I’m waiting for something specific to be digitized – like court minutes, for example. FamilySearch has been on a digitization binge!
- As I go along, I add any new discovery to my genealogy software and my Ancestor Birthday Spreadsheet as well.
- Last, I paint new segment information from Family Tree DNA, MyHeritage, GedMatch or 23andMe at DNAPainter. My three articles about how I use DNAPainter are here, here and here.
I just love ancestor birthdays.
Any day that I get to find something new is a wonderful day indeed – fleshing out the lives, history and DNA of my ancestors. With this many places to look, there’s seldom a day that goes by that I don’t discover at least something in my ancestor scavenger hunt!
Ancestor birthday presents for me😊
I receive a small contribution when you click on some of the links to vendors in my articles. This does NOT increase the price you pay but helps me to keep the lights on and this informational blog free for everyone. Please click on the links in the articles or to the vendors below if you are purchasing products or DNA testing.
Thank you so much.
DNA Purchases and Free Transfers
- Family Tree DNA
- MyHeritage DNA only
- MyHeritage DNA plus Health
- MyHeritage FREE DNA file upload
- 23andMe Ancestry
- 23andMe Ancestry Plus Health
- Legacy Tree Genealogists for genealogy research