Converting MyHeritage .csv file to .txt

The MyHeritage raw data contains similar information to the 23andMe and AncestryDNA data, but it is in a slightly different format – a .csv or comma-separated values file type.

A .csv file is a type of text file with values that are separated by commas.

Directions for converting .csv to .txt:

1. Download your MyHeritage raw data and unzip (uncompress) the .zip file. It will give you a file named MyHeritage_raw_dna_data.csv.

2. Open the MyHeritage_raw_dna_data.csv in Excel. Alternatively, you can open Excel and then import the .csv file.

   (Google Sheets won’t work as an alternative to Excel for this. There is a maximum row limit of 40,000 rows in Google Sheets. The MyHeritage data file contains over 600,000 rows.)

3. In Excel, save the file as a tab delimited text (.txt) file. On a Mac, the option looks like this: