If Spotlight doesn't understand your spreadsheet, check the following:
File format
Your spreadsheet must be an .xls or .xlsx file.
Columns
The spreadsheet must contain 4 or 5 columns. The first row must contain the column names.
"id". This column is optional. It contains numbers of segments. Values must be integers. The column name must be "id" or "segment_id".
"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 1". This column contains the translations made by translator 1. Values must be text. This column can have any name.
"translation 2". This column contains the translations made by translator 2. Values must be text. This column can have any name.
If your spreadsheet doesn't have any of these columns — "source", "reference", "tranlslation 1", and "translation 2", 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
Spotlight has some requirements for values in columns. If a cell doesn't meet the requirements, the whole row with this cell will be deleted from the spreadsheet. Spotlight 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:
- A text in "source", "reference", or a column with translation is longer than 2,000 characters.
- A text in "source", "reference", or a column with translation is longer than 300 words.
- A cell in "source", "reference", or a column with translation is not in text format.
- A cell in any column is empty.
- A value in the "id" column is a duplicate of another value in this column.
- A text in the "source" or "reference" column is a duplicate of another text in this column.