DNA Cluster Analysis Excel Template
DNA Cluster Analysis Excel Template
Organize DNA matches into research clusters, identify shared connections, and investigate which ancestral family lines may connect your matches.
Preview of the DNA Cluster Analysis Excel Template.
What Is DNA Cluster Analysis?
DNA cluster analysis is a way of organizing your DNA matches according to shared relationships and connections. Instead of examining every match independently, clustering helps you look for groups of matches that may point toward the same ancestral family line.
A cluster can sometimes reveal a group of relatives connected through a particular branch of your family tree. By comparing shared matches, surnames, locations, documented genealogy, and other evidence, you can develop hypotheses about the ancestral origins of a group.
This Excel template gives you a structured place to record those observations and track your research as your understanding develops.
DNA matching results can become difficult to manage when you have hundreds or thousands of matches. Clustering helps reduce that complexity by organizing related matches into groups that can be investigated together.
When a cluster contains several matches who share genetic connections with one another, the group may provide clues about a common ancestral line. Additional genealogical and genetic evidence is then needed to determine what that connection may be.
Who Is This Template For?
- Genetic genealogists analyzing large DNA match lists
- Researchers using the Leeds Method or related clustering approaches
- Genealogists investigating unknown or poorly documented family branches
- Researchers working on unknown parentage or NPE-related genealogy
- Family historians who want a structured way to compare match groups, surnames, and locations
Pre-Formatted Columns Included
The worksheet provides dedicated fields for recording the information you may want to compare while analyzing DNA match clusters:
- Cluster Group ID / Color
- Primary Match Name
- Shared cM & Segment Count
- Shared Ancestral Surnames
- Geographic Locations & Parishes
- Suspected Ancestral Couple / MRCA
- Maternal / Paternal Line Alignment
- Research Status & Action Items
Best Use Cases for This Template
- Organizing results from DNA clustering or AutoCluster analyses
- Applying the Leeds Method to organize matches into research groups
- Investigating which ancestral branches may explain a group of DNA matches
- Cross-referencing shared surnames, locations, and family trees across cluster members
- Tracking unresolved clusters and deciding which matches require further research
- Documenting hypotheses during unknown-parentage or NPE research
Step-by-Step DNA Cluster Analysis Workflow
- Start with a group of relevant DNA matches and identify the matches you want to investigate.
- Record your key matches and available shared-DNA information in the worksheet.
- Group matches according to a clustering method such as the Leeds Method or another appropriate approach.
- Record shared surnames, geographic locations, family-tree information, and other potentially useful clues.
- Compare the members of each cluster to identify possible common ancestral lines.
- Record your current hypothesis, supporting evidence, uncertainties, and next research actions.
Important: A DNA Cluster Does Not Automatically Equal One Ancestral Couple
DNA clustering is a research strategy, not proof of a particular ancestral relationship. A cluster can contain matches connected through different branches, multiple ancestral pathways, or relationships that are not immediately apparent. Use cluster membership as evidence that helps generate and test hypotheses alongside documented genealogy, shared matches, family trees, locations, surnames, and other genetic evidence.
Related Research Guides & Tools
Frequently Asked Questions
Is this DNA cluster analysis Excel template free?
Yes. The template is available as a free .xlsx download from Genetic Voyage.
What is the Leeds Method?
The Leeds Method is a manual DNA match clustering technique that groups matches according to shared-match relationships. It can help researchers identify groups of matches that may represent different ancestral lines.
Can I use this template with AutoCluster results?
Yes. You can use the worksheet to organize and annotate information from compatible AutoCluster or other DNA clustering reports. The exact data available will depend on the tool or service that generated the report.
Does every cluster represent one grandparent line?
No. Clusters can provide useful clues about ancestral relationships, but they do not automatically correspond to a single grandparent, ancestral couple, or family branch.
How many cM should I use when creating clusters?
There is no single cM threshold that works for every clustering strategy or research question. Your useful range depends on the DNA testing platform, the clustering method, the number of available matches, and the type of research you are conducting.
Can clustering help with unknown-parentage research?
Yes. DNA clustering can help organize groups of matches that may belong to different sides or branches of an unknown family. However, identifying an ancestral connection requires additional genetic and genealogical evidence.
Can I use the template in Google Sheets?
Yes. The template is provided as an .xlsx file and can generally be opened in Google Sheets and Apple Numbers. Some spreadsheet-specific formatting or features may behave differently between applications.
DNA Academy - Quick Answers
What formats are your free templates available in?
Our templates are available as downloadable Excel/Google Sheets files (for digital tracking).
How do I use a research log effectively?
A research log helps you track which records you’ve searched, what you found, and what’s still missing. We recommend filling it out as you go, it prevents duplicate searches and helps you identify patterns. Our template includes columns for date, source, location, and findings.
Are the templates available in languages other than English?
Currently, our templates are in English only. We are exploring translations into Swedish, Spanish, and German based on user requests. If you need a specific language, contact us and we’ll prioritize it.