CSV / XLSX Files Configuration

You can not only create a new .csv file, but also upload existing .csv and .xlsx files to your project.
Please note, that after they are uploaded they should be configured, so you can specify how to import data from each column into your project. Only after they’re configured they’ll appear in the Editor, where translators could translate them.

To add .csv or .xlsx files to your project and specify the file configuration scheme, please follow these steps:

  1. Open your project, go to the Content section, Files tab.
  2. Upload files and click Configure next to the file to open the configuration window.
    Configure File

Configuring XLSX Files

Additionally, when configuring .xlsx files, you’ll have these options:

  • Import all cells – import each cell as a separate source string
  • Content segmentation – split the content in the source file into shorter pieces of text, 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.

Configuring XLSX and CSV Files

Configure your spreadsheet, so the source strings, translations, and other important details are extracted correctly.

To configure the columns that will be imported choose Configure columns for import and then specify the types of content stored in each column. Here are the types of content you’ll be able to specify for each column:

  • Identifier – a unique source string identifier, typically an alphanumeric value
  • Source string — source text, content that should be translated
  • Source string/translation — import texts in this column as the source strings for translation and replace them with translations when downloading the resulting file
  • Translation — the resulting translations are added into this column
  • Context — any contextual information that helps to better understand the meaning of the source strings
  • Max. length — defines the max. length of the translated texts

CSV Configuration

Configuration Templates

In case several files have the same configuration scheme, save your current configuration as a template by clicking Templates > Save as template. You’ll be able to apply the template to the newly imported files.

Click Save to proceed.

Multilingual Spreadsheets

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

Column Headers

In order not to translate the column headers, select Do not import the first row (header). CSV Configuration

Configure Several Files at the Same Time

To configure several selected .csv or .xlsx files click the right mouse button and click configure files.

CSV Configuration

Was this article helpful?