Documentation

Management

Translate .csv and .xlsx spreadsheet files

Translate .csv and .xlsx spreadsheet files with WebTranslateIt. 2 min read

WebTranslateIt supports .csv and .xlsx spreadsheet files. WebTranslateIt analyzes the spreadsheet header to recognize the source text from the text to translate.

Supported CSV layouts

Title Default language Default text fr text Variant status
Welcome message English Welcome to Widgets Inc. Bienvenue à Widgets Inc.
Agent signature English The Widgets Inc. Team Toute l’équipe de Widgets Inc.
Key Source FR text
test_key Car Voiture
test.key Bicycle Biciclette
EN text FR text
Car Voiture
Bicycle Biciclette

Key (optional)

If you’d like to assign a key to your translations, you can list the key names under a header, which can be one of:

  • key
  • title

Source text

The source text’s header must be one of:

  • default text,
  • source text,
  • source,
  • default,
  • language code of the source text (for instance en or en-US),
  • language code of the source text followed by the word “translation” (for instance en translation),
  • language code of the source text followed by the word “text” (for instance en text).

Target text

The target text’s header must be one of:

  • target text,
  • target,
  • translation,
  • language code of the target text followed by the word “translation” or “text” (for instance fr translation or fr text).

Developer instructions

If you’d like to leave translators instructions, you can organize them under header. It must be one of the following:

  • title,
  • comment,
  • comments,
  • note,
  • notes,
  • instruction,
  • instructions.

More Information