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 |
