How to translate an email with a spreadsheet

Requirements

You must have the Editor, Developer or Admin role to upload a translation spreadsheet. If your organization uses custom roles, your role needs the Update Emails and Add/Remove Locales from Emails permissions.

This article shows you how to translate an email using a CSV spreadsheet.

A translation spreadsheet contains all of an email’s translatable content, with one row for each locale. It’s useful when you work with a translator or translation agency, or prefer to translate in a spreadsheet application. You can use it to add new locales and to update existing ones.

Before you begin

• Finish the content in your email’s default locale.
• Check which field types are included in the spreadsheet in your translatable field types. Subject lines and preheaders are always included.

Download the spreadsheet

1. Open the email in the editor.
2. In the toolbar above the preview, click the globe icon (Locales).
3. Click Import / export translation spreadsheet.
4. Click Download spreadsheet (CSV).

Translate the content

1. Open the CSV in a spreadsheet application, such as Excel or Google Sheets. Each row holds one locale’s content. The locale column shows the locale code, such as en-US or fr-FR, and the other columns hold the content.
2. Add or update translations:
   • To add a new locale, copy the default locale’s row, change the locale value to the new locale’s code, and replace the content with your translations.
   • To update an existing locale, edit the content in that locale’s row.
3. Save the file as a CSV.

Don’t change the column headings in the first row, or the spreadsheet won’t upload.

Leave any HTML tags, such as <strong>, and any personalization tags in place, and only translate the text around them. Otherwise, the translated locale loses that formatting or personalization.

Upload the translated spreadsheet

Caution

Uploading replaces all of the content for each locale in the file, including with blank cells. Leave content in place for anything you want to keep.

1. In the editor, click the globe icon (Locales), then click Import / export translation spreadsheet.
2. Click Choose file and select your CSV.
3. Click Upload spreadsheet.

The editor reloads with the uploaded content. Any new locales in the file are added to the email. Next, review each locale.

If the upload says the headers don’t match, the email’s components or fields have changed since you downloaded the spreadsheet. Download a new spreadsheet, copy your translations into it, and upload it again.