how to get your parent's raw data without testing them (if you tested at ancestryDNA)

**vbnetkhio** · 08-01-2019, 02:17 PM

did you know that ancestryDNA phases your raw data (separates your mother's and father's dna)

if you open your raw data file in excel, the "allele1" column is one of your parents and "allele2" is the other

so you can just create two new files, one where you paste 2 allele1 columns and other where you paste 2 allele2 columns

and you can upload these files to gedmatch

i don't know how precise it is for matching but it gives a good rough estimate in calculators

**Ayetooey** · 08-01-2019, 02:19 PM

I'll test this with and compare it to my dads tested data at some point. Good find.

**vbnetkhio** · 08-01-2019, 02:35 PM

Originally Posted by Ayetooey

I'll test this with and compare it to my dads tested data at some point. Good find.

i think they have the best raw data currently. with it i score the highest SNP number on gedmatch calculators, and they also test X,Y, mtdna and the "24th" chromosome (pseudoautosomal regions)

**~~Ford~~** · 08-01-2019, 02:41 PM

The black dot is me.

**Luke35** · 08-01-2019, 02:49 PM

Cool, thanks for the info. My mom did AncestryDNA and is on Gedmatch so I have a phased kit for my dad - but I will try this too.

**~~lonewolfcypriot~~** · 08-01-2019, 02:51 PM

wicked, I can find out where my parents plot. great

**vbnetkhio** · 08-01-2019, 03:02 PM

Originally Posted by lonewolfcypriot

wicked, I can find out where my parents plot. great

you can also get your y and MT haplogroups from the raw data.

y-dna here
https://ytree.morleydna.com/

and y-dna and mtdna here
https://www.wegene.com/en/

**Kaspias** · 08-01-2019, 03:49 PM

For the people who don't have Ancestry data:

Download DNAStudio(here) and convert your raw data to the Ancestry. Open your converted raw data with notepad+, press ctrl+a, and ctrl+c. Create a new excel file and press ctrl+a and ctrl+v. You will be able to edit columns. Delete the column which allele2 written, copy the column which allele1 written and paste it to the column which you have just deleted and edit its name as allele2. Save it as .csv file (not xlsx) and exit the excel. Open the same file with notepad+, press ctrl+f and replace ; with 3 times of "space". Save the file again as .csv and it should be ready to upload Gedmatch. Then do the same process for allele2.

At least this is how i did it and it worked fine. Probably won't be precise as much as Ancestry testers though.

Rgvgjhvv · 08-01-2019, 03:52 PM

Wow! I need to re-read that again slowly because I would love to do this.

Rgvgjhvv · 08-01-2019, 04:00 PM

Originally Posted by Kaspias

For the people who don't have Ancestry data:

Download DNAStudio(here) and convert your raw data to the Ancestry. Open your converted raw data with notepad+, press ctrl+a, and ctrl+c. Create a new excel file and press ctrl+a and ctrl+v. You will be able to edit columns. Delete the column which allele2 written, copy the column which allele1 written and paste it to the column which you have just deleted and edit its name as allele2. Save it as .csv file (not xlsx) and exit the excel. Open the same file with notepad+, press ctrl+f and replace ; with 3 times of "space". Save the file again as .csv and it should be ready to upload Gedmatch. Then do the same process for allele2.

At least this is how i did it and it worked fine. Probably won't be precise as much as Ancestry testers though.

I'd love to see your dad's results.