Y-DNA / mtDNA Haplogroup Tracker Excel Template
Y-DNA & mtDNA Haplogroup Tracker Template
Track direct paternal Y-DNA and direct maternal mtDNA results, haplogroups, subclades, tested relatives, and ancestral-line research in one structured genealogy spreadsheet.
Preview of the Y-DNA & mtDNA Haplogroup Tracker research worksheet.
Y-DNA and mtDNA are particularly useful in genealogy because they follow two specific lines through a family tree. Y-DNA follows the direct paternal line from father to son, while mtDNA follows the direct maternal line from mother to child.
Recording these results alongside the people tested, their ancestral lines, and their earliest known ancestors can make it much easier to compare results and preserve your DNA research over time.
Y-DNA vs. mtDNA: What Does Each Test Trace?
♂ Y-DNA — Direct Paternal Line
Y-DNA is passed from father to son and can therefore be used to investigate a person's direct paternal line. It can be especially useful when comparing men who descend from the same paternal lineage, including surname-based research.
♀ mtDNA — Direct Maternal Line
Mitochondrial DNA is passed from a mother to her children. Both males and females inherit mtDNA, but only females pass it on to the next generation. This makes mtDNA useful for investigating the direct maternal line.
Why Keep a Haplogroup Research Log?
Haplogroup results can become difficult to manage when several relatives have tested at different companies or at different levels. A central research log helps you preserve the result, the test information, the relevant ancestral line, and the supporting genealogy in one place.
- Keep Y-DNA and mtDNA results for multiple relatives organized.
- Record haplogroups and subclades as they change or become more refined.
- Connect DNA results with earliest known ancestors.
- Document geographic and surname research alongside genetic results.
- Compare results from different testing companies.
- Create a long-term research record for future family researchers.
Who Is This Template For?
This template is useful for genealogists researching direct paternal or direct maternal lines, family historians comparing relatives' DNA results, and researchers documenting surname or lineage projects.
It can also be useful when several family members have tested and you want a single place to document which person represents which branch of the family tree.
Pre-Formatted Columns Included
The worksheet includes dedicated fields for recording the genetic result together with the genealogical information needed to interpret it:
- Tested Person / Relative Name – Identify the person whose DNA result is being recorded.
- Lineage Type – Identify whether the result represents a direct paternal Y-DNA line or direct maternal mtDNA line.
- Testing Company & Test Level – Record the provider and relevant test type or level.
- Assigned Haplogroup / Subclade – Record the currently assigned haplogroup and more specific branch information when available.
- Terminal SNP or mtDNA Mutations – Record relevant genetic markers reported by the testing service.
- Earliest Known Ancestor – Document the name, dates, and location of the earliest known person on the relevant direct line.
- Geographic Origin & Migration Clues – Record locations and historical clues that may help guide further research.
- Surname Project Notes & Matches – Record relevant surname-project information, matching testers, and research observations.
Best Use Cases for This Template
- Direct paternal research: Track Y-DNA results across male relatives from different branches of the same paternal family.
- Direct maternal research: Document mtDNA results across relatives representing the same maternal-line ancestry.
- Surname research: Compare Y-DNA results with surname projects and documented paternal family lines.
- Lineage verification: Use compatible DNA results as one part of a broader genealogical investigation.
- Family DNA documentation: Preserve test results and haplogroup information for future generations.
- Historical research: Record geographic clues and possible migration patterns as research hypotheses to investigate further.
Important: A Haplogroup Does Not Identify One Specific Ancestor
A haplogroup represents a branch of a much larger genetic family tree. Sharing a Y-DNA or mtDNA haplogroup does not, by itself, prove that two people descend from the same recent ancestor.
More specific subclades can sometimes provide additional information about how closely related two paternal or maternal lines may be, but the appropriate interpretation depends on the test resolution, the specific haplogroup, and the available genealogical evidence.
Geographic associations and migration patterns should also be treated as research clues rather than proof that a particular ancestor lived in a specific place.
Use this template to organize genetic evidence alongside traditional genealogy, not as a substitute for documentary research.
Step-by-Step Haplogroup Research Workflow
- Identify the direct line. Determine whether you are researching the direct paternal Y-DNA line or the direct maternal mtDNA line.
- Record the tested relative. Enter the person's name, relationship, testing company, and relevant test type or level.
- Record the genetic result. Enter the assigned haplogroup, subclade, terminal SNP, or relevant mtDNA information.
- Document the genealogy. Add the earliest known ancestor, dates, locations, and source information for the relevant direct line.
- Compare family results. Review results from other relatives who represent the same direct paternal or maternal line.
- Investigate additional clues. Use surname projects, genetic matches, geographic records, historical sources, and other genealogy evidence where appropriate.
- Update the research record. Add new subclades, test results, discoveries, and unresolved questions as your research develops.
Frequently Asked Questions
What is a haplogroup?
A haplogroup is a branch of a genetic lineage defined by specific genetic markers. Y-DNA haplogroups describe branches of paternal lines, while mtDNA haplogroups describe branches of maternal lines.
What does Y-DNA trace?
Y-DNA follows the direct paternal line because the Y chromosome is passed from father to son. This makes it particularly useful for investigating paternal ancestry and, in many cases, surname-related research.
What does mtDNA trace?
mtDNA follows the direct maternal line. Both males and females inherit mitochondrial DNA from their mother, but only females pass it to their children.
Can two people with the same haplogroup be closely related?
They can be, but sharing a broad haplogroup does not establish a recent relationship. Depending on the haplogroup and test resolution, people may share a common ancestor many generations or even thousands of years apart.
Why should I record the test level?
Different tests provide different levels of resolution. Recording the test type helps you understand how much genetic information was available when interpreting a haplogroup or subclade assignment.
What is a terminal SNP?
In Y-DNA research, a terminal SNP is a mutation that helps define a person's position on the Y-DNA haplotree at the level identified by the test. More advanced testing may identify a more specific branch as additional information becomes available.
Can haplogroups prove where my ancestors lived?
Not by themselves. Haplogroup distributions and geographic associations can provide useful historical clues, but establishing where a specific ancestor lived requires additional genetic, historical, and genealogical evidence.
Should I update the spreadsheet when a haplogroup changes?
Yes. Haplogroup assignments can become more specific as additional testing and new branches are identified. Keeping the spreadsheet updated helps preserve the development of your research over time.
Ready to Organize Your Haplogroup Research?
Download the free Y-DNA & mtDNA Haplogroup Tracker and keep your direct paternal and maternal DNA research organized in one place.
📥 Download the Free Haplogroup TrackerDNA 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.