How to use Lara Translate Extension in Google Sheets

Once you’ve installed the Lara Translate extension in Google Sheets, you can start translating and evaluating text directly inside your spreadsheets using two powerful functions: LARATRANSLATE and LARAEVAL.

Translate text with LARATRANSLATE

Syntax

=LARATRANSLATE(sourceText, sourceLanguage, targetLanguage, [opt_context])

Parameters

• sourceText: The text you want to translate (or a cell reference like A2)

• sourceLanguage: Specify the source language (e.g. "en-US")

• targetLanguage: Language code for the desired translation (e.g. "fr-FR" for French)

• [opt_context] (optional): A range of cells with related text. This additional context helps Lara generate more accurate and fluent translations

Walkthrough

1. In your Google Sheet, enter the sourceText into a cell (e.g. cell A2).
   
   
2. In another cell, where you want the translated text to appear, use the LARATRANSLATE function.
   
   
   
   Enter the source text cell as the first argument and a language code (e.g. "fr-FR") or a cell reference containing the code (e.g. A1) as the second and third arguments.
3. That's it! You've successfully translated your first cell.
   
   

Optional arguments

If you need more control, use optional argument like "context" with related terms in other cells from your sheet.

Add cells containing related text as references (e.g. A3:B3) as the final arguments to the basic function.

Evaluate translation quality with LARAEVAL

Syntax

=LARAEVAL(sourceText, targetText)

Parameters

• sourceText: The original text (cell reference or string).

• targetText: The translated version you want to check.

Walkthrough

1. In your Google Sheet, enter the sourceText into a cell (e.g. cell A2) and the targetText, so translated version, into another cell (e.g. B2).

   
   
2. In the cell where you want the evaluation to appear, use the LARAEVAL function.
   
   
   
   Use the source text cell as the first argument, and the target text as the second.

3. That's it! You've successfully evaluated your first translation.

   
   
   

   Lara will return a score from 1 to 3:

   • 1: Major errors (missing text, incorrect meaning, tone issues, tag errors).

   • 2: Minor or stylistic issues.

   • 3: Perfect translation.

Note: The LARAEVAL function in Google Sheets only evaluates based on the source and target text provided. It does not take additional context into account, unlike the evaluation available on the Lara Translate website.

Pricing

To use Lara’s functions in Sheets, you need an active Pro or Team plan on laratranslate.com. Pricing is based on input characters processed:

You can monitor your usage and upgrade or top up directly from your Lara account.

This article is about:

• Using the LARATRANSLATE function to translate text in Google Sheets
• Using the LARAEVAL function to evaluate translation quality
• Understanding how evaluation works differently in Sheets vs. on the website
• Knowing the pricing for translations and evaluations in Google Sheets