Making Multilingual Chat with Speakers of Different Languages Using Google Sheets
We can speak and write in English so how do you converse with a person in China who writes Mandarin but he does not understand a word of English in that situations Google Translate is a good option but it is going to be tedious for you to translate each and every sentence manually before sending them through messenger.
when there is no ‘common’ language between the two parties how do we break down the language barrier and chat with someone in another country. for this Microsoft is building a version of Skype that allows real-time translation for voice and video calls.
Now there is another option for people who are looking to have multi-lingual text chats Google Sheets. In this two people can work on Google Sheet simultaneously like simple chat client. And if you integrate the same sheet with Google Translate which is easy the text typed inside Google Sheets can be translated in real-time and automatically.
Multi-lingual Chat with Live Translation
Here you have two participants speaking different languages who have opened Google Sheet at the same time. There are 2 columns in the sheet for each participant. Participant A can write the text in his own language in column A and the translated version in Participant B language will appear instantly in the second column and vice-versa.
To started open the Google Sheet and choose a File ->make your own copy of the sheet in your Google Drive. Now press the share button in your sheet and share it to another person with “edit” permissions.
All you have to do now is put your name and your friend’s name in cells C4 and G4. Also select your native languages from the drop-down in cell C5 and C6. Now type anything in the yellow cell and it will appear in the second column in the B’s participant language.They can write in the green cell and the translated text would show up in your column.
The sheet is powered Internally by the Google Scripts. And it supports all pairs of languages that are supported by Google Translate from Hindi to French to German to Tamil.
We can speak and write in English so how do you converse with a person in China who writes Mandarin but he does not understand a word of English in that situations Google Translate is a good option but it is going to be tedious for you to translate each and every sentence manually before sending them through messenger.
when there is no ‘common’ language between the two parties how do we break down the language barrier and chat with someone in another country. for this Microsoft is building a version of Skype that allows real-time translation for voice and video calls.
Now there is another option for people who are looking to have multi-lingual text chats Google Sheets. In this two people can work on Google Sheet simultaneously like simple chat client. And if you integrate the same sheet with Google Translate which is easy the text typed inside Google Sheets can be translated in real-time and automatically.
Multi-lingual Chat with Live Translation
Here you have two participants speaking different languages who have opened Google Sheet at the same time. There are 2 columns in the sheet for each participant. Participant A can write the text in his own language in column A and the translated version in Participant B language will appear instantly in the second column and vice-versa.
To started open the Google Sheet and choose a File ->make your own copy of the sheet in your Google Drive. Now press the share button in your sheet and share it to another person with “edit” permissions.
All you have to do now is put your name and your friend’s name in cells C4 and G4. Also select your native languages from the drop-down in cell C5 and C6. Now type anything in the yellow cell and it will appear in the second column in the B’s participant language.They can write in the green cell and the translated text would show up in your column.
The sheet is powered Internally by the Google Scripts. And it supports all pairs of languages that are supported by Google Translate from Hindi to French to German to Tamil.
This comment has been removed by a blog administrator.
ReplyDelete