Translate in Google Sheets: the formula for translating tables
With Google Translate, the search engine has long offered a basic yet practical translation program that can be applied to Google tables using a simple formula. Find out how you can use the Google Sheets Translate function to automatically translate individual words, phrases and even entire sentences in real time.
Before we get started, it’s important to note that you need a Google account and browser in order to use Google Translate in sheets and tables. The idea behind Google Docs products is for them to be used online, allowing access anywhere around the globe – including access by multiple users at the same time. If necessary, tables and documents can be downloaded and used as Google Docs offline.
Google Workspace by Google with IONOS
Working smarter, together! Configure Gmail for your domain and benefit from the familiar Google tools all in one place.
How the Google Translate formula works for your tables
The Google Sheets Translate formula comprises multiple elements:
- The source text: A word, phrase, complete sentence or even several sentences that are to be translated. This text can be entered directly in a Google Translate formula or selected from a cell.
- The source language: This indicates which language the source text is written in. The information is represented by a country code or using the “Auto” command for automatic language detection.
- The target language: A country code is used to define which language the source text should be translated into.
Let’s look at an example to translate the German word “Beispiel” into English (“example”). If you enter the text directly into the formula, it may appear as follows:
=googletranslate("Beispiel" , "de" , "en")
If you want to translate the content of a cell, you would need to specify the cell you want to translate. In our example, the formula would look like this:
=googletranslate(A1 , "de" , "en")
An advantage of using a cell reference is that the method of entry is less prone to errors, and errors that do occur can be resolved quickly. Moreover, the Google Sheets Translate formula can be easily extended to other cells. To do so, click on the bottom-right corner of the cell that contains the formula (B1), hold down the mouse button and drag the highlighted area over the cells you want to include for translation. In our example, these are cells B2 and B3.
Language codes for the Google Sheets translate function
The Google Translate formula doesn’t just translate German text to English, and vice versa. It can be used for all languages supported by the free Google Translate tool. To find out which languages are supported and the language codes you’ll need to enter, use the tool and set the source language to English – the option “Detect language” usually works well. Then select your target language for the translation, such as Italian.
You can then the language code for the Google Translate formula in the URL.
To find the right URL, you can’t just go to the quick start via the search engine – i.e. the input screen for translations on a Google results page. Instead, you should always visit the URL “translate.google.com” to find the correct language code.
Alternative: translate entire documents with the Google Doc Translator
Besides tables, you can also create conventional text documents with Google. There’s no translation formula for a Google Doc, but rather a different function. In your document, click on the “Tools” tab and select “Translate document”.
In the popup that appears, enter the title of the translation and the target language. The translated version will open.
One more tip: The translation quality of Google Translate has improved considerably over time. But depending on the selected language and the complexity of the text, the translation is not always exact. So it’s a good idea to consider Google Translate alternatives to find the best translation tool.
Related articles
Dropbox vs. Google Drive
Cloud storage can be used for a variety of functions including sharing photos, collaborating on documents and backing up important files. There are loads of cloud storage solution providers to choose from. In the following article, we will compare two of the longest standing ones out there and their key features. Dropbox vs. Google Drive – which provider should you choose?
Translation tools: handy Google Translate alternatives
These days dealing and engaging with foreign languages is easier, quicker, and more direct than ever. Whether you’re at work or on holiday, numerous language tools and smartphone apps can help with the translation of difficult words, sentences, and online texts. Google Translate and alternative translation websites offer comprehensive tools that easily enable us to understand other languages.…
The best translation apps: which is the right one for you?
Finding the right apps for translating can be a challenge given the vast number of apps available in app stores. Different apps cater to different needs. Which translator app is recommended for speech recognition, for example? Read on to explore a detailed overview and comparison of the best apps for translation for Android and iOS devices.
Robert KneschkeShutterstock How to create a Gantt chart in Google Sheets
Gantt charts are essential visualisation tools in project management. Where events need to be planned or projects have to be organised, these practical charts are often used to visualise tasks and durations. If you’re working with Google’s Google Workspace, you can easily create Gantt charts in Google Docs and share them with colleagues and clients.
How to add Google Calendar to the desktop: a tutorial
The organisational miracle that is Google Calendar – once you’ve used it, you’ll wonder how you lived without. The calendar makes appointments easy to manage and data can be easily stored in the cloud. Google Calendar also synchronises your appointments with all your devices. So how do you add Google Calendar to your desktop? In this article, we explain how it works step by step.
Which website translators are the best?
If you want to translate a web page, you can usually use integrated browser tools or online translators like Google Translate. And there are many more website translators out there. But choosing the right translator depends on what you need translated. Here, we’ll introduce some of the best tools to translate a page.
