How to convert English Name into Tamil | Hindi in Excel | Google Translate|Advance Excel Tutorial
This video about Using Google Translate in Your Google Spreadsheets, because Microsoft Excel for Windows natively supports translation through the google sheets. It enables users to use cell value and translate its content into any of the supported languages.
Google Translate works very well together with Spreadsheets to turn whatever language you don’t read into your own (or English of course). Once you’re acquainted with the functions used, you’ll quickly be able to modify your original text into whichever language you require. With a bit of clever work, you could automate processes, by connecting your sheet with If This Then That (IFTTT).
first, we’ll review the formulas.
The formulas
Google spreadsheets has two formulas to help you both translate and identify the language of text within a column.
=GOOGLETRANSLATE(text, [source_language],[target_language])
You can also set the [source_language] to auto-detect by using “auto” instead of a source language code, like this:
=GOOGLETRANSLATE(text, “auto”,”en”) to translate these anchor texts into English.
You don’t need to set the target language, as it will default to the language used in the spreadsheet.
The second formula can help you filter by language:
=DETECTLANGUAGE(text_or_range)
Formula =GOOGLETRANSLATE(C3, Space "en","ta")
link : https://drive.google.com/file/d/1fwb2...
Language Name Language Code
Afrikaans af
Irish ga
Albanian sq
Italian it
Arabic ar
Japanese ja
Azerbaijani az
Kannada kn
Basque eu
Korean ko
Bengali bn
Latin la
Belarusian be
Latvian lv
Bulgarian bg
Lithuanian lt
Catalan ca
Macedonian mk
Chinese Simplified zh-CN
Malay ms
Chinese Traditional zh-TW
Maltese mt
Croatian hr
Norwegian no
Czech cs
Persian fa
Danish da
Polish pl
Dutch nl
Portuguese pt
English en
Romanian ro
Esperanto eo
Russian ru
Estonian et
Serbian sr
Filipino tl
Slovak sk
Finnish fi
Slovenian sl
French fr
Spanish es
Galician gl
Swahili sw
Georgian ka
Swedish sv
German de
Tamil ta
Greek el
Telugu te
Gujarati gu
Thai th
Haitian Creole ht
Turkish tr
Hebrew iw
Ukrainian uk
Hindi hi
Urdu ur
Hungarian hu
Vietnamese vi
Icelandic is
Welsh cy
Indonesian id
Yiddish yi
#ttamiltechnology #googletranslate #Englishtotamil