How to use the Lara Translate App in Google Sheets

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

Getting Started

Before using the functions, open the Lara sidebar to connect your Translation Memories and Glossaries.

1. In your Google Sheet, click Extensions > Lara Translate > Open to open the Lara sidebar;
2. Sign in to your Lara account if prompted;
3. In the Translation Memories section, select the memories you want to apply to this sheet. Click the Refresh icon to sync the latest memories from your Lara account;
4. In the Glossaries section, select the glossaries you want to apply. Click the Refresh icon to sync the latest glossaries from your Lara account.
   
   

The selected Translation Memories and Glossaries are applied globally to all LARATRANSLATE functions in the sheet.

Note: If you share the sheet with someone who has editing access, they can trigger LARATRANSLATE and LARAEVAL functions and consume characters from their Lara account.

Translate Text with LARATRANSLATE

Syntax

=LARATRANSLATE(sourceText, [sourceLanguage], targetLanguage, [context], [memories], [glossaries], [style])

Parameters

• sourceText — the text to translate, or a cell reference (e.g. A2)
• [sourceLanguage] (optional) — source language code (e.g. "en-US"). If omitted, Lara detects the language automatically
• targetLanguage — target language code (e.g. "fr-FR" for French)
• [context] (optional) — a range of cells with related text to improve translation accuracy
• [memories] (optional) — one or more Translation Memory IDs
• [glossaries] (optional) — one or more Glossary IDs
• [style] (optional) — translation style: "faithful", "fluid", or "creative"

Memories, glossaries, and style can be set directly in the formula instead of configuring them in the sidebar, which allows you to use different assets for each individual cell.

Evaluate translation quality with LARAEVAL

Syntax

=LARAEVAL(text, translation)

Parameters

• text — the original content (cell reference or string)
• translation — the translated version to evaluate

Walkthrough

1. Enter the source text in a cell (e.g. A2) and the translated text in another (e.g. B2)
2. In a third cell, enter: =LARAEVAL(A2, B2)
3. Lara returns a score from 1 to 3:
   • 1 — major errors (missing text, incorrect meaning, tone issues)
   • 2 — minor or stylistic issues
   • 3 — perfect translation

Note: LARAEVAL evaluates based on the source and target text only. Translation Memories, Glossaries, context, and style are not taken into account.

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