GENEALOGY-DNA-L Archives

Archiver > GENEALOGY-DNA > 2013-03 > 1364127912


From: Ann Turner <>
Subject: [DNA] Converting AncestryDNA raw data format to 23andMe format
Date: Sun, 24 Mar 2013 05:25:12 -0700


OK, here's my first stab at creating an Excel macro to convert AncestryDNA
format to 23andMe format.

https://docs.google.com/file/d/0B-wpDkkP5x0oRjQ3aS1haGM4REk/edit?usp=sharing

Please let me know if the instructions in the spreadsheet are clear enough,
and if your output file works with David Pike's utility
http://www.math.mun.ca/~dapike/FF23utils/diffs.php when you compare it to
your 23andMe data.

I don't want to clog up this thread with differences reported by Pike's
utility, but I would like to collect some. Please send them to me privately
.

If I hear back about problems, I'll remove it and try again.

Ann Turner


This thread: