Music: https://www.bensound.com/royalty-free-music

The translation spreadsheet add-on allows copy to be exported from Taxi as a spreadsheet where translation can take place.  This is then imported back into Taxi and translated versions of the email are made. Microsoft excel (xlsx files) are used which means it is compatible with Excel, Google Sheets and many other systems and services.

To enable the translation spreadsheet:

1. Head to Integrations

2. Select the 'Add-ons' tab and click set up under translation spreadsheet

3. You will be asked to upload a spreadsheet file
An example template is available to get you started here.

A blank excel file will also work.

There is a dropdown to choose how you want the spreadsheet to behave when you download it from a mailing.

• ‘Use language codes to map versions to languages’: Each version is assigned a language code and each language code will become a column header when you download the spreadsheet for translations. You can assign the same language code to multiple versions in a version set if they are the same language, for example a German and Swiss version that are both translated to German.

• ‘Use version name as a column header’: When assigning language codes there is a predefined list in Taxi. If you use custom language codes that are not available in Taxi, you can choose this option. You’re able to name the versions as your language codes and when you download the spreadsheet the version name will be the head of each column.

Select if you want fields with the same label to be combined into a single row or if you want them to be shown on separate rows for translation. An example of this is if you have multiple CTAs these can be shown grouped together in a single row or each CTA is shown on a separate row.

Using the translation spreadsheet:

1. Create a Mailing in Taxi and add the source language content to your Parent Version

2. On the Versions page select the Download Spreadsheet option
This contains content from the Parent version that needs to be translated

3. Add translations to the spreadsheet
Example below:

4. Once you have added your translations upload this spreadsheet back into Taxi by selecting the Upload Translations option on the Versions page

5. Translations will now appear in all versions

6. By default, only text goes into the spreadsheet but you can get anything in the spreadsheet if you want.

There are two ways to do it.

1. Add translatable=“true” to the field in the EDS

2. In the field configuration tab tick the option that says 'Send content to translation add-ons'

Other things to note

Links

Links coming from link fields appear in their own cell in the spreadsheet (if you have chosen for these to be included when downloading it). Inline links in rich text fields behave differently.
The links themselves don't appear in the spreadsheet, but in the cell with the text there is a number and square brackets signifying which text is linked and how many links there are in that section of text.

So this in the Taxi editor

Will look like this in the spreadsheet

Note: You can't edit rich text links in the spreadsheet

Personalisation fields

Personalisation fields added to text fields appear as their ID in the spreadsheet

The ID can be found on the personalisation tab under dynamic content

Styling

For the styles that are available by default in rich text fields (bold, italic and underline), they appear in the spreadsheet like this.

If you want to use these styles in other version columns you can use the spreadsheet built in bold, italic and underline styles.

If you have custom styles in the editor, such as changing the colour of some text, it will appear like this in the spreadsheet.