Free templates
Free Genealogy Templates & Excel Worksheets
Purpose-built spreadsheets for organizing DNA matches, chromosome segments, relationship hypotheses, haplogroup research, endogamy, correspondence, and traditional genealogy research.
| Match | cM | Segments | Shared Match Group | Status |
|---|---|---|---|---|
| Match A | 184 | 7 | Cluster 01 | Reviewed |
| Match B | 96 | 4 | Cluster 01 | Follow up |
| Match C | 72 | 3 | Cluster 03 | Reviewed |
| Match D | 41 | 2 | Cluster 03 | Research |
| Match E | 28 | 1 | Cluster 07 | Logged |
Research tools you can actually work with
DNA genealogy generates a lot of information. These templates give that information a structured place to live while you investigate your research questions.
Keep your research organized without locking it into one platform
Use the spreadsheets to record evidence, compare matches, map chromosome segments, track hypotheses, document correspondence, and keep research decisions visible over time. The templates are designed to complement your existing genealogy and DNA services, not replace them.
Choose a template by research task
You do not need to understand all eight templates. Start with the problem you are trying to solve.
I need to organize DNA matches
Keep match information, relationships, notes, and follow-up work in one structured place.
DNA Match Tracker →I need to map chromosome segments
Record chromosome locations and build a structured view of your segment research.
Chromosome Mapping →I need to organize DNA clusters
Turn groups of related matches into a researchable structure you can annotate and investigate.
Cluster Analysis →I need to explore a relationship hypothesis
Record shared cM information and compare possible relationship paths as part of your research.
Shared cM Predictor →I need to document triangulation
Keep track of people, chromosome segments, positions, and triangulated groups.
Triangulated Group →I am losing track of my research
Record searches, sources, correspondence, unanswered questions, and next steps.
Research Log →Explore the 8 free genealogy templates
Download the spreadsheet when you are ready to work with it, or open the accompanying guide first if you want to understand how to use it.
Chromosome Mapping Excel Template
Organize chromosome segment information and build a structured record of where DNA matches overlap across your research.
DNA Cluster Analysis Excel Template
Record and analyze groups of DNA matches so that cluster patterns can become part of a broader research hypothesis.
DNA Match Tracker Excel Template
Keep your match information organized instead of relying on scattered notes, screenshots, or memory.
Triangulated Group (TG) Excel Template
Document people who share overlapping DNA segments and keep the evidence associated with each triangulated group together.
Shared cM Relationship Predictor
Record shared centimorgan values and use relationship ranges as one component of a broader genetic genealogy investigation.
Y-DNA & mtDNA Haplogroup Tracker
Keep direct-line haplogroup information organized alongside people, ancestral lines, testing information, and research notes.
Endogamy & Pile-Up Region Log
Document regions that may require additional care when interpreting shared DNA in populations affected by endogamy or recurring ancestral connections.
Research & Correspondence Log
Create a central record of searches, sources, correspondence, discoveries, unanswered questions, and next research steps.
How the templates fit into a research workflow
You do not have to use every template. Combine the ones that match the question you are investigating.
A template organizes evidence — it does not create evidence
These spreadsheets are research aids. They do not automatically prove a biological relationship, identify an unknown ancestor, establish that a segment is IBD, or determine that a match is genuine or false. Interpret the information alongside your other genetic, genealogical, and documentary evidence.
Use the spreadsheets as a research record
Separate evidence from conclusions
Record what you observed before recording what you think it means. This makes later review much easier.
Keep uncertainty visible
Use notes and status fields to distinguish confirmed information from working hypotheses and items that still need investigation.
Return to the research question
A well-organized spreadsheet is most useful when every observation helps answer a specific genealogical question.
Frequently asked questions
Are all of these templates free?
What software do I need?
Which template should a beginner start with?
Can I use more than one template?
Are the templates tied to one DNA testing company?
Can I customize the templates?
Do the templates automatically determine relationships?
Where can I find other GeneticVoyage resources?
Turn scattered research into a structured investigation
Choose the template that matches your current research question, download it, and adapt it to the way you work.
Explore All 8 Templates