📄 1. Prepare Your CSV
- The first cell in the CSV should contain
cc_lc[language_field]. This tells the converter which variable to check for language selection.
- The first column contains variable names (e.g.
header_title, subjectline, preheader).
- The first row (after the header cell) contains language codes like
en-UK, nl-NL, fr-FR, etc.
- All other cells are the translations.
- For best compatibility, make sure to save your CSV using ; as the delimiter.
Example:
You can download an example here.
| cc_lc[contact.1794] | en-UK | nl-NL | de-DE |
| subjectline | This is a subjectline! | Dit is een subjectline! | Dies ist eine Betreffzeile! |
| preheader | Don't miss it! | Mis het niet! | Nicht verpassen! |
| header_image | header_en_uk.jpg | header_nl_nl.jpg | header_de_de.jpg |
| header_title | Welcome! | Welkom! | Willkommen! |
📤 2. Upload the CSV
- Click Select File to upload your CSV.
- Choose a default fallback language (e.g.
nl-NL). This will be used if no match is found.
- Click Convert to generate the ESL scripts.
📥 3. Output Explanation
- Translations: Contains ESL variables for all content blocks (except subjectline and preheader).
- Subjectline: Script for subjectline variable only.
- Preheader: Script for preheader variable only.
- Copy Variables: Easy access to the variable names you can paste into your template.
🧩 4. How to use
Subject line and preheader: Click the copy icon in the top-right corner of the code block containing the subject line or preheader. Then paste it into the corresponding field in Emarsys.
Translations: Click the copy icon in the top-right corner of the code block containing the translations, and follow these steps:
- Open the email you'd like to edit in Emarsys.
- Drag the ESL content block to the very top of the email (above the navigation).
- Double-click the text in the content block (the entire line), e.g.
{{ code_from_tool_here }}. Then click the code icon (looks like <>).
- Choose a name for the script. This can be anything, as long as it's clear what the purpose is (e.g. Translations).
- Copy the translation code from this tool and paste it into the Code snippet field.
- Save the snippet. You should now be able to copy a variable from this tool and paste it directly into your email content.
📧 Need help?
Reach out to dion.santegoets@springbokagency.com for support or questions.