What problem does 23andMe Download Shared Matches as CSV File solve?
23andMe lets you see the relatives you have in common with each match, but it does not let you export that list. Working through clusters of shared matches outside of the website, or comparing them across visits, means a lot of manual copying. 23andMe Download Shared Matches as CSV File adds a one-click download button to the Relatives in Common page that walks through the shared list and saves a CSV containing both your shared cM with each person and their shared cM with the original match.
How does 23andMe Download Shared Matches as CSV File work?
On any 23andMe Relatives in Common page, a Download CSV button is added to the toolbar above the shared matches list, along with a box where you can choose how many pages to download (leave it empty to download every page) and a gear icon labelled Download Settings.
The shared matches are read straight from 23andMe in a handful of requests, however long the list, and saved in the order the page shows them. A progress overlay shows the download, with a Cancel button to stop at any time.
The CSV file is saved when the download completes, with a filename that includes the names of both the original tester and the match so different cluster downloads stay distinct. Click the gear icon to change the download speed.
How do I use 23andMe Download Shared Matches as CSV File?
- Ensure 23andMe Download Shared Matches as CSV File is enabled in the Genealogy Assistant pop-up panel.
- Open the Relatives in Common list for any 23andMe match.
- Enter the number of pages you want to download in the box next to the Download CSV button, or leave it empty to download every page.
- Click Download CSV. Click Cancel in the progress overlay to stop early.
- When the download completes, the CSV file will be saved to your downloads folder.
- (Optional) To change the speed of the download, click the gear icon beside Download CSV, choose a slower Download speed and click Save & Close.
CSV Columns
- Match Name
- Shared cM
- Shared Percentage
- Estimated Relationship
- Groups
- URL
- GUID
- Also Matches
- GUID of Match
- Shared cM with Match
- Shared Percentage with Match
- Estimated Relationship to Match
- Shared Segments (You)
- Star Status
- Longest Segment cM (You)
- Relationship Range
- Predicted Relationship
- Side
- Opted In
- Notes
- Sex
- Location
- Family Surnames
- Family Locations
- Maternal Grandmother Birthplace
- Maternal Grandfather Birthplace
- Paternal Grandmother Birthplace
- Paternal Grandfather Birthplace
- Connection
- Messaged
- Open Sharing
- In Your Tree
- Last Active
- Maternal Haplogroup
- Paternal Haplogroup
- FamilySearch
23andMe only shows the DNA two of your matches share with each other as a percentage, so the columns ending in (You) and every column after Star Status describe each shared match’s relationship with you, taken from your own DNA Relatives list.
Relationship Range lists the relationships 23andMe considers possible, and Predicted Relationship is its own prediction before any change you have made to it. Side shows whether the match is on your mother’s or father’s side, where 23andMe can tell. Sex, Location, Family Surnames, Family Locations and the four grandparent birthplaces are what the match has shared on their profile, and Opted In is the date they joined DNA Relatives.
Connection shows whether you are connected or have an invitation waiting, Messaged reads Yes once you have exchanged messages, and In Your Tree links to the match in your 23andMe family tree. Last Active and the haplogroups depend on your 23andMe membership and are blank when it does not include them.
NOTICE: CSV DOWNLOAD TOOLS ARE FOR PERSONAL RESEARCH PROJECTS ONLY.
23andMe Download Shared Matches as CSV File is a feature of the software 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. You can watch a full video walkthrough on YouTube.
Install Genealogy Assistant for Google Chrome | Install for Mozilla Firefox | Install for Microsoft Edge | Install for Apple Safari