If MT Studio doesn't understand your spreadsheet, check the following.
Your spreadsheet must be an .xls or .xlsx file.
The spreadsheet must contain at least two columns: source and at least one translation. 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". NOTE: this column isn’t obligatory. If you don’t have reference translations, you can compute metrics that work without reference translations.
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, Intento MT Studio will make this translation light blue on the charts.
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
Intento MT Studio has some requirements for values in columns. If a cell doesn't meet the requirements, the whole row with this cell will be deleted. MT Studio 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.