Top
Download and translate content using excel format
  • 02 Sep 2024
  • 2 Minutes To Read
  • Dark
    Light
  • PDF

Download and translate content using excel format

  • Dark
    Light
  • PDF

Article summary

Whatfix enables content creators to translate content using an Excel format. This can be done by downloading the language file in Excel format from the dashboard and then translating the content.

Download the Excel Format

Use the following steps to download the Excel format:

Download the Excel format for all content

  1. On the Whatfix Guidance dashboard, click Settings.
    2024-07-05_11-23-42.png

  2. Click Translations.
    ia_left%20nav_translations

  1. Click the Download icon next to the language file you want to download.
    DB_Translations_ClickDownload.png
Note:

If you have the new translation experience enabled, click the Download icon in the Translations page under the Languages section.
db_download_translation_file

  1. From the pop-up, choose the .xlsx option.
    choose_xlsx.png

  2. Click Download.
    xlsx_click_download.png

your title goes here

The language file gets downloaded in .zip format.

Download the Excel format for select content

your title goes here

The following actions can only be performed by users with Account Manager or Content Manager role. Users with Translator roles can use the above mentioned process to download the Excel format.

  1. On the Whatfix Guidance dashboard, click Content.
    ia_left_nav_content

  2. Click All content.
    ia_dashboard_left_nav_all_content

  1. Select the content you want to translate.
    DB_translation_selectContent.png

  2. Click the Export language files icon.
    clm_db_export_language_files

your title goes here

If you have the new translation experience enabled, click the Download language files icon.
db_click_download_language_files

  1. In the Translate in dropdown, select the language you want to translate your content into.
    select_lang_dropdown.png

  2. Click .xlsx.
    choose_xlsx_select_content.png

  3. Click Download.
    xlsx_select_content_click_download.png

your title goes here

The language file gets downloaded in .zip format.

Translate the content into Excel format

Use the following steps to translate the content in the downloaded Excel format:

  1. Extract the zip file and open the Excel file.
your title goes here
  • If it's the first time you're translating to the language, translate the content in the sheet Full.
    DB_Translation_Excel_Full.png

  • If you're translating the new content created, translate the content in the sheet Delta.
    DB_Translation_Excel_Delta.png

your title goes here
  • 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. Modifying HTML tags results in your content not being displayed correctly.

  1. Translate the content in the target language column.
    DB_Translations_Translate content.png
your title goes here
  • You receive the following error when the downloaded content exceeds the character limit of the Excel file and cannot be translated.
    • Error: Field could not be exported due to Excel character limit. Please update the translation on Whatfix Dashboard.
  • This content can be translated using the Whatfix UI.
  1. 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.


Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.