CSV / XLSX Files Configuration

After uploading CSV or XLSX files to the project, they require additional configuration before the system could import the content of these files.

To configure CSV or XLSX files, follow these steps:

  1. Open your project and go to Content > Files.
  2. Click Configure next to the file to open the configuration window.

Configure File

Configuration Options for XLSX Files

When configuring XLSX files, you’ll have the following options:

  • Import all cells - import each cell as a separate source string. Additionally, you can use Content Segmentation to split the source file’s content into shorter text pieces, mostly sentences and short paragraphs. This is helpful when translating content units consisting of several sentences because it will be easier to translate smaller pieces of text. Segmentation Rules eXchange (SRX) are used for automatic content segmentation.

  • Configure columns for import - specify the preferred column order.

XLSX Configuration Options

Configuring Columns for Import for XLSX and CSV Files

When configuring CSV or XLSX file with Configure columns for import option, you can specify the following column types:

  • Identifier – Column contains string identifiers. Typically an alphanumeric value.
  • Source string – Column contains source strings that should be translated.
  • Source string/Translation – Column contains source strings, but the same column will be filled with translations when the file is exported. When uploading existing translations, the values from this column will be used as translations.
  • Translation – Column for resulting translations added on export. On import and when uploading existing translations, the system will check this column for existing translations and upload them to the project.
  • Context – Column contains comments or context information for the source strings.
  • Labels – Column contains labels for the source strings. You can add multiple labels to each string, separating them with commas.
  • Max. Length – Column contains max.length limit values for the translations of the strings.
  • Not chosen – Column that will be skipped on import.

CSV Configuration

Configuration Templates

If multiple files have the same configuration scheme, save your current configuration as a template by clicking Templates > Save as template, then specify the template name and click Create. You’ll be able to apply the template to the newly imported files.

Column Headers

Not to translate the column headers, select Do not import the first row (header).

Column Headers

Reset Spreadsheet Configuration

If you’d like to start the spreadsheet configuration over, click Reset configuration.

Multilingual Spreadsheets

If your file contains several columns with translations into different languages, select Multilingual spreadsheet and map the languages to the appropriate columns.

By default, when you configure the multilingual spreadsheets, the Import translations option is selected. If you’d like not to import the existing translations from the file, you can clear this option.

If your multilingual source file doesn’t contain enough columns for all project target languages, click Add column. To remove one of the added columns, click Delete selected column.

Multilingual CSV

Configure Several Files at the Same Time

To configure several selected CSV or XLSX files, right-click and select Configure files.

CSV Configuration

To configure all CSV or all XLSX files at once, click Configure All at the top of the Files tab.

CSV Configuration

In the configuration window, you’ll be able to switch between the selected files to preview and verify if the applied configuration is correct for all files.

See Also

Was this article helpful?