Task · Languages and translations

Translate with a spreadsheet

Send one language out as a spreadsheet, and bring the finished translations back in.

8 steps · About 10 minutes · Needs: More than one language switched on

1. Open Translations, pick the language, and select Translator hand-off

   Your eventSet upTranslations

2. Select Download spreadsheet

   You get a row for everything attendees see in that language. ref names the row, section, item and field say where it belongs in the event, source is your own wording, and translation is the empty column to fill in.

   go.tito.io/acme/summer-fetes-summer-fete/admin/translations/ga/handoff

3. Send the file to whoever is translating it

   They fill in the translation column and send it back. The rest of the file is there to be read.

4. Select Machine-translate it in Google Sheets first if you want a draft to work from

   It gives you a formula that fills the whole translation column in Google Sheets.

5. Choose the finished file and select Review the file

6. Check what the file would change

   New translations, replacements, rows already the same, rows left blank and problems. Every row that would change something is listed below the counts, ticked. Untick any you want to leave out.

7. Select Import ticked translations

8. Publish

   Importing saves the wording without publishing it. Attendees read it from the moment you publish.

Good to know

Rows Tito can't act on are listed under Some rows can’t be imported, each with its row number and its reason. The rest of the file still imports. Two of those reasons are fixed by exporting again:

• A ref names a question from your account's library that this event doesn't ask. Turn on Translate the whole library on the Translations screen and download the spreadsheet again.
• A row was translated from wording that has changed since. The reason quotes the wording as it reads today.