Skip to content Skip to footer

23andMe: Download Matches Pages as CSV File

The top of the 23andMe DNA Relatives list with the Download CSV button, the gear beside it, and the pages box with select all outlined in red.

What problem does Download Matches Pages as CSV File solve?

Download Matches Pages as CSV File adds a Download CSV button to your 23andMe DNA Relatives list that saves your matches to a CSV file for Excel, Numbers or Google Sheets. 23andMe has no way to export the list, so without it every match has to be copied off the screen.

How does Download Matches Pages as CSV File work?

The Download CSV button sits at the top of your DNA Relatives list, beside a box for the number of pages to download. Each page holds 25 matches. Click select all beside the box to include every page from the one you are on. The download follows the filters and sort order on screen.

23andMe sends the whole list at once, so downloading every page takes hardly longer than one. A progress window shows each step, with a Cancel Download button. A cancelled download saves no file, and leaving the page while a download runs asks you to confirm first.

The Downloading DNA Matches window over the DNA Relatives list, showing the current step, Step 2 of 4, a progress bar and a Cancel Download button.

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 matches were saved to your downloads folder, with a Close button. The file is named with the tester’s name and test ID. If you manage more than one DNA test, the downloads for each of them are easy to tell apart in the folder.

The gear beside Download CSV opens Download Settings, where you can change the download method and the download speed. A slower speed waits longer between requests to 23andMe. The speed you choose is also used by the other download tools, on 23andMe and on other sites.

The Download Settings window over the DNA Relatives list, with Download method set to Streaming, Download speed set to Standard and a Close button.

How do I use Download Matches Pages as CSV File?

  1. In the Genealogy Assistant pop-up panel, make sure Download Matches Pages as CSV File under 23andMe Tools is turned on.
  2. Open your 23andMe DNA Relatives list. To download only some matches, filter or sort the list first and go to the page you want to start from.
  3. Type the number of pages in the box next to Download CSV, or click select all for every page from the one you are on.
  4. Click Download CSV. The file is saved to your downloads folder.
  5. To change the speed, click the gear beside Download CSV.
    1. Choose a Download speed. Standard suits most lists; choose Walk or Crawl only if 23andMe keeps limiting your downloads.
    2. Click Close. Your choices are saved as you make them.

The same settings are in Advanced Settings, under Download Options. To open it, click Edit advanced settings at the bottom of the pop-up panel.

CSV Columns

Match Name, Shared cM, Shared Percentage, Shared Segments, Longest Segment cM, Avg Segment cM, Estimated Relationship, Star Status, Groups, Match GUID, Match URL, 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 is worked out from 23andMe’s shared percentage. Longest Segment cM is the longest piece of DNA you share, and Avg Segment cM 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 how to use it.

Star Status reads Starred for matches you starred, and Groups lists the groups you added with Add Groups to Matches List.

Estimated Relationship is the one 23andMe shows on the list, including any change you have made. Predicted Relationship is 23andMe’s own prediction, before any change you have made to it, and Relationship Range lists every relationship 23andMe 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 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