How Much Does Google Spreadsheet Work As a Multilingual Translation Table?
I just tried to check how much useful Google Spreadsheet as a multilingual translation table by using Facebook menu.
First, let me introduce the function to you.
GOOGLETRANSLATE
GOOGLETRANSLATE(“source that you want to translate”, “source’s language”, “target language”)
That’s it. Pretty easy, huh?
GOOGLETRANSLATE(“Hello World”,”en”,”ja”)
GOOGLETRANSLATE(A2,B2,C2)
GOOGLETRANSLATE(A2)
GOOGLETRANSLATE - Docs editors Help
Translates text from one language into another/ Sample Usage GOOGLETRANSLATE("Hello World","en","es") GOOGLETRANSLATE…support.google.com
Translates text from one language into another/ Sample Usage GOOGLETRANSLATE("Hello World","en","es") GOOGLETRANSLATE…support.google.com
Let’s see what I did. As I mentioned, I used facebook menu as an example.
40%
Can you guess what it is? I think of course, you can. This number is matching rate that between Facebook’s translation and GOOGLETRANSLATE function. If you pardon some differences, the rate will be around 85%. I think, that means GOOGLETRASLATE function will work for your Japanese prototyping.
Here is what I did exactly
=IF($E3<>””, GOOGLETRANSLATE($E3,$E$2,F$2),””)