If you need to add many key translations, using a Microsoft Excel spreadsheet to manage the translation equivalents could be better than the web UI. For instance, once the keys have been created, they can be exported as an Excel spreadsheet. An administrator/translator then applies the translations into the spreadsheet and imports them back into the solution.
Follow the next step to download the translation file using the Export operation.
Exporting Translations
On the top right, navigate to → <<your solution>>
On the left, navigate to → Setup
Navigate toLocalization → Translations(1).
Select the Language you need to work on. If the compilation is pending, wait until it is completed before exporting.
Select Export translations to Excel from the Operations dropdown list.
When finished, it will save a compressed zip file named translations.zip in your selected download folder. This zip file contains one Excel per language. For example, en.xlsx, ru.xlsx, and zh.xlsx.
Unzip the translations.zip file and select the language file you want to edit in MS Excel.
Select the JS tab and scroll down to find the text key or use Ctrl-F to search for it. In our example, the key is "My Dasboards."
Then, add the translation in the column VALUE.
When done, save the file in the same format.
Re-build the zip file for uploading. You don't need to use the same name for the zip file, but keep the MS Excel file names.
Importing Translations
On the top right, navigate to → <<your solution>>
On the left, navigate to → Setup
Navigate toLocalization → Translations(1).
From the Operations dropdown list, select Import translations from Excel option.
Click on the "Drop files to attach, or browse", Select the language MS Excel file you want to import. In our example, zh.xlsx.
Click on the Import button to start the import process.
Click on the Publish button to compile the translations added.
