Monday, March 21, 2016

Automated FTDNA to 23andME Raw DNA Data Conversion Tool

GEDMatch and FamilyTreeDNA.com are actively working to resolve their dispute regarding the use of FTDNA kits on GEDMatch.org.  However, at this time, uploads of FTDNA kits remained blocked from GEDMatch.  I've heard from a number of people who were very frustrated by this policy after having invested in testing at FamilyTreeDNA.  There is a method for converting FTDNA Raw DNA data to 23andMe's format, which can still be uploaded to GEDMatch.  I've posted instructions on how to do that here: http://www.geneticgenealogist.net/2016/03/how-to-upload-ftdna-results-to-gedmatch.html.

I've been asked repeatedly for an automated version of this process. Here it is.  It uses a Visual Basic script to reformat the raw data files. Because of this, it is for Windows users only.  Mac users will have to make the edits manually.

Note that some antivirus programs might flag the .vbs script file as a potential threat.  If that occurs, you can either temporarily disable your virus scanning, or use the manual process linked above.

Any results uploaded via this process will receive the "M" prefix from GEDMatch usually associated with 23andMe files. I highly recommend that once this dispute is resolved and FTDNA kit uploads are allowed again, you delete the 23andMe version and reupload your FTDNA raw data.

Questions? Problems? Let me know in the comments below or hit me up on Google+.

FTDNA to 23andME Converter Instructions

Step 1: Download your Build 36 Raw DNA Results from FTNDA. From the default screen on Familytreedna.com, choose "Download Raw Data":




















Then choose the download links for the two "Build 36" files:



Step 2: Download this file: FTDNAto23andMeConverter.zip

Step 3: Unzip the contents of FTDNAto23andMeConverter.zip to the same folder as your FTDNA raw data files.  The folder should now contain the following:




Step 4: Run "FTDNAto23andMeConverter".  When it is finished you will have a file called "genome_23andMe_Full_20160320010000.txt.zip" in the folder. This is the file to upload to GEDMatch as a 23andMe Raw DNA file.  You can delete the other files in the folder when it is done running.



10 comments:

  1. Unfortunately I keep getting the following error: https://gyazo.com/093b7041b01838c83f4e567e9783dc12

    ReplyDelete
    Replies
    1. The script couldn't find the autosomal file in the same directory. It looks for a file with "ffo" in the title, but didn't find it. Possibly your results were named something different. If that's the case, let me know so I can update the script to be more compatible. Then try renaming the CSV files to FFO for the autosomal file and XO for the XDNA file and it should find them.

      Delete
    2. It's still not working for me. I even changed the name of my file to match yours as follows: https://gyazo.com/39cc59bc78a85477f5bb817fe5e21feb

      Delete
    3. Add "ffo" to the Autosomal CSV file's name, and "xo" to the XChromosome csv file name. Directory should look something like this: http://imgur.com/KDs9UMT

      Delete
    4. That did it! The ffo & xo needs to be lowercase. Thanks!!!

      Delete
    5. Now getting the following error when I try to upload the file to GEDMATCH: https://gyazo.com/d626a152d5253d4d2eeb65889d97ee20

      Delete
    6. GEDMatch is saying there's bad data in the csv file, which is not reading as a proper spreadsheet. Hard to say what to do based on that. If you can email your original raw data file to me at steven@geneticgenealogist.net, I'll see if I can figure out the problem.

      Delete
    7. Steven thanks for the offer, but I just got an email from GEDmatch stating the FTDNA new file format should be ready by the end of next week.

      Delete
  2. Would like to convert FTDNA to 23andMe so I can load it to Interpretome (http://esquilax.stanford.edu/), but can't get this script to work. I get "invalid procedure call," etc. Any other suggested conversion tools?

    ReplyDelete
    Replies
    1. Just found a tool that worked for me!

      http://www.y-str.org/2013/06/autosomal-dna-converter.html

      Delete