Uploads using the Y-BAT database (modified from Purps et al. 2014)

The upload entry allows you to enter your haplotypes in a CSV/XLSX file and get a bulk haplotype classification. This option uses a properly formated CSV/XLSX. Follow these guidelines:

• Overall. The data in the CSV has to be separated with commas, semicolons or tabs, but they have to be consistent over all the file.
  If you opt for a XLSX the file must be created with the new format, i. e. not a XLS from Excel 2003 or older.
• Header. The first line is the header of the file. It allows the tool to locate all the needed Y-STR and individual identifiers. The first column has to start with "ID" (ID, id, Id, IDs... should work). All the other columns can be anything, but the tool looks for at least DYS19, DYS385, DYS389I, DYS389II, DYS390, DYS391, DYS392 and DYS393, and at most the Y-STRs you can find in the main page. Any extra columns will be ignored.
• Body/Data. All the rows with data have to contain IDs for each individual in the first column and integer values for each Y-STR identified. Remove deletions, null alleles, intermediate alleles, duplications or triplications at one or more makers.

Here you have a couple of sample files to play around: Sample 1 and Sample 2.

Uploads using a custom database

The upload custom database entry allows you to enter your haplotypes in a CSV/XLSX file and a custom DB. The haplotype CSV/XLSX follows the above rules. The custom DB is a bit harder to get right:

• Overall. The data in the database CSV has to be separated with tabs. If you opt for a XLSX it cannot be a XLS.
• Header. The first line is the header of the DB. The first four columns have to be: ID, Population, Country and Continent. All of the following columns are the Y-STR data, like DYS19, DYS390, DYS391, DYS392...
  Make 'Continent' values match the values shown in 'Region' field (Africa, America, East Asia...).
• Body/Data. All the rows have to contain the ID for each individual, the population, the country, the continent and a list of integer values for each Y-STR.

Here you have a couple of sample files to play around: Sample DB and Sample 3. You can use the Sample DB as a model file to build your own database.