All Collections
Settings
Localization
Translating Content in Microsoft Excel
Translating Content in Microsoft Excel

Learn how to import and export CSV files in Microsoft Excel for localization.

Simay avatar
Written by Simay
Updated over a week ago

Thanks to our localization logic which uses the UTF-8 character set for all CSV imports and exports, we are able to support as many languages as possible.

Most modern tools, such as Google Sheets, Apple Numbers, and LibreOffice, make it easy to work with these files. You may still need to take extra steps when working with Microsoft Excel to import and export translations.

Downloading the Translation Files

  • Go to the settings of the material you’d like to localize.

  • Turn on the toggle under the Localization tab.

  • Click Download Content CSV

Importing the Translation Files into Microsoft Excel

  • From the Data menu in Excel on a new workbook, select From Text

  • Select the translation file and click Get Data

  • In the opening wizard, select the file origin as Unicode (UTF-8) and click Next

  • Select Comma as the delimiter, and click Next

  • Accept the General settings for data format and click Finish

  • Start importing your data from the downloaded translation file

  • Fill in the translated column for each text

Saving the translation file as CSV

  • Under the File menu, click Export, then Change File Type

  • Select CSV (Comma delimited) and click Save As

  • Go back to the localization settings of your material

  • Upload your translated file

You can refer to the Localization and Multiple Language Management article on how to set up your languages, preview and set live your translated content.

Did this answer your question?