Here are some quick hacks and tips to help you to translate foreign languages into English/ other languages to help you follow projects in other languages but also then analyse.
Google Translate
Google Translate can be used for free on Indeemo in 2 ways to understand what is happening day to day on multi language projects.
Method 1) Google Chrome
1. Open the Indeemo Dashboard in your Google Chrome browser
2. Right click anywhere on the browser and select the 'Translate to English' option
This will translate captions, comments and video transcripts however please note that this only translates the text within your browser and is not searchable or downloadable.
Method 2) Using the GOOGLETRANSLATE formula in Google Sheets
On Indeemo, you can export the meta data of all Respondent upload into Excel spreadsheets (csv files). Please find more on this here: Excel Export of your Project
These files will be saved to the Downloads folder on your computer.
To translate the one language into another, follow these steps (you will need a Gmail account and access to Google Sheets to do this).
1 - Go to Google Sheets.
2 - Start a new spreadsheet.
3 - Go to File > Import. Choose the Upload option and browse for the Indeemo export in your Downloads folder
4 - When this is uploaded, insert a column to the right of the column which contains the foreign language you wish to translate
5 - In this new column use the following formula: =GOOGLETRANSLATE(text, source_language, target_language)
- text = the cell containing the foreign language.
- source_language = the 2 country code for the language you need to translate e.g. German = de, French = fr, Spanish = es and so on.
- target_language = the language you want to translate the text into e.g. English = en
6 - Apply this to all rows and repeat for other columns.
For more info on this, click on this Lifehacker article here.
Although this is not perfect translation, it will save you days when it comes to undertaking multi language research projects.
AI View
Clients are using the integrated AI View to help with analysis by being able to prompt other languages in English as well as using the AI to translate quotes to English.
Please find more on this at the following link: AI Analysis
Please also find an example of this below for French:
If you want to enable this feature, please contact [email protected] or your Customer Success Rep.