- 23 Aug 2023
- 1 Minute To Read
- Print
- DarkLight
- PDF
Download and translate content using excel format
- Updated On 23 Aug 2023
- 1 Minute To Read
- Print
- DarkLight
- PDF
Whatfix enables content creators to translate content using an Excel format. This can be done by downloading the language file in the excel format from the dashboard and then translating the content.
Download the Excel Format
Use the following steps to download the Excel format:
On the Whatfix dashboard, at the top right, click the Settings icon.
Click Translations.
Click the Download icon next to the language file you want to download.
From the pop-up, choose the .xlsx format option.
Click Download.
The language file gets downloaded in .zip format.
On the Whatfix Dashboard, select the content you want to translate.
Click the Export language files icon.
From the pop-up, choose the .xlsx format option.
Click Download.
The language file gets downloaded in .zip format.
Translate the content in the Excel format
Use the following steps to translate the content in the downloaded excel format,
- Extract the zip file and open the excel format.
If it's the first time you're translating to the language, translate content in the sheet Full.
If you're translating the new content created, translate content in the sheet Delta.
Ensure you are familiar with HTML before modifying the content of the Excel sheet. The Excel sheet contains not only the text content but also the formatting and metadata about the content.
While translating the content of the Excel sheet, ensure you do not modify any content within the <> tags. These are HTML tags and are required to format the content.
- Translate the content in the target language column.
- You receive the following error when the downloaded content exceeds the character limit of the excel and cannot be translated in the excel format.
- Error: Field could not be exported due to Excel character limit. Please update the translation on Whatfix Dashboard.
- This content can be translated using Whatfix UI.
- Once the files are translated, convert them into a .zip file using a compressor tool and upload them.
For more information, see Use excel format to upload translated content.