Picture this: You’ve got over 10,000 DNA matches on one parent’s side of the family. Only a couple really stand out as ones you know while the rest are a mystery. How do you sort these matches out? How do you organize them?
I realized there are different ways to organize or cluster them into groups, manually and using automation. To summarize best what these ways are, I refer you to this blog post I found on Family Locket.
Not mentioned in the Family Locket blog post is the AncestryDNA dot system which I learned about in the DNA Skills workshop (link here). This blog post by Your DNA Guide should give you an idea of how that works. While the AncestryDNA dot system does help identify clusters of matches sharing a common ancestor or ancestral couple, visualizing them is limited to just the DNA testing company’s website.
I tried the Leeds Method and was excited about being able to create a Google Sheets spreadsheet that could be incorporated with the rest of my Google Drive genealogy content. I liked the idea that I could also use the method using Ancestry’s Colored Dots but found this visually confusing when DNA matches sharing DNA with more than one color group created what is called overlap.
Looking at the automated clustering options described in the Family Locket blog post, I didn’t care for visualizing DNA connections in a matrix within a chart. It was too much, too fast, especially when I really enjoy the process of manually separating DNA matches into clusters.
After considering all of the above methods, I decided to start with using Ancestry’s Colored Dots to sort DNA matches into groups or clusters sharing a common ancestor couple. I then worked on figuring out how I could create a DNA research log for DNA matches.
Although I liked Family Locket’s Airtable approach to organizing and managing DNA matches, I admit I’m not a big fan of Airtable. I’m more into Google Sheets. So, I created Google Sheets spreadsheet templates, one for paternal DNA matches and one for maternal DNA matches, taking only the aspects I liked from Family Locket’s Airtable approach but making them more to my liking.
My templates are a different way of logging DNA match research. I name them DNA Ancestry Match Paternal Grandparent Groups Template and DNA Ancestry Match Maternal Grandparent Groups Template. Each template has these key features:
- Tabs created for each grandparent: Grandparent couples are separated into different tabs such that you can see which common ancestors specifically are shared amongst your DNA matches.
- Colors used are tied in with colors chosen for Ancestry’s Colored Dot groups or clusters.
- First column is frozen for ease of navigating the spreadsheet.
In summary. . .
There are different methods used to organize DNA matches. Like managing genealogy research in general, you have to determine what works best for you and fits in with your workflow.
