Summary: This guide explains how to translate text within Google Sheets using the GOOGLETRANSLATE function with simplified steps and official links to language codes.

Step 1: Open the file

Upload the Excel file to Google Drive and then open it using Google Sheets.

Step 2: Select the cell

Choose an empty cell where you want the translation to appear.

Step 3: Writing the translation function

If the text is in cell G2 , use the following formula:

=GOOGLETRANSLATE(G2,"zh-cn","en")

Step 4: Implementing the translation

Press Enter and the translation will appear directly inside the cell.

Step 5: Repeat the translation (optional)

Drag the cell square from the bottom corner down to apply the function to the rest of the rows.

Important notes

• You can change the languages ​​as needed. Example of translation to Arabic:

=GOOGLETRANSLATE(G2,"zh-cn","ar")

• A complete list of language codes is available via the official Google link:

https://developers.google.com/workspace/admin/directory/v1/languages

• You must be connected to the internet for it to work properly.