Getting all the in common with (ICW) matches at 23andme

The DNAgedcom website has a wonderful feature whereby you can download the overlapping segment data for one of your matches with all your other matches at 23andme. Since it will include you in the CSV file, you can quickly see if you and your share both match another person at the same spot (called triangulation by genetic genealogists).

Here is a sample of that type of match from the resulting sorted spreadsheet for an adopted close DNA relative I am working with (names of non-family removed for privacy):

Comparison Chr Start point End point Genetic distance # SNPs
Adoptee CR vs 1st cousin GP
5 113000000 124000000 11.8 2217
Adoptee CR vs me
5 114000000 121000000 7.2 1401
Adoptee CR vs Dad 5 114000000 124000000 11.2 2038
Adoptee CR vs my brother 5 114000000 124000000 11.7 2112
Adoptee CR vs SS 5 115000000 123000000 8.9 1602
Adoptee CR vs EJ 5 116000000 123000000 6.8 1391
Adoptee CR vs AH 5 116000000 123000000 7.8 1482
Adoptee CR vs AC 5 117000000 124000000 7.4 1421

The four other matches are a bit small but the one with SS is mildly promising; so to be absolutely sure it is a triangulation I have to compare SS back to my family members. Here is how that looks in the 23andme chromosome browser (which can do three at a time with any of your shares):

And we see that the overlap with me is just a little bit too small to show up, less than the 23andme threshold, but my Dad and brother are a triangulation.

So read on to find out how to use this download feature at

First you have to log into the site (free but donate if you like it). If you don’t have a username and password yet, it is easy enough to register for one.

Once logged in, put your cursor on the 23andme tab and then click on the the green Download button in the drop down menu


On the next page there is a box where you put the login email address and the password for the 23andme account that you wish to use for this. Then in the last box you can put the name of the profile to compare (it must be exact! It will not know that Joe Smith is the same as Joseph Smith)


Once you have entered the profile whose overlaps you are interested in click the “Get Data” button. Then a progess box will come up on that page.  Time to go do something else but leave that browser window open!


Sometime later a box will come up asking where you want to save this on your computer.  I often blow this step, having forgotten that I have one of these running. It is absolutely OK to not save it on your PC  since it is already saved in your members file area and can be retrieved from there anytime!


Clicking on view files will take you to a familiar looking two panel windows explorer type display. Click on the folder representing the company and profile you used on the left to see what files you have there. Then clicking on any file on the right lets you download it.

So  you may ask why I am doing all this. Well if I can figure out the common ancestor with SS, then I will know what line to look on for the birth parent of my adoptee DNA cousin.


4 thoughts on “Getting all the in common with (ICW) matches at 23andme

Click here to add your thoughts at the end of the comments
  1. Thanks so much for this Miss Kitty. I see the hundereds of hours being saved 🙂

    Question: When we only want the FIA Match results, should the default two boxes (Run FIA, Run AC) remain checked? Or, would the tool run faster if they are unchecked?

  2. I usually uncheck the AC box. I asked Rob this question and have not heard back yet, but it does seem logical that it would be faster.

  3. Sorry it took me so long. 🙂

    Yes, if you turn off an option, it will run faster since it won’t need to pull that particular data. However, you won’t have that data of course either. 🙂 So if you are only interested in the FIA, turn off the AC box and leave the other box alone.

    I’m not sure if you mentioned this Kitty, but please be sure to pay attention to case of the match name. The system currently checks the case of the name as well. That is on my list to relax, but in case you don’t get anything back, that might explain why.

  4. Hello!

    I would like to understand how GedMatch compares the X chromosomes? The X DNA One to One comparison. We want to know if we could be half sisters with same dad (we definitely have different mothers but the question is our link and biological dad)?

    The 1st line is mostly green, there is also a lot of yellow + a few thin red lines
    And above the line is blue along 8 segments

    Largest segment = 58.7 cM
    Total segments 135.1cM (71.091 Pct)
    8 shared segments found for this comparison.
    9213 SNPs used for this comparison.

    Is it an aunt/niece result or half sisters with same bio dad? I am lost thank you for your help. Do you propose private consults ? Thanks !!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.