Skip to content
English
Submit a request
  • There are no suggestions because the search field is empty.

How to use 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 configure your default settings.

  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 assets from your Lara account
  4. In the Glossaries section, select the glossaries you want to apply
  5. In the Style section, select your default translation style (Faithful, Fluid, or Creative)

The selected Translation Memories, Glossaries, and Style are applied as defaults to all LARATRANSLATE functions in the sheet. You can override them for individual cells directly in the formula.

Incognito mode: enable this option from the sidebar to prevent translations from being stored in our logs.

 

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.

Team preferences: Team plan users can configure default settings at team level. Team-level defaults apply to all members and can be managed by the team owner from the sidebar.

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.

Freeze Lara formulas

Google Sheets may recalculate formulas when a spreadsheet is reopened. Use the Freeze Lara formulas tool to replace your LARATRANSLATE and LARAEVAL formulas with their current text values — so your results stay fixed and you won't be billed again for the same content.

How to freeze your formulas

  1. Select the cells you want to freeze. Make sure to select one continuous block — selecting separate ranges with Ctrl+click (or ⌘+click on Mac) won't work.
  2. Open the Lara sidebar and go to Tools → Freeze Lara formulas.
  3. Click Freeze current selection to confirm.


Once frozen, each cell keeps only its value. With no formula, it won't recalculate or bill again.

Note: This action can only be undone immediately after freezing, while it's still in your edit history. Otherwise, re-enter the formula to make it live again.

 

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:

Function Pro Plan Team Plan
LARATRANSLATE €20 per 1 million input characters €15 per 1 million input characters
LARAEVAL €100 per 1 million input characters €75 per 1 million input characters
 

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

Screenshot 2025-07-16 at 11.12.19

 

 

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
  • Configuring default Translation Memories, Glossaries, and Style from the sidebar
  • Using Incognito mode in Google Sheets