--- schema_version: "1" id: 2c5754363f35c1bf87cedb09332eb204a0770ddc0a8801af09293ab2d9ad1a56 title: Bilingual Translation Files collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/platform/264-0-0/workbench_translation_file_bilingual.md canonical_url: https://help.salesforce.com/s/articleView?id=platform.workbench_translation_file_bilingual.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 68bfa3600f8b64e6db6aa174992009dbeddcfcc1dbccf107757b06b4bddd097b description: Use the Bilingual file to review translations, edit existing translations, and add translations for labels or data that haven't been translated. One Bilingual file is generated for each translation language. products: - Salesforce Platform - Security release: "264" --- # Bilingual Translation Files Use the Bilingual file to review translations, edit existing translations, and add translations for labels or data that haven't been translated. One Bilingual file is generated for each translation language. ### Required Editions

Metadata translation available in: Salesforce Classic and Lightning Experience

Data translation available in: Lightning Experience

Available in: Professional, Enterprise, Performance, Unlimited, and Developer Editions

Data translation applies to: B2B Commerce

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-extend_click-264-0-0-production-enus/5f7d9219-b7b1-4552-8891-f1aba9b289fc/images/icon_note.png) Note Salesforce recommends the XML Localization Interchange File Format (.xlf) for translation files. See Considerations for Working with Translation Files for tips on editing translation files and how to translate rich text field content. ## XML Localization Interchange File Format (.xlf) Bilingual Translation Files Bilingual .xlf translation file content is organized into translation units. Translation units for translated labels contain a `target` tag with the translated value. Untranslated labels have a `source` tag, but no `target` tag. Tell your translators: - For untranslated labels, add a `target` tag containing the translated value after the `source` tag. - If the label’s translation is out of date, replace the text in the `target` tag. Outdated labels have a value of `outOfDate="true"` within the `trans-unit` tag. - To delete a translation, replace the value in the `trans-unit`'s `target` tag with `<>`. When the Bilingual file is imported, the label reverts to its primary label value. - A translated value for the data in the record’s Name field is required to translate data in other fields for that record. For example, you must provide a German translation for the name of a Product before you can translate its description into German. - Deleting the data translated value for a record’s Name field can delete all of that record’s other translated values for that language. See Considerations for Working with Translation Files for more information. - When translating text in a rich text area field, don’t delete HTML tags such as `

` and ``. If you remove those tags, the translated text can be truncated. | Tag | Description | Edit Options | | --- | --- | --- | | `trans-unit` | Translation unit. Contains unique identifiers for the label, including the label’s id, maximum width, and out-of-date indicator. | Do not edit. | | `source` | Label or text in the org’s default language. | Do not edit. | | `target` | The current translation that is visible to end users selecting the target language as their personal language. | Enter the translated value. Add a target tag if needed. Replace a value with `<>` to delete the translation. | | `note` | Description of the metadata label, if defined, in the source language. | Do not edit. Translatable field descriptions each have a separate `trans-unit` tag. | For example, in an org with English as its default language, you build a new custom Business Hours field on the Account object. This label is untranslated. Nickname, an existing custom field on the Account object, has a Spanish translated value of “Apodo.” You change the primary label on the Nickname field from “Nickname” to “Preferred Name.” This label is outdated. Another existing custom Prior Reference Number field on the Account object has an incorrect Spanish translated value of “Número de consulta previa.” Although the translation isn’t out of date, it must be updated to “Número de referencia precedente.” The Name field on a custom Widget object had a primary label of “SLK.” A translator misinterpreted this acronym and entered a Spanish translation of “Flojo.” Although the translation isn’t out of date, you want to revert the translation to the primary label. Finally, a custom Number field on a custom Widget object had a primary label of “Number” and a Spanish translated value of “Número.” You update the primary label to “#” and want to remove the translated value. The exported Bilingual .xlf translation file contains the following row in the OUTDATED AND UNTRANSLATED section. ```markup Business Hours

Preferred Name Apodo The name preferred by this person.

Prior Reference Number Número de consulta previa

SLK Seda

# Número ``` To make the requested changes: - Add a `target` tag with the translated value to the new Business Hours field. - Update the translation values in the target tags for the Preferred Name and Prior Reference Number fields. - To delete the translation of the Widget object’s Name and Number fields, update the translation values in those target tags with `<>`. When this file is imported, those labels revert to the primary label values. - Don’t change the `outOfDate` tag values. When you import the translated file, labels with updated translations are marked as up to date. ```markup Business Hours Horario de oficina

Preferred Name Nombre preferido The name preferred by this person.

Prior Reference Number Número de referencia precedente

SLK <>

# <> ``` ## Salesforce Translation Format (.stf) Bilingual Translation Files ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-extend_click-264-0-0-production-enus/5f7d9219-b7b1-4552-8891-f1aba9b289fc/images/icon_note.png) Note Salesforce doesn’t recommend the STF format for translation files. If you choose to use this format, we don’t recommend editing the file with Microsoft Excel. For more information and restrictions, see Considerations for Working with Translation Files. Bilingual .stf translation file content is separated into translated labels and outdated or untranslated labels. The TRANSLATED section of the .stf file contains text that has been translated and is up to date. When importing, four columns are expected for each label in this section: KEY, LABEL, TRANSLATION, and OUT OF DATE. For this section, tell your translators: - To update a current translation, replace the value in the TRANSLATION column. - To delete a translation, replace the value in the TRANSLATION column with a left and right angle bracket pair (`<>`). When the file is imported, the label reverts to its primary label’s value.

Column	Description	Edit Options
KEY	Unique identifier for the label.	Do not edit.
LABEL	Label or text in the org’s default language.	Do not edit.
TRANSLATION	The current translation that is visible to end users selecting the target language as their personal language.	To edit a translation, replace the translated value. To delete a translation, replace the translated value with `<>`.
OUT OF DATE	Indicates whether the source text has changed since the previous translation. A dash (`-`) indicates that the translation is current.	Do not edit.

The OUTDATED AND UNTRANSLATED section of the file contains labels changed after the label’s translation value was last updated and text that hasn't been translated. When importing, two columns are expected for each label in this section: KEY and LABEL. For this section, tell your translators: - Replace the text in the LABEL column with new or updated translation values. - Delete any values in the TRANSLATED and OUT OF DATE columns. - Delete the corresponding columns in the OUTDATED AND UNTRANSLATED section. - To delete an outdated translation, replace the value in the LABEL column with a left and right angle bracket pair (`<>`). When the file is imported, the label reverts to its primary label’s value. - A translated value for the data in the record’s Name field is required to translate data in other fields for that record. For example, you must provide a German translation for the name of a Product before you can translate its description into German. - Deleting the data translated value for a record’s Name field can delete all of that record’s other translated values for that language. See Considerations for Working with Translation Files for more information.

Column	Description	Edit Options
KEY	Unique identifier for the label.	Do not edit.
LABEL	Label or text in the org’s default language.	Replace label text with new or updated translated values.
TRANSLATION	The current translation that is visible to end users selecting the target language as their personal language. Untranslated labels don’t have a value in this column.	Delete this column and its contents when updating an out-of-date translation.
OUT OF DATE	Indicates whether the source text has changed since the previous translation. An asterisk (`*`) indicates that the label is out of date. A change was made to the primary label and the translation hasn't been updated. Untranslated labels don’t have a value in this column.	Delete this column and its contents when updating an out-of-date translation.

For example, in an org with English as its default language, an existing custom Prior Reference Number field on the Account object has an incorrect Spanish translated value of “Número de consulta previa.” Although the translation isn’t out of date, it must be updated to “Número de referencia precedente.” The Name field on a custom Widget object had a primary label of “SLK.” A translator misinterpreted this acronym and entered a Spanish translation of “Flojo.” Although the translation isn’t out of date, you want to revert the translation to the primary label. You also build a new custom Business Hours field on the Account object. This label is untranslated. Nickname, another existing custom field on the Account object, has a Spanish translated value of “Apodo.” You change the primary label on the Nickname field from “Nickname” to “Preferred Name.” This label is outdated. Finally, a custom Number field on a custom Widget object had a primary label of “Number” and a Spanish translated value of “Número.” You update the primary label to “#” and want to remove the translated value. The exported Bilingual .stf translation file contains these rows in the OUTDATED AND UNTRANSLATED section.

`------------------TRANSLATED-------------------`
`# KEY`	`LABEL`	`TRANSLATION`	`OUT OF DATE`
`CustomField.Account.Prior_Ref_No.FieldLabel`	`Prior Reference Number`	`Número de consulta previa`	–
`CustomField.Widget__c.Name.FieldLabel`	`SLK`	`Seda`	–
`------------------OUTDATED AND UNTRANSLATED-----------------`
`# KEY`	`LABEL`	`TRANSLATION`	`OUT OF DATE`
`CustomField.Account.Business_Hours.FieldLabel`	`Business Hours`
`CustomField.Account.Nickname.FieldLabel`	`Preferred Name`	`Apodo`	`*`
`CustomField.Widget__c.Number.FieldLabel`	`#`	`Número`	`*`

To make the requested changes: - In the TRANSLATED section, update translations by replacing the value in the TRANSLATION column. To delete the translation of the Widget object’s Name field, replace the TRANSLATION value with `<>`. When this file is imported, the label for that Number field reverts to its primary label value of SLK. - In the OUTDATED AND UNTRANSLATED section, replace the value in the LABEL column. Then remove the TRANSLATION and OUT OF DATE columns and their content for the Nickname field. To delete the translation of the Widget object’s Number field, replace the TRANSLATION value with `<>`. When this file is imported, the label for that Number field reverts to its primary label value of #.

`------------------TRANSLATED-------------------`
`# KEY`	`LABEL`	`TRANSLATION`	`OUT OF DATE`
`CustomField.Account.Prior_Ref_No.FieldLabel`	`Prior Reference Number`	`Número de referencia precedente`	–
`CustomField.Widget__c.Name.FieldLabel`	`SLK`	`<>`	–
`------------------OUTDATED AND UNTRANSLATED-----------------`
`# KEY`	`LABEL`
`CustomField.Account.Business_Hours.FieldLabel`	`Horario de oficina`
`CustomField.Account.Nickname.FieldLabel`	`Nombre preferido`
`CustomField.Widget__c.Number.FieldLabel`	`<>`

![Important](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-extend_click-264-0-0-production-enus/5f7d9219-b7b1-4552-8891-f1aba9b289fc/images/icon_important.png) Important Delete the TRANSLATION and OUT OF DATE columns only in the OUTDATED AND UNTRANSLATED section. Rows in that section must have exactly two columns of data to be imported. Rows in the TRANSLATED section must have exactly four columns of data to be imported. #### See Also - [Considerations for Working with Translation Files](https://help.salesforce.com/s/articleView?id=platform.workbench_translation_file_considerations.htm&release=264.0.0&type=5 "Review some important considerations to ensure that your edited translation file can be successfully imported.")