Categories
Design

How to use google translate directly in google sheets

How to use google translate directly in google sheets

A new edition of this article for 2019 can be found here.

In recent years, machine translation has grown in sophistication and accessibility beyond what we imaged. Many people have suggested that human translators could be an endangered species.

There are currently a number of online translation services ranging in ability. Google Translate is one of the most used machine services because of its convenience. It currently translates over 100 billion words a day.

However, the ubiquity of people using the online tool has caused many to question the accuracy software. How accurate is Google Translate?

Keep reading to find out how good Google Translate is. Let’s take a look!

The New Developments in Machine Translation

Launched in 2006 as a statistical machine translation, Google Translate has improved dramatically since its creation.

Most significantly in 2017, Google moved away from Phrase-Based Machine Translation (PBMT) and was replaced by Neural Machine Translation (NMT).

Even though this started by offering translations from Chinese to English, it has since expanded to over one hundred languages.

The difference between the previous service and now, according to a Google spokesperson, Barak Turovsky, is “we translate whole sentences at a time, instead of pieces of a sentence“.

This is further supported by the Google Translate Community which includes people from around the world translating texts.

These new developments mean that Google Translate is now 60 percent more accurate than before.

Another Google spokesperson, Quoc Le, conducted an interview with MIT Technology Magazine. Le stated that the hope is “this research increases the ability for people around the world to communicate with others regardless of what languages they speak”.

Google’s Test of Accuracy

It’s clear that Google Translate is an intelligent and practical tool for many situations. This doesn’t mean it produces an accurate translation of the original content.

There is often nuance and subtlety in the written word that a machine can’t comprehend. As a result, the content can rarely be directly translated.

According to Google’s own tests, the accuracy of the translation depends on the languages translated.

The test required mother-tongue language speakers to rate Google Translate with a scale between 0 and 6. The average rating achieved an impressive 5.43 rating.

It makes sense that it’s easy for Google Translate to convert French to English since the two languages share so much.

But what about languages that require a greater jump from one to the other? The Chinese to English translation received a rating of only 4.3 out of 6. Other languages have even lower scores because of their complexity and differences.

Double Meanings and Ambiguity

Language is very complicated and ambiguous. Many words have several meanings that change according to the context of the sentence.

While Google Translate attempts to account for this, it often makes mistakes when it comes to translating the meaning.

For example, Douglas Hofstadter in the Atlantic pointed out the way Google Translate often mistranslates German words into English.

The German word “Wissenschaftler” could mean either “scholar” or “scientist”. Both of these words have quite different meanings in the English language.

This is further complicated when you consider gendered German nouns. In this case, “Wissenschaftler” is masculine. If you have a female scientist or scholar it’s “Wissenschaftlerin”, or “Wissenschaftlerinnen.”

If you want to emphasize “female scholars” in German, this would translate as scientists in the German Google Translate version. This illustrates the problems that face Google Translate’s attempts at accuracy.

What Do You Need in a Translation?

Before we can answer how good Google Translate is, it’s important to consider why you want a translation in the first place.

Are you looking for the basic meaning of a text or some top-quality content? Ask yourself these 3 questions:

1. What does the Audience Expect?

How accurate do audiences expect Google translate to be?

Are they looking for flawless, tailor-made content? Do they want to understand the deeper meaning of the text?

Even though Google might be able to provide translations that give the audience the gist of the original text, if you’re looking for top-quality translated content, you might have to look elsewhere.

2. What’s the Topic?

The accuracy of the machine translation depends on the topic that’s being translated.

If the content translated includes a lot of technical or specialized things, it’s unlikely that Google Translate will work.

3. Quality of the Text?

How important is the quality of the text? Do you want the text written in a particular style or format and have the translation convey that meaning?

Google can translate content written in a consistent manner with the general use of words and phrases.

If the text includes jargon, slang and colloquial words this can be almost impossible for Google Translate to identify. If the tool is not trained to understand these linguistic irregularities, the translation will come out literal and (most likely) incorrect.

How Accurate is Google Translate?

Even though Google Translate is an excellent translation app, there are always going to be potential inaccuracies in the end product.

Language is a complicated and subtle thing. We can’t expect machines to understand every aspect of the way human beings communicate with each other.

That’s why the answer to how accurate is Google Translate is that it still has a ways to go before it can consistently translate without mistakes.

That’s why if you want 100 percent professional accuracy for your translation, it’s important to hire a professional human translator. To find out more about our translation services, get in touch with us today.

How to use google translate directly in google sheets

Google Translate is a handy tool when learning a new language. With the Google Translate app, you have various options available such as identifying a language or using your camera to translate a sign (among others). It’s also possible to use Google Translate in other Google services such as Sheets. By inserting a simple code into a cell, you can translate any language into another. Let’s see how it’s done.

Translate Any Language in Google Sheets

To use Google Translate, open Google sheets, and type the word you want to translate in any cell. For example, type the word “cat” in cell A1. Click on the cell, and type =googletranslate , and the option to select Google Translate will appear.

Your second option is to enter the entire code yourself: =GOOGLETRANSLATE(“text”, “source language”, “target language”)

Replace “text” with the text you want to translate. The source language needs to be the language the text is in, and the target language has to be the language you want the text to be translated into.

How to use google translate directly in google sheets

You can also replace “text” for the cell that the text you want to translate is in. For example, if the text you want to translate is in A1, instead of typing the quotation marks and the word text, replace it with A1, but don’t add the quotation marks. Click on the cell, and it will be added automatically.

Don’t write out the entire language. For example, when choosing either the source or target language, don’t type English, type “en” instead. If the language you’ve selected is Spanish, type “es.” You will get an error message if you type the full name of the language.

If you don’t like any of the previously mentioned options, Sheets has a Google Translate option hidden deep into its options. Go to “Insert -> Functions -> Google -> Google Translate.”

How to use google translate directly in google sheets

Apply Translation Code to Various Cells Simultaneously

You don’t have to repeat the process for every word you want to translate. Let’s say that you tried out the methods to only translate one word in cell A1. Click on the cell that the text was translated to. Place the cursor at the bottom right of the cell until you see a cross symbol.

When you see it, click and drag it so it covers the number of cells you want. When you let go, Google sheets will place a message in each cell, letting you know that an error has occurred. This error message will gradually disappear as you type the text you want to translate in the cell beside it.

How to use google translate directly in google sheets

Once you’ve filled all the empty cells, you’ll only have to repeat the process if you want to translate more text.

The words you want to translate don’t have to be right next to each other. For example, if the word you want to translate or detect the language is in cell F10, add that position and type =detectlanguage(F10) and press Enter. The initials of the language will appear in the cell you’ve highlighted/chosen.

Detect Languages in Sheets with Google Translate

It’s a good idea to be prepared for everything, and that includes dealing with a language you can’t identify. Google Translate has that covered too.

In one cell, type the text in the language you want to identify. In the cell to the right, type =detectlanguage . After typing the first few letters, the option will appear.

How to use google translate directly in google sheets

Select the option and enter the cell whose language you want to detect and press Enter. Sheets will place the initials of the language to the right.

You can use the same drag option you used before when you wanted to translate different words. Place the cursor on the corner of the cell that has the language identifying code, and every word you type to the left of it will be translated.

Conclusion

Now you don’t have to switch between the Google Translate app and Google Sheets to either translate or identify a language. It can all be done without having to leave Sheets! Let us know how this works for you.

Just a simple guy that can’t enough of Technology in general and is always surrounded by at least one Android and iOS device. I’m a Pizza addict as well.

  • Facebook
  • Tweet

Affiliate Disclosure: Make Tech Easier may earn commission on products purchased through our links, which supports the work we do for our readers.

Marshall Gunnell is a writer with experience in the data storage industry. He worked at Synology, and most recently as CMO and technical staff writer at StorageReview. He’s currently an API/Software Technical Writer at LINE Corporation in Tokyo, Japan, runs ITEnterpriser, a data-storage and cybersecurity-focused online media, and plays with development, with his RAID calculator being his first public project. Read more.

How to use google translate directly in google sheets

Google Translate lets you translate words or phrases from one language to another, but did you know that there’s a formula you can use to translate a batch of words directly in Google Sheets? Here’s how to do it.

Translating Text in Google Sheets

Integrating Google Translate with Google Sheets was a good call. Now you no longer have to switch back and forth between tabs to translate text. Translating text in Sheets is as simple as inputting a formula. Here’s the structure of the formula:

How to use google translate directly in google sheets

When entering the text to be translated, you can either type the actual word in the formula itself, or you can input a cell containing the word to be translated.

In this example, we want to translate the English words in column A (which we’ve named “English”) into their Chinese equivalents in column B (which we’ve named “Chinese”). Since we have the words already in the sheet, we can just call the cells that contain them. Here, we’re calling cell A2, which contains the word “Cake.”

How to use google translate directly in google sheets

Note: If you input the text directly in the formula, you must include quotation marks around the word. If you enter the cell in which the word is residing, you must leave off the quotation marks.

Next in our formula comes the source language. When entering the source language, you need to enter the two-letter language code. If you’re unsure of what the source language is, you can enter in “auto” and Google will auto-detect the language. We know “cake” is an English word, so we’ll use “en” here. Note that you must include the quotation marks around the two-letter language code.

How to use google translate directly in google sheets

Finally, we need to input our target language in the same way. Here, we’re using “zh”—the two-letter code for Chinese.

How to use google translate directly in google sheets

Once you’re finished, press Enter and watch the magic happen.

If you have a list of words in column A that you’d like to translate, all you need to do is select the cell that contains the formula we just entered, click and grab the bottom-right corner, and drag to the desired row.

As with any translation software out there, this is not always 100% accurate. For less complicated vocabulary though, this should be a reasonably reliable solution.

How to use google translate directly in google sheets

Machine translation continues to evolve. With artificial intelligence in the mix, machine translations seem almost human. Google Translate is one of the top players in this market, supplying everything from basic text translation to browser-embedded (Chrome) translation to a robust translation API. But even with all of these options, is Google Translate good enough?

How to use google translate directly in google sheets

Make sure the machine is representing you appropriately! (image source: Flickr/Mirko Tobias Schäfer)

Successful translation, machine-generated or otherwise, still depends on three core content facets: audience, subject matter, and quality.

Audience

Audience expectations matter. Do your audiences expect content tailored to them, or are they accepting of potential translation flaws?

Your audience may be more forgiving of translation errors or awkward phrasing in general content. They may be less forgiving (or insulted) if instructional or targeted content contains obvious flaws.

Regarding Google Translate, using their API to directly translate and publish web content might be good enough. But if your audience expects tailored content, additional steps are needed in the translation process to ensure the content speaks to them.

Know your audiences’ expectations before deciding on your translation approach.

Subject matter

The subject matter of your content also affects machine translation accuracy. Will machine translation tools understand your terminology?

Machine translation tools are only as smart as they are trained to be. If you use special terminology, or if your content is highly technical and must be absolutely accurate (such as with life sciences), you must train the tool to understand this content.

Use a corpus of your content to train the tool how to appropriately translate your content into other languages. This process is neither quick nor easy, but is essential for accurate machine translation.

Content quality

Content quality is always important, but it is critical in the case of machine translation. Are you building quality control into source content development? Do you strictly enforce style, terminology use, and content structure?

Machine translation is most successful with content that is consistently written, using specific terms and phrases in specific contexts. Frequent use of synonyms in varying contexts can confuse machine translation tools. Likewise, inconsistent content structure can result in different translations for similar strings of text.

Slang, colloquialisms, and jargon are also problematic. The machine translation tool must be trained to understand these constructs and equate them to culturally appropriate localized phrases. If not, the translations will be literal, which could be embarrassing or downright offensive.

If stylistic inconsistencies, slang, colloquialisms and such cannot be avoided, consider using human translators and employ transcreation where culturally appropriate translations of more colorful phrasings are needed.

So, is Google Translate good enough?

Yes and no. It really depends on how you intend to use it, and whether potential inaccuracies are allowable.

If your audience does not need or expect a 100% accurate translation, then Google Translate may be good enough. If accuracy is critical, you may need to look at other translation options, or at least build in a thorough review process and custom corpus maintenance into your use of neural machine translation (NMT).

Related posts:

  • How to use google translate directly in google sheetsA hierarchy of localization needs
  • How to use google translate directly in google sheets2017 content strategy trend: the rise of the machine…
  • How to use google translate directly in google sheetsLocalization strategy: Your key to global markets
  • How to use google translate directly in google sheetsLocalization testing: it’s not just translation
  • How to use google translate directly in google sheetsWarning signs: localization strategy needed
  • How to use google translate directly in google sheetsTerminology in localization: it’s not just for word nerds
About the Author

Bill Swallow

Bill Swallow, Director of Operations, partners with enterprise content owners to design and build content systems that solve complex information management and localization problems.

When it comes to doing some everyday jobs with letters, documents, calculations, analytics and presentations, Google Docs, Sheets and Slides is way better than the paid alternatives if you aren’t looking for those extra premium functionalities, which cost a fortune. When it comes to Google Office Suite, it has almost everything you will need, in a very easy and user-friendly user interface. While Microsoft Office or other similar platforms undoubtedly offer additional features, the ability to work with Google services right from the Office Suite is something, most users will find in handy. One such ability is the ability to use Google Translate right from Google Sheets.

But what is the importance of using Google Translate right from Google Sheets in the first place! Just consider, you have to send emails to your customers or other offices in a different state or country in different languages. With the Google Translate functionality in Google Sheets, just write the email in English or any other preferred language, and leave the rest to Google Translate. It can also be extremely useful for students learning a new language, as they can keep a track of the new words they learn every day, and catalyze the process of learning. There are different other ways, the ability to use Google Translate within Google Sheets can be useful for the users.

So without further delay, let’s dive into how you can use Google Translate right from Google Sheets like a charm.

Use Google Translate in Google Sheets

The steps to follow

Step 1: Open Google Sheets , and select the cell, where you want to get the translated output from the text in the source cell.

Step 2: Type in the Google Translate function in the below-mentioned format.

=GOOGLETRANSLATE(“text/input cell”,”input language”,”output language”)

For example, you want to convert an English text in cell A3 and place the output in cell B3 in Hindi.

The function in cell B3 will be as below.

=GOOGLETRANSLATE(A3,”en”,”hi”)

=GOOGLETRANSLATE(A3,”auto”,”hi”)

Here ‘en’ is the code for the language English , and ‘hi’ is the code for language Hindi . You can alternatively put ‘Auto’ for the input language argument to automatically detect the language of the input text.

Step 2: Just hit the enter key, and the output in the Hindi language will be shown in the desired cell, in the following way.

How to use google translate directly in google sheets

Thus, you might have already got the catch. You have to know the two-letter language code for this function to work. It is quite easy to get the two-letter language code for all the supported languages on Google Translate. Let’s find out how.

Step 3: Just open Google Translate , and select the input and output languages the normal way you do on Google Translate.

Step 4: I have chosen English as the input language, and Hindi as the output language.

Step 5: Now observe the address bar closely.

Step 6: Look at “ translate&sl=en&tl=hi ’ in the end of the URL. Here ‘en’ is the code for the English Language, and ‘hi’ is the code for the Hindi language.

Just change the input and output language to see the change in the address bar automatically.

I have changed the output language to Bengali , and here is the change in the URL.

So that was it. Not only texts, but you can also translate a complete sentence with the help of this feature. A text string of a maximum of 5000 characters can be translated using Google Translate, and I hope, the same limit applies for this translate function on Google Sheets, as well. I didn’t try finding the limits of this function on Google Sheets, as most users will not need to push the function to its limits. But you are always welcome to check out how much it has the ability to handle.

Hope the information was helpful for you. Did you face any troubles? Feel free to comment the same down below.

How to use google translate directly in google sheets

Do you know how you can use Google Translate in Google Sheets? I think we all are aware by now that Google has done a marvelous job by not only coming up with the Google Translate feature but also by integrating it across various applications and Google products.

Google Translate service is functional across Google Chrome browser, Google Maps and it is even available as an Android and iOS app. It is also available with Google Assistant and Google Sheets.

There are several aspects on which I would first like to throw some light before I dive deeper into the steps on how Google Translate functions in Google Sheets? We will first begin with what is Google Translate?

What is Google Translate?

It is a multilingual machine translation service by Google which is accessible on multiple applications running on various platforms and is completely free.

Google Translate was originally launched in April 2006. Back then, it took assistance from the United Nations and European Parliament transcripts to collect linguistic data. In November 2016, Google Translate service switched to a neural machine translation engine known as Google Neural Machine Translation (GNMT) which is able to convert whole sentences instead of translating fragments.

Currently, it supports 103 regional and global languages. In April 2016, it was estimated that there are more than 500 million users of this service with 100 billion words translated daily.

Google Translate can help to conduct written word translation, web translation, document translation, speech translation, mobile app translation, image translation, and even handwritten translation.

Google has also enhanced the Word Lens feature to offer more support for the Chinese language. This feature lets you point a phone camera at a printed text and view the translation on the camera screen.

Products & Services Integrated with Google Translate:

  • It is integrated with the Google Chrome browser.
  • The Google Translate app is available for Android as well as iOS.
  • Google Translate API (application programming interface) was launched for software developers to help them develop software applications as well as build browser extensions.
  • Google Assistant is also supported by Google Translate. The devices on which it functions with the help of Google Translate feature are Google Home and Google Pixel Buds.

How to Translate Text in Google Sheets?

If you are wondering how to translate any language in Google Sheets, then you must know that it’s very easy to do so with the help of a formula.

Let us first understand the basic structure of the Google Translate formula.

Syntax

=GOOGLETRANSLATE (“text”, “source_language”, target_language”)

Components of The Formula

Text – This is the word that Google Translate formula has to translate.

Source_language – This is the two-letter code of the source language. It is the language that has to be translated.

For example, if the text is in English, then the source language code will be ‘en.’

Target_language – This is the two-letter code of the target language. The target language is the language in which the text has to be translated.

For example, if you want the translation to happen in German, then the target language code should be ‘de.’

If you have a list of words that need to be translated, then you can enter all of them into a particular column of a spreadsheet, then enter the formula in the adjoining cell, and execute it.

After this, all you need to do is click and hold the bottom-right corner of the formula containing cell and drag till where you need the words to be converted, as shown in the below example.

Alternatively, you can also use the keyboard shortcut CTRL + D to copy down the formula in the cells below to execute the formula for all the words and phrases at one go.

Here is a list of the Google Sheets Translate Codes:

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

Source: Labnol

Conclusion

Incorporation of Google Translate feature into various other services and products of Google has been of immense utility to worldwide users. This allowed people to widely use Google products without being limited by the use of certain languages only. Google quickly became a unified platform in the world for people from different ethnicities, having different dialects and lingo.

The integration of Google Translates into Google Sheets to convert texts further simplified things as it allowed conversion of words, phrases, and sentences in bulk quickly with the help of the Google Translate formula.

How to use google translate directly in google sheets

Google Translate lets you translate words or phrases from one language to another, but did you know that there’s a formula you can use to translate a batch of words directly in Google Sheets? Here’s how to do it.

Translating Text in Google Sheets

Integrating Google Translate with Google Sheets was a good call. Now you no longer have to switch back and forth between tabs to translate text. Translating text in Sheets is as simple as inputting a formula. Here’s the structure of the formula:

How to use google translate directly in google sheets

When entering the text to be translated, you can either type the actual word in the formula itself, or you can input a cell containing the word to be translated.

In this example, we want to translate the English words in column A (which we’ve named “English”) into their Chinese equivalents in column B (which we’ve named “Chinese”). Since we have the words already in the sheet, we can just call the cells that contain them. Here, we’re calling cell A2, which contains the word “Cake.”

How to use google translate directly in google sheets

Note: If you input the text directly in the formula, you must include quotation marks around the word. If you enter the cell in which the word is residing, you must leave off the quotation marks.

Next in our formula comes the source language. When entering the source language, you need to enter the two-letter language code. If you’re unsure of what the source language is, you can enter in “auto” and Google will auto-detect the language. We know “cake” is an English word, so we’ll use “en” here. Note that you must include the quotation marks around the two-letter language code.

How to use google translate directly in google sheets

Finally, we need to input our target language in the same way. Here, we’re using “zh”—the two-letter code for Chinese.

How to use google translate directly in google sheets

Once you’re finished, press Enter and watch the magic happen.

How to use google translate directly in google sheets

If you have a list of words in column A that you’d like to translate, all you need to do is select the cell that contains the formula we just entered, click and grab the bottom-right corner, and drag to the desired row.

How to use google translate directly in google sheets

As with any translation software out there, this is not always 100% accurate. For less complicated vocabulary though, this should be a reasonably reliable solution.

How to use google translate directly in google sheets

Google Translate is a handy tool when learning a new language. With the Google Translate app, you have various options available such as identifying a language or using your camera to translate a sign (among others). It’s also possible to use Google Translate in other Google services such as Sheets. By inserting a simple code into a cell, you can translate any language into another. Let’s see how it’s done.

Translate Any Language in Google Sheets

To use Google Translate, open Google sheets, and type the word you want to translate in any cell. For example, type the word “cat” in cell A1. Click on the cell, and type =googletranslate , and the option to select Google Translate will appear.

Your second option is to enter the entire code yourself: =GOOGLETRANSLATE(“text”, “source language”, “target language”)

Replace “text” with the text you want to translate. The source language needs to be the language the text is in, and the target language has to be the language you want the text to be translated into.

How to use google translate directly in google sheets

You can also replace “text” for the cell that the text you want to translate is in. For example, if the text you want to translate is in A1, instead of typing the quotation marks and the word text, replace it with A1, but don’t add the quotation marks. Click on the cell, and it will be added automatically.

Don’t write out the entire language. For example, when choosing either the source or target language, don’t type English, type “en” instead. If the language you’ve selected is Spanish, type “es.” You will get an error message if you type the full name of the language.

If you don’t like any of the previously mentioned options, Sheets has a Google Translate option hidden deep into its options. Go to “Insert -> Functions -> Google -> Google Translate.”

How to use google translate directly in google sheets

Apply Translation Code to Various Cells Simultaneously

You don’t have to repeat the process for every word you want to translate. Let’s say that you tried out the methods to only translate one word in cell A1. Click on the cell that the text was translated to. Place the cursor at the bottom right of the cell until you see a cross symbol.

When you see it, click and drag it so it covers the number of cells you want. When you let go, Google sheets will place a message in each cell, letting you know that an error has occurred. This error message will gradually disappear as you type the text you want to translate in the cell beside it.

How to use google translate directly in google sheets

Once you’ve filled all the empty cells, you’ll only have to repeat the process if you want to translate more text.

The words you want to translate don’t have to be right next to each other. For example, if the word you want to translate or detect the language is in cell F10, add that position and type =detectlanguage(F10) and press Enter. The initials of the language will appear in the cell you’ve highlighted/chosen.

Detect Languages in Sheets with Google Translate

It’s a good idea to be prepared for everything, and that includes dealing with a language you can’t identify. Google Translate has that covered too.

In one cell, type the text in the language you want to identify. In the cell to the right, type =detectlanguage . After typing the first few letters, the option will appear.

How to use google translate directly in google sheets

Select the option and enter the cell whose language you want to detect and press Enter. Sheets will place the initials of the language to the right.

You can use the same drag option you used before when you wanted to translate different words. Place the cursor on the corner of the cell that has the language identifying code, and every word you type to the left of it will be translated.

Conclusion

Now you don’t have to switch between the Google Translate app and Google Sheets to either translate or identify a language. It can all be done without having to leave Sheets! Let us know how this works for you.

Just a simple guy that can’t enough of Technology in general and is always surrounded by at least one Android and iOS device. I’m a Pizza addict as well.

  • Facebook
  • Tweet

Affiliate Disclosure: Make Tech Easier may earn commission on products purchased through our links, which supports the work we do for our readers.

How to use google translate directly in google sheets

Google Translate lets you translate words or phrases from one language to another, but did you know that there’s a formula you can use to translate a batch of words directly in Google Sheets? Here’s how to do it.

Translating Text in Google Sheets

Integrating Google Translate with Google Sheets was a good call. Now you no longer have to switch back and forth between tabs to translate text. Translating text in Sheets is as simple as inputting a formula. Here’s the structure of the formula:

How to use google translate directly in google sheets

When entering the text to be translated, you can either type the actual word in the formula itself, or you can input a cell containing the word to be translated.

In this example, we want to translate the English words in column A (which we’ve named “English”) into their Chinese equivalents in column B (which we’ve named “Chinese”). Since we have the words already in the sheet, we can just call the cells that contain them. Here, we’re calling cell A2, which contains the word “Cake.”

How to use google translate directly in google sheets

Note: If you input the text directly in the formula, you must include quotation marks around the word. If you enter the cell in which the word is residing, you must leave off the quotation marks.

Next in our formula comes the source language. When entering the source language, you need to enter the two-letter language code. If you’re unsure of what the source language is, you can enter in “auto” and Google will auto-detect the language. We know “cake” is an English word, so we’ll use “en” here. Note that you must include the quotation marks around the two-letter language code.

How to use google translate directly in google sheets

Finally, we need to input our target language in the same way. Here, we’re using “zh”—the two-letter code for Chinese.

How to use google translate directly in google sheets

Once you’re finished, press Enter and watch the magic happen.

How to use google translate directly in google sheets

If you have a list of words in column A that you’d like to translate, all you need to do is select the cell that contains the formula we just entered, click and grab the bottom-right corner, and drag to the desired row.

How to use google translate directly in google sheets

As with any translation software out there, this is not always 100% accurate. For less complicated vocabulary though, this should be a reasonably reliable solution.