Login to participate
Register   Lost ID/password?
Louis Kessler's Behold Blog » Blog Entry           prev Prev   Next next

What to do When Your @FamilyTreeDNA Autosomal Results Come In - Tue, 10 Jan 2017

Family Tree DNAIt’s always an exciting day when your DNA results come back. After analyzing my uncle’s results ad infinitum for the past six months, I finally bit the bullet and sent away for my own test. The FamilyTreeDNA Holiday Season sale with coupons for extra dollars off was quite motivating.

I ordered my own test on November 14. It arrived on Nov 24 and I did the cheek swabs the next day and mailed it. Yesterday, I got the email that said my results were in.

So these are the Steps I recommend that you do when your autosomal results come in:

Step 1. Don’t Panic! Yes, you can be excited, but take your time and do it right.

Step 2.   Sign in online to your myFTDNA account. If you haven’t already, do some administrative stuff first. Once your results are there, people are going to find you and you won’t want to look like literally a nobody. Add an “About Me” and image to your Profile.


Step 3.   Next to the Account Settings tab is the Genealogy tab. Enter your Most Distant Ancestors:


Step 4. Also on the Genealogy tab, enter your Ancestral Surnames:


Step 5. Now go to Family Tree and enter your parents, grandparents, great-grandparents, etc.  No need to enter all the details, but make sure you have all your ancestors names, birth years and death years. And I wouldn’t yet enter any other brothers, sisters or children/grandchildren of your ancestors. That gungs things up a bit. There is a better way to add them. See step 11 below.


There. You’re all set up. People can find you and they’ll be able to see if they might share family and by providing this information, you’ve invited them to contact you.

Step 6. Now check out your Family Finder results. Go to the matches page and, if you’re like me and are from an endogamous population, prepare to be overwhelmed.


You’ll see you have (A) 8,392 people who match you, and it will take (B) 280 pages to display them. Then (C) check the first few at the top and see if there is any one you know who is a relative.

Step 7.   Either breathe a sigh of relief when you see your uncle shares 1,861 cM as he should, or agonize a bit … maybe a lot .. as you search desperately for your uncle in the list. You know he tested. If he’s not there, then go back to step 1, except now you Panic!

Step 8. You don’t want to go through the Family Finder matches one-by-one. There’s a better way. Download your matches. At the bottom of the Family Finder matches page, there are two buttons:  CSV or Excel


CSV is a comma delimited text format. Excel isn’t really Excel but is XML. It doesn’t matter which one you use. They both contain the same information. And Excel or any spreadsheet software can read them both. I usually use CSV, so hit the CSV button and download the file.  It will be called something like: nnnnnn_Family_Finders_Matches_yyyymmdd.csv.

Step 9. Open that file in Excel or your spreadsheet software. Right away save the file with a meaningful name and in the format of your spreadsheet software (e.g. Excel is .xlsx) so that all the spreadsheet features will be retained. I named my file “LK Master Match List.xlsx”. Your file should look like this:


… and yes, they are scrunched just about that much.

The key thing here is that you’ve got all your match data and it is much easier to sort or search or highlight or add your notes in a simple spreadsheet than trying to do so on the FamilyTreeDNA site.

The columns include:
- Full Name
- First Name  (You can delete this, as it’s superfluous)
- Middle Name (This too)
- Last Name (You’ll need this to sort by last name)
- Match Date
- Relationship Range
- Suggested Relationship (I’d hide this. Relationship Range is good enough)
- Shared cM
- Longest Block (Change title to: Max cM)
- Linked Relationship
- Email (I’d move this after the Name)
- Ancestral Surnames
- Y-DNA Haplogroup
- mtDNA Haplogroup
- Notes
- Matching Bucket

The one field that FamilyTreeDNA does not include that I feel is important, that 23andMe includes in their match download file, is the person’s Sex. Oh well, we won’t worry about that for now.

Step 10.   Now go through all your matches in your list of 8,392 and make a note of anyone who is already a known relative of yours. Other than my uncle, I had a 3rd cousin Joel. He and I have been sharing our research on our common line for about 15 years. So I’ve got my Uncle, whose test I submitted, and Joel. That’s it. 2 out of 8,392. Maybe you have more.

Step 11.   It’s time to go back to your Family Tree at FamilyTreeDNA and add your known relatives. For my uncle, I would add him as a son to my grandfather. For my third cousin Joel, I would find our common great-great grandparents, add a son, add a daughter to the son, add a son to the granddaughter, and add Joel under the great-grandson. Don’t bother naming the people in-between.


Doing this will not only let you get a picture of where your relatives are in your DNA tree, but it will also get the FamilyTreeDNA site to start calculating something pretty cool for you. It’s going to use the DNA matches of your relatives to figure out for all your 8.392 people, who matches you on your father’s side, who matches you on your mother’s side, who on both sides, and who matches but the side isn’t determined yet. You’ll then see this on your matches page:


Both my uncle and Joel are on my father’s side, so it has figured out that 2,168 of my 8,392 matches also match to either my uncle or Joel. And now those little symbols for paternalimage, maternal image, or both image, will be shown alongside each of your matches to which they apply.

Step 12.   With that bit of extra information, download your Family Finder matches again (see Step 8). This time, that last field called “Matching Bucket” will be loaded with Paternal or Maternal or Both or N/A.

Step 13.   Now go at it and have fun. Look in your spreadsheet for people you know, your ancestral surnames, anything that looks interesting. Use the Notes column for your thoughts on this match. Color code people that are of interest to you. Add other columns as you see fit. If you don’t end up with something pretty like this, then you’re doing it wrong:


Step 14.   If you made it all the way here, that’s super!

Now you should be daring. Contact the DNA relatives you don’t know who you might be able to figure out a relationship to, and your DNA adventure will begin. You’ll be consumed by it.

3 Comments           comments Leave a Comment

1. geniaus (geniaus)
Australia flag
Joined: Tue, 20 Mar 2012
8 blog comments, 0 forum posts
Posted: Tue, 10 Jan 2017  Permalink

Well I didn’t know about the Matching Bucket - thanks for enlightening me.

2. deckie49 (deckie49)
United States flag
Joined: Fri, 20 Jul 2012
19 blog comments, 2 forum posts
Posted: Sat, 14 Jan 2017  Permalink

i know very little how these dna websites work. are testing sites and databases compatable with each other? is it possible to compare and match one’s dna results with all the available databases? can dna results from other testing sites (ie. ancestry.com or 23andme.com) be entered into familytreedna.com?

3. Louis Kessler (lkessler)
Canada flag
Joined: Sun, 9 Mar 2003
231 blog comments, 226 forum posts
Posted: Sat, 14 Jan 2017  Permalink


The answers to your questions are: somewhat, somewhat, and somewhat. Sorry, but they are all long answer questions.



The Following 2 Sites Have Linked Here

  1. This week’s crème de la crème — January 14, 2016 | Genealogy à la carte : Fri, 13 Jan 2017
    [...] What to do When Your @FamilyTreeDNA Autosomal Results Come In by Louis Kessler on Behold Genealogy. [...]

  2. Best of the Genea-Blogs - 8 to 14 January 2017 - Geneamusings - Randy Seaver : Sun, 15 Jan 2017
    "... Louis got his FamilyTreeDNA results and used a spreadsheet and tree to analyze it."

Leave a Comment

You must login to comment.

Login to participate
Register   Lost ID/password?