If Scoring doesn't understand your spreadsheet, check the following.
Your spreadsheet must be an .xls or .xlsx file.
The spreadsheet must contain at least 3 columns. The first row must contain the column names.
source. This column contains the source texts. Values must be text. The column name must be "source".
reference. This column contains the reference translations. Values must be text. The column name must be "reference".
translation columns. All other columns contain machine translations. Values must be text. These columns can have any name. If a column name has "custom" in it, Scoring will make this translation light blue on the charts.
If your spreadsheet doesn't have any of these columns — "source", "reference" and at least one machine translation — add them.
If your spreadsheet has any other columns with content, delete them.
Empty rows and columns
If your spreadsheet contains empty rows and columns, there is no need to delete them.
Values in columns
Scoring has some requirements for values in columns. If a cell doesn't meet the requirements, the whole row with this cell will be deleted. Scoring will upload your spreadsheet, if at least one row remains after deleting bad rows.
A row will be deleted if any of the following is true:
- Text is longer than 2,000 characters.
- Text is longer than 300 words.
- A cell is not in text format.
- A cell is empty.
- A text in the "source" or "reference" column is a duplicate of another text in this column.