The most popular office program can now be a tool for translation management. Localize your application with Microsoft Excel or any other spreadsheet tool. Translations and translation keys can be exported using a Web client, API or CLI to the Excel spreadsheet. You can share the file with others and import it later to update the translations. Use Excel as a localization tool!
File format example
Description column
Excel file format offers additional DESCRIPTION column for providing a description for translation keys. Please remember that column names are case-sensitive;
that means only uppercase DESCRIPTION column will be recognized. Descriptions uploaded via CLI are set as "Code Descriptions" by default.
If you want to update translator descriptions, you have to add --uploadOptions UPDATE_DESCRIPTIONS to your CLI command.
Namespace column
Excel file format offers additional NAMESPACE column for providing translation key namespaces.
The NAMESPACE column is exported only if at least one translation key has a namespace.
Options column
Excel file format offers additional OPTIONS column for providing additional options and features for specific translation keys.
that means only uppercase OPTIONS column will be recognized.
Supported options:
BLOCK_MODIFICATION- blocks option to edit translation and key (delete is still available)
Example
You can import translation file with BLOCK_MODIFICATION option for some translation keys.
BLOCK_MODIFICATON blocks option to change translations and translation keys in the 'Translations' tab.
Upload with CLI
simplelocalize upload --apiKey <PROJECT_KEY> \
--uploadFormat excel \
--uploadPath ./my-excel-file.xlsx
Learn more about SimpleLocalize CLI and translations upload feature.
Download with CLI
simplelocalize download --apiKey <PROJECT_KEY> \
--downloadFormat excel \
--downloadPath ./my-excel-file.xlsx
Learn more about SimpleLocalize CLI and translations download feature.
Import with API
curl
--request POST \
--url 'https://api.simplelocalize.io/api/v2/import?uploadFormat=excel' \
--header 'x-simplelocalize-token: <API_KEY>' \
--form file=@/path/to/your/my-excel-file.xlsx
Learn more about importing translations with API
Export with API
curl
--request GET \
--url https://api.simplelocalize.io/api/v3/export?downloadFormat=excel \
--header 'x-simplelocalize-token: <API_KEY>'
Learn more about exporting translations with API