Translating Content

Translating Microsoft Excel Files

When translating content in an Excel file, Smartling offers two file options to choose from. Each option has different rules for what is translatable, as well as offering different download options for when translations are complete.

This article will walk you through:

File Options

  1. Microsoft Excel: One File Per Language
  2. Smartling Excel: All Languages in One File

Microsoft Excel

Microsoft Excel results in one file per language. Once the Job has been completed, each language translation will be downloaded in an individual file. You can choose the naming convention for the translated files upon download.

What is translatable?

Choosing this option results in the default behavior for translating a Microsoft Excel file. This means that all content in the file will be ingested for translation, including comments, multiple sheets and tab names. Smartling parsing each cell and tab name as a string.

Data as a result of a formula is not captured and must be typed into the cell without any formulas. Any formatting such as bold or italics will be delivered in the translated file. Image and video files are also delivered in the translated file, but content within them will not be translated. Numbers are also not captured unless it is formatted as a text from the format dropdown. 

The translations will overwrite the source (unless the source has been duplicated in two columns). Formatting such as bold and italics are supported and delivered in the translated file as seen in the source.

The NOTRANSLATE style is supported in Microsoft Excel translation.

Placeholders are not supported. If translating content with placeholders, it is recommended that you convert the Excel file to a CSV file and use a placeholder directive to capture the placeholderized content.

Smartling Excel

Smartling Excel results in all languages in one file. Once the Job has been completed, the translated file will include all translations in one file, a language per column in alphabetical order. You can choose what the column header is labelled as upon download.

What is translatable?

Choosing this option means that each cell of the first column in the first sheet is captured as a string in Smartling, excluding A1 which is a header. Multiple sheets or tab names are not translatable. Images or videos are not supported. Formatting is not supported and will not be delivered in the translated file as seen in the source (if applicable). Numbers, however are translatable without formatting.

The NOTRANSLATE style in not supported for Smartling Excel file translation.

Placeholders are not supported. If translating content with placeholders, it is recommended that you convert the Excel file to a CSV file and use a placeholder directive to capture the placeholderized content.

Unlike Microsoft Excel files, Visual Context is not support in the CAT Tool for Smartling Excel files.

Uploading an Excel File

Method 1: Files Tab

To upload an Excel file for translation:

  • Go to a Smartling Project
  • Click the Files tab
  • Click Upload Files
  • Choose the Excel file from your local drive
    • Smartling will auto-detect an Excel file has been uploaded and the File Upload dialog will prompt you to choose a file option.

Screenshot_2021-04-21_at_14.39.47.png

Method 2: Jobs Dashboard

Alternatively, if you do not have access to the Files tab:

  • Go to the Jobs Dashboard (account-level or project-level)
  • Click Request Translation
  • Click Select files and choose the Excel file from your local drive
    • Smartling will auto-detect an Excel file has been uploaded and the File Upload dialog will prompt you to choose a file option.
  • Complete the Request Translation dialog and click Confirm

Screenshot_2021-04-21_at_14.44.06.png

Downloading a Microsoft Excel

You can download a translated Microsoft Excel in the Files Tab or from within the Job.

Method 1: Files Tab

To download a translated Microsoft Excel file from the Files tab:

  • Go to a Smartling Project
  • Click the Files tab
  • Click the file tile
  • Click Download Files
  • Choose from the Download Options provided in the Download Files dialog
  • Click Confirm and the translated file will download to your local drive.

Method 2: Job Details

To download a translated Microsoft Excel file from the Job Details:

  • Go to the Jobs Dashboard (account-level or project-level)
  • Click the Job name
  • Click Files
  • Click Download Files
  • Choose from the Download Options provided in the Download Files dialog
  • Click Confirm and the translated file will download to your local drive

Download Options

Structure format: Downloaded files can be formatted as subfolders for languages, languages in file name, or subfolder for languages and languages in file name. 

Languages: Select the languages you want to download from the dropdown of all languages that were requested for translation.

Screenshot_2021-04-21_at_14.57.40.png

Downloading a Smartling Excel

You can only download a translated Smartling Excel with all languages in one file from within the Job.

To download a translated Smartling Excel file from the Job Details:

  • Go to the Jobs Dashboard (account-level or project-level)
  • Click the Job name
  • Click Files
  • Click Download Files
  • Choose from the Download Options provided in the Download Files dialog
  • Click Confirm and the translated file will download to your local drive

Download Options

When downloading the translated Smartling Excel file, the Download Job Files dialog will offer the following download options:

Download file: Source File or Translated File. Choose Source File if you want to download the file that was uploaded for translation. Choose Translated File to download the translations.

Structure format: Downloaded files can be formatted as subfolders for languages, languages in file name, subfolder for languages and languages in file name, or all languages in one file. Choose All languages in one file to download one Excel file with all translations in individual columns.

Column Header Format: When choosing to download all languages in one file, the column headers can be titled as Language (Country) only, Locale ID and Language (Country), or Locale ID only. Columns will be listed in alphabetical order.

Languages: Select the languages you want to download from the dropdown of all languages that were requested for translation.

Click Confirm and the translated file will download to your local drive.

Screenshot_2021-04-21_at_11.25.07.png

Was this article helpful?