What problem does LivingDNA: Download Match List as CSV solve?
LivingDNA: Download Match List as CSV adds a Download CSV button to your LivingDNA relatives list that saves every match to one CSV file for Excel, Numbers or Google Sheets. LivingDNA has no way to export your matches, so without it each one has to be copied off the screen.
How does LivingDNA: Download Match List as CSV work?
The Download CSV button sits at the left end of the search and sort bar above your relatives list. There is no page count to enter: one click saves the whole list, however many matches you have. The file follows the order chosen under Sort By and any name typed in the search box.
A progress window names the DNA test being downloaded and counts the matches saved so far out of your total. The tab title shows the same count. You can use other tabs while it runs. Cancel Download stops the download early and still saves the matches collected up to that point.
When it finishes, a Download Complete window says how many matches were saved to your downloads folder. The file name holds your name and your test’s barcode, so files for different tests stay apart. You can keep older files to compare with a new download of the same test.
If you manage more than one test, the file is for the profile on screen, whose name is at the top. To download another test’s matches, switch to it with LivingDNA’s Change Profile, then open its relatives list.
The file holds two figures LivingDNA does not show on the relatives list. One is the largest segment you share with a match, in cM. The other is the average segment size (AScM), the shared cM divided by the number of segments. Gil Bardige’s one-page PDF What Is AScM? explains how to use it.
How do I use LivingDNA: Download Match List as CSV?
- In the Genealogy Assistant pop-up panel, make sure LivingDNA: Download Match List as CSV under More Platforms is turned on.
- On LivingDNA, open Family Matching, then Relatives List.
- To save only some of your matches or change their order, type a name in the search box or choose an option under Sort By.
- Click Download CSV. A progress window names the DNA test and counts the matches as they are saved, out of your total.
- When the Download Complete window appears, click Close. The CSV file is in your downloads folder, named with your test’s barcode.
CSV Columns
The CSV file has one row for each match, with these columns: 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
Relation is LivingDNA’s predicted relationship, such as 1st cousin 1x removed. Degree is the number behind it, from 1 for the closest matches to 9 for 4th cousin or greater. Avg Segment cM is the average segment size (AScM): the shared cM divided by the number of shared segments.
Shared Matches is the number of matches you and that person have in common. Date Added is the date the match joined your relatives list, and Activity is how recently they have used LivingDNA. Role reads DNA Owner or DNA Manager for the account behind each match.
Barcode is the match’s LivingDNA test ID, and URL opens their profile page. Country, date of birth and the haplogroups are filled in only where LivingDNA has them, so blanks in those columns are normal.
NOTICE: CSV DOWNLOAD TOOLS ARE FOR PERSONAL RESEARCH ONLY.
Related features
- LivingDNA: Download Shared Matches as CSV: Download every relative you share with a LivingDNA match to a CSV file, with the estimated relationship, segment count, largest segment and AScM.
- Download Matches Pages as CSV File: Download your Ancestry DNA matches to a CSV file, as many pages as you choose, following the filters and sort order you have on screen.
- LivingDNA: Keyboard Navigation: Page through your LivingDNA Relatives List with the left and right arrow keys.
LivingDNA: Download Match List 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