Data should be in the form of a tab separated matrix in a text file/tsv (Excel files will NOT be recognized), with first row as header:
DGRP
sex
Pheno1
Pheno2
...
DGRP_XXX
M
0.1
...
DGRP_XXX
NA
0.1
0.2
...
...
...
...
...
...
First column should be titled DGRP, and contain DGRP line ids in DGRP_XXX or line_XXX format. Note: each DGRP line should appear only once (summary data per line, not raw data per fly)
Second column is optional. If set, it should be titled sex, and values should be one of the following: [F, M, NA]
Then there can be any number of phenotyping columns with any phenotype name as title (please avoid exotic characters), with corresponding values for each DGRP
Missing values should be 'NA' or left empty.
You can also check this example file
for an example formatted file.