Free templates

Free DNA Genealogy Templates: Download Excel & PDF Worksheets

Welcome to Genetic Voyage, your go-to resource for DNA genealogy tools! Download our free DNA templates in Excel (XLSX) format to map your DNA segments, track matches, and trace your ancestral origins. Each template is branded with the Genetic Voyage logo and includes fields for countries (e.g., France, UK, USA) and surnames to connect your DNA to your family tree. Perfect for beginners and expert genealogists alike!

Why Choose Our Templates?

User-Friendly: Designed for easy use in Excel with color-coding (green #4CAF50 for paternal, brown #8B4513 for maternal, blue #2196F3 for triangulated, grey #808080 for unknown).
Geographic Tracking: Add countries and surnames to link DNA to ancestral regions.
Professional Design: Branded with Genetic Voyage logo for a polished look.
GDPR-Compliant: Your data is protected. See our Privacy Policy.

Download Our Free Templates

1. Chromosome Mapping Template

Purpose: Map up to 100 DNA segments across chromosomes (1–22 + X/Y) to distinguish maternal and paternal lines.
Features: Color-code segments (paternal, maternal, triangulated), track countries (e.g., Sweden), and surnames.
Formats: Download Excel
Example: Map a 20 cM segment on chromosome 3 from JaneDoe123, linked to Yorkshire, UK.

2. DNA Cluster Analysis Template

Purpose: Organize DNA matches into clusters based on shared DNA segments to identify common ancestral lines, using tools like GEDmatch or MyHeritage AutoClusters..
Features: Track potential cluster groups, Color-code by status (triangulated, potential).
Formats: Download Excel
Example: Group JaneDoe123 and JohnSmith456 on chromosome 3, linked to Yorkshire, UK.

How to Use the Templates

Download: Click the link “Download Excel” to start the download the XLSX versions.
Excel (XLSX): Open in Excel or Google Sheets. Use filters, dropdowns, and conditional formatting for easy analysis. Insert data from GEDmatch or FamilyTreeDNA.
Tips: Start with large segments (>10 cM). Use DNA Painter to verify relationships. Add countries and surnames to trace origins.

Contact Us

Have questions about the templates or ideas how to improve them etc? Email us at geneticvoyage@hotmail.com or visit our Contact Page.