Help Center Import/Export
Exported CSV - Understanding the File Structure

Exported CSV - Understanding the File Structure

Last updated: a month ago
3 minute read
Yuliia Kovalchuk
Developer at SiteTran

ALL ARTICLES

Help Center

Exported CSV - Understanding the File Structure

Each row in the exported CSV represents a single phrase. The columns contain data related to the phrase, some of which are language-specific (see example on bottom).

All language codes are ISO 639-1 & country codes are ISO 3166-1 Alpha-2. The structure of the columns can be broken down as follows:

Default Columns

These columns will be included in every row:

  • phrase_id: A unique (SiteTran) identifier for each phrase.
  • source_term: The original phrase.
  • target_term_{{language_code}}: Contains the translation of the phrase for the respective selected language.

Optional Columns

  • phrase_key: A unique key associated with each phrase.
  • tag_name: The HTML element’s tag (like div or span) in which the phrase appears.
  • attribute_name: If the phrase appears in an element like an input with a placeholder, or an image with an alt attribute, the attribute will be included.

Optional Language-Specific Columns

These columns are language-specific, meaning that for each selected language, a separate column will be included with the language code appended. Here is the list of optional data columns:

  • translation_approved_{{language_code}}: "Y" or "N" value indicating whether the translation is approved for that language.
  • translator_email_{{language_code}}: The email of the translator.
  • translator_name_{{language_code}}: The name of the translator.
  • phrase_lang_create_dtime_{{language_code}}: The date and time the translation was created, using ISO 8601 format (e.g., 2023-08-30T14:23:00Z).
  • translation_flagged_{{language_code}}: "Y" or "N" value indicating if the translation has been flagged for review.

For example, if you want to export the approval status of a translation for Spanish and French, the exported data will look like this:

phrase_id source_term target_term_es target_term_fr translation_approved_es translation_approved_fr
123456 Hello World Hola Mundo Bonjour Monde Y N
Couldn't find what you were looking for?

In this article

Website Translation Made Easy