This tool is solely intended to assist you in finding matches.
The same privacy obligations of the source apply to the personal or DNA information processed and displayed here.
This script allows you to find STR matches within public FTDNA projects.
Developed by Hunter Provyn with input and support from YSEQ / Thomas Krahn.
1. Load Project Samples
Load multiple FTDNA projects, multiple YSEQ projects and multiple YFULL samples
Loading an FTDNA project deletes previously loaded YSEQ projects
Haplogroup Administrators 1. Download Classic Results 2. Google Drive Spreadsheet -> Import -> Upload (check NO for autoformat numbers and dates) 3. Copy paste entire sheet into field below – (ctrl a), and copy paste (ctrl c), (ctrl v)
Non-Administrators 1. Open Classic Results of a Public Y-DNA Project in your browser (Firefox or Chrome) 2. Copy paste this into Google Drive Spreadsheet 3. Copy paste entire sheet into field below – (ctrl a), and copy paste (ctrl c), (ctrl v)
Tip: For projects displayed over multiple pages, increase the page size to 1000 or 5000 or whatever is necessary to load them all at once.
Note: For multiple project import, it will be necessary to change the header rows to be in the same order (easy through Google Sheets). A standard set of headers (before the STRs) are “Kit Number”, “Name”, “Paternal Ancestor Name”,”Country”, “Haplogroup”
The following formats are supported
Kit Number (prepend YSEQ samples with “YSEQ”)
STR label-value pairs (separated by space): DYS385 12-13 DYS393 15
STR values (separated by tab): 12 13 14-14 (useful for copying STR values from a row of an FTDNA project table)
Matches are ranked according to the log sum of their deviating mutations, weighted by each STR’s mutation rate (thanks David Vance for mutation rates).
For matching alleles, a color code shows the in-project rarity for the shared value.