
What problem does Download Shared Matches as CSV File solve?
Download Shared Matches as CSV File adds a Download CSV button to the Relatives in Common table on a 23andMe match’s profile, which saves the shared matches to a CSV file. Each row holds the DNA a shared match shares with you and with the match, which 23andMe gives no way to export.
How does Download Shared Matches as CSV File work?
The button sits in the toolbar above the Relatives in Common table, beside a box for the number of pages to download. Each page holds 10 shared matches. Leave the box empty to download every page from the one you are on, or type a number to stop after that many pages.
The shared matches are saved in the table’s order, and a long list takes hardly longer than a short one. While it runs, the button reads Processing… and a progress window shows each step, with a Cancel Download button. A cancelled download saves no file to your downloads folder.

If 23andMe starts limiting requests, the download pauses for a minute, with a countdown in the progress window, and then tries again. If 23andMe stops answering or asks you to sign in or prove you are human, the download stops and asks you to refresh the page and try again.
When it finishes, a window says how many shared matches were saved to your downloads folder, with a Close button. The file is named with the tester’s name, the match’s name and both test IDs, so each match’s download is easy to find among your other downloads.
The gear beside Download CSV opens Download Settings, where you can choose the download speed. A slower speed waits longer between requests to 23andMe. The speed you choose is also used by the other download tools.
How do I use Download Shared Matches as CSV File?
- In the Genealogy Assistant pop-up panel, make sure Download Shared Matches as CSV File under 23andMe Tools is turned on.
- Open the profile of a 23andMe match and open its Relatives in Common section. Automatically Open Shared Matches can open it for you.
- Leave the box next to Download CSV empty for every page, or type the number of pages to download from the page you are on.
- Click Download CSV. The file is saved to your downloads folder.
- To change the speed, click the gear beside Download CSV.
- Choose a Download speed. Standard suits most lists; choose Walk or Crawl only if 23andMe keeps limiting your downloads.
- Click Close. Your choices are saved as you make them.
CSV Columns
Each shared match gets one row, with these 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), Longest Segment cM (You), Avg Segment cM (You), Star Status, 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
Shared cM, Shared Percentage and Estimated Relationship describe each shared match’s relationship with you. Also Matches is the name of the match whose profile you are on. The three columns that end in “with Match” or “to Match” describe each shared match’s relationship with them.
23andMe gives shared DNA only as a percentage, so the cM columns are worked out from it. The columns that end in (You), and every column after Star Status, come from your own DNA Relatives list and describe the shared match’s relationship with you, not with the match.
Avg Segment cM (You) is the shared cM divided by the number of segments. This average is the AScM, and Gil Bardige’s one-page PDF What Is AScM? explains what it is and how to use it with your matches.
Star Status reads Starred for matches you starred, and Groups lists the groups from Add Groups to Shared Matches. Estimated Relationship includes any change you have made to it. Predicted Relationship is 23andMe’s own prediction, before any change you have made to it, and Relationship Range lists every relationship it considers possible.
Side reads Mother’s side, Father’s side or Both sides where 23andMe can tell. Opted In is the date the match joined DNA Relatives. Sex, Location, Family Surnames, Family Locations and the four grandparent birthplaces are what the match has shared on their profile.
Connection reads Connected, Invitation sent or New invitation, and Messaged reads Yes once you have exchanged messages. Open Sharing reads Yes or No for the match’s sharing setting. In Your Tree links to the match in your 23andMe family tree, if they are in it.
Notes holds your own notes on the match, and FamilySearch reads Yes when the match has a FamilySearch link. Last Active and the two haplogroup columns depend on your 23andMe membership, and are blank when your membership does not include them.
NOTICE: CSV DOWNLOAD TOOLS ARE FOR PERSONAL RESEARCH ONLY.
Related features
- 23andMe: Download Matches Pages as CSV File: Download your 23andMe DNA Relatives list to a CSV file, as many pages as you choose, with your filters, sort order and each match’s AScM.
- 23andMe: Automatically Open Relatives in Common: The Relatives in Common section opens by itself on every 23andMe match profile, so your shared relatives are there when the page loads.
- 23andMe: Highlight Shared Matches 50cM+: 23andMe shared matches who share 50 cM or more with you appear in bold red, with a threshold you can raise or lower.
23andMe Download Shared Matches as CSV File 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
