Question: How to convert SNP genotyping excel file to .MEGA file format
0
blacktomato27 • 40 wrote:
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
ADD COMMENT
• link
•
modified 21 months ago
by
caroline.pont • 0
•
written
2.8 years ago by
blacktomato27 • 40
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.