What problem does LivingDNA: Download Shared Matches as CSV solve?
LivingDNA: Download Shared Matches as CSV adds a Download CSV button to each match’s profile on LivingDNA that saves every relative you share with that match to one CSV file. Shared matches show which side of your family a match is on, and LivingDNA has no way to save the list.
How does LivingDNA: Download Shared Matches as CSV work?
The button sits at the right end of the heading over the shared matches, lower on a match’s profile page. One click saves the whole list, so you do not have to page through it. Nobody is missed when the list has several pages.
A progress window counts the shared matches saved so far out of the total, and the tab title shows the same count. Cancel Download stops early and still saves those collected up to that point. When it finishes, a Download Complete window says how many were saved.
Every row also names the match whose profile you downloaded from, in the Also Matches and GUID of Match columns. You can download the shared matches of several matches, combine the files in one spreadsheet, and still tell which of the downloads each row came from.
The file name holds your name and test barcode and the match’s name and barcode, so each file is easy to find again. The file also holds the largest segment and the average segment size (AScM) for each shared match, which the shared matches list on LivingDNA does not show.
How do I use LivingDNA: Download Shared Matches as CSV?
- In the Genealogy Assistant pop-up panel, make sure LivingDNA: Shared Matches as CSV under More Platforms is turned on.
- On LivingDNA, open Family Matching, then Relatives List.
- Click View Profile on a match. Their profile page opens.
- Scroll down to the relatives you and the match have in common.
- Click Download CSV beside the heading. A progress window counts the shared matches as they are saved, out of the total.
- When the Download Complete window says how many were saved, click Close. The CSV file is in your downloads folder.
CSV Columns
The CSV file has one row for each shared match, with these columns from left to right: Match Name, Relation, Degree, Shared cM, Shared Percentage, Shared Segments, Largest Segment cM, Avg Segment cM, Shared Matches, Country, Date of Birth, Date Added, Activity, Role, Y Haplogroup, mtDNA Haplogroup, Barcode, URL, Also Matches, GUID of Match
The cM and segment columns give how much DNA each shared match shares with you, not with the match whose profile you are on. Avg Segment cM is the AScM: the shared cM divided by the number of shared segments. Gil Bardige’s one-page PDF What Is AScM? explains how to use it. Shared Matches is how many matches you share with that person.
Relation is LivingDNA’s predicted relationship, and Degree is the number behind it, from 1 for the closest matches to 9 for 4th cousin or greater. Date Added is the date the shared match joined your list of matches, and Activity is how recently that person has used LivingDNA.
Also Matches names the match whose profile you downloaded from, and GUID of Match is their barcode. Country, date of birth and the haplogroups are filled in only where LivingDNA holds them, so blanks are normal.
NOTICE: CSV DOWNLOAD TOOLS ARE FOR PERSONAL RESEARCH ONLY.
Related features
- LivingDNA: Download Match List as CSV: Save your whole LivingDNA match list to a CSV file, including the largest segment and average segment size (AScM), which LivingDNA does not show on the page.
- Download Shared Matches as CSV: Download the shared matches of any DNA match to a CSV file, every page or as many as you choose, with the extra triangulation columns on a ProTools account.
- LivingDNA: Keyboard Navigation: Page through your LivingDNA Relatives List with the left and right arrow keys.
LivingDNA: Download Shared Matches as CSV is a feature of Genealogy Assistant.
Genealogy Assistant is an extension for Google Chrome, Mozilla Firefox, Microsoft Edge and Apple Safari which supercharges your family history research by adding over 100 custom features to popular genealogy websites like Ancestry, MyHeritage, FamilySearch, FamilyTreeDNA and more.
Install Genealogy Assistant for Google Chrome | Install for Mozilla Firefox | Install for Microsoft Edge | Install for Apple Safari