This is a test version of Biostars. For the public version, visit https://www.biostars.org.
How to convert SNP genotyping excel file to .MEGA file format

Hi to All, I got 370 SNP genotyping data of 100 individuals in excel file like this

Genotype SNP1 SNP2 ........SNP370 red C/C A/A T/T White G/G T/T A/T . . . Yellow T/T C/C G/G

Now I want to build phylogenetic tree using MEGA 6.0 software and do not know how to convert this file into .MEGA file format. Can any one help me in this regard? or share any example file like this. you help will be highly acknowledged

Regards, genetist

snp
• 5,167 views • link
updated by caroline.pont • caroline.pont • written by blacktomato27 blacktomato27

enter image description here

Also, when you say Excel file, what do you mean exactly? Most machines are set to open CSV and TSV files on Excel by default - check out the actual file extension.

Also, if someone gave you the data in a spreadsheet, ask them for the plain text data. Let them know that Excel and VCF is a bad mix.

• 1 views • link
written by Ram Ram

1 answer

Hi, I have exactely the same question... did you find the way to do that? (I have a .vcf format)

• 0 views • link
written by caroline.pont • caroline.pont

If you're using Excel, see my comment above.

• 0 views • link
written by Ram Ram

Log in to answer this question.

More posts like this