---
title: How to use Lara Translate App in Google Sheets
description: Automate your localization workflow in Google Sheets with Lara. Easily translate bulk content, apply specific brand styles, and evaluate translation accuracy instantly without ever leaving your spreadsheet.
---

[Skip to content](https://support.laratranslate.com/en/how-to-use-lara-translate-extension-in-google-sheets#main-content)

- [English](https://support.laratranslate.com/en/how-to-use-lara-translate-extension-in-google-sheets)
- [Deutsch](https://support.laratranslate.com/de/so-verwenden-sie-die-lara-translate-erweiterung-in-google-sheets)
- [Italiano](https://support.laratranslate.com/it/come-usare-l-estensione-lara-in-google-sheets)

English

Show submenu for translations

[![Lara logo](https://support.laratranslate.com/hs-fs/hubfs/Screenshot_2025-01-07_at_10.24.13-removebg-preview.png?width=119&height=50&name=Screenshot_2025-01-07_at_10.24.13-removebg-preview.png)](https://support.laratranslate.com/en/?hsLang=en)

Open main navigation

Close main navigation

- - [English](https://support.laratranslate.com/en/how-to-use-lara-translate-extension-in-google-sheets)
    - [Deutsch](https://support.laratranslate.com/de/so-verwenden-sie-die-lara-translate-erweiterung-in-google-sheets)
    - [Italiano](https://support.laratranslate.com/it/come-usare-l-estensione-lara-in-google-sheets)

  English
  
  Show submenu for translations
- [Submit a request](https://2er2r1.share-eu1.hsforms.com/2CJaQX4efSGa8WhPQM8ImGg)

[Submit a request](https://2er2r1.share-eu1.hsforms.com/2CJaQX4efSGa8WhPQM8ImGg)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Lara Translate Knowledge Base](https://support.laratranslate.com/en?hsLang=en)
2. [API and Integrations](https://support.laratranslate.com/en/api-and-integrations?hsLang=en)
3. [Integrations](https://support.laratranslate.com/en/api-and-integrations?hsLang=en#integrations)

September 30, 2026

# 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.

![](https://support.laratranslate.com/hs-fs/hubfs/image-png-May-12-2026-02-21-35-6455-PM.png?width=245&height=364&name=image-png-May-12-2026-02-21-35-6455-PM.png)

 

***Note:** Only the **Spreadsheet Owner** can access the Lara sidebar to configure default settings or freeze formulas. If you share a spreadsheet with collaborators (Editors), they can use `LARATRANSLATE` and `LARAEVAL` formulas directly in the cells. However, please note that **all character consumption generated by any Editor will be billed to the Spreadsheet Owner's 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.

 

**How to use Lara as an Editor on a Shared Sheet**

If you have Editor permissions on a shared spreadsheet (and you are not the Owner):

1. Do not open the Lara sidebar in the shared file (opening the sidebar will display a *"You are not the owner of this spreadsheet"* message).
2. To activate your account for formulas, sign in to the Lara extension at least once from **any spreadsheet where you are the Owner**.
3. Once signed in, go back to the shared sheet and type the formulas (`=LARATRANSLATE(...)` or `=LARAEVAL(...)`) directly into the cells.

### 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**.  
   ![](https://support.laratranslate.com/hs-fs/hubfs/image-png-Jun-16-2026-03-34-03-8885-PM.png?width=201&height=544&name=image-png-Jun-16-2026-03-34-03-8885-PM.png)
3. Click **Freeze current selection** to confirm.  
   ![](https://support.laratranslate.com/hs-fs/hubfs/image-png-Jun-16-2026-03-34-44-1402-PM.png?width=670&height=310&name=image-png-Jun-16-2026-03-34-44-1402-PM.png)

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 $20 per 1 million input characters | €15 per 1 million input characters $15 per 1 million input characters |
| LARAEVAL | €100 per 1 million input characters $100 per 1 million input characters | €75 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](https://support.laratranslate.com/hs-fs/hubfs/Knowledge%20Base%20Import/Screenshot%202025-07-16%20at%2011_12_19-1.png?width=331&height=400&name=Screenshot%202025-07-16%20at%2011_12_19-1.png)

 

---

 

**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

- [About Lara](https://support.laratranslate.com/en/about-lara?hsLang=en)
- [How to use Lara](https://support.laratranslate.com/en/how-to-use-lara?hsLang=en#main-content)

    - [Translate text](https://support.laratranslate.com/en/how-to-use-lara?hsLang=en#translate-text)
    - [Translate documents](https://support.laratranslate.com/en/how-to-use-lara?hsLang=en#translate-documents)
    - [Translate voice](https://support.laratranslate.com/en/how-to-use-lara?hsLang=en#translate-voice)
    - [Translate images](https://support.laratranslate.com/en/how-to-use-lara?hsLang=en#translate-images)
    - [Translate audio](https://support.laratranslate.com/en/how-to-use-lara?hsLang=en#translate-audio)
- [Account and Subscriptions](https://support.laratranslate.com/en/account-and-subscriptions?hsLang=en#main-content)

    - [Manage your account](https://support.laratranslate.com/en/account-and-subscriptions?hsLang=en#manage-your-account)
    - [Payments and Invoices](https://support.laratranslate.com/en/account-and-subscriptions?hsLang=en#payments-and-invoices)
    - [Manage your subscription](https://support.laratranslate.com/en/account-and-subscriptions?hsLang=en#manage-your-subscription)
    - [Manage Team](https://support.laratranslate.com/en/account-and-subscriptions?hsLang=en#manage-team)
    - [Pricing](https://support.laratranslate.com/en/account-and-subscriptions?hsLang=en#pricing)
- [API and Integrations](https://support.laratranslate.com/en/api-and-integrations?hsLang=en#main-content)

    - [API](https://support.laratranslate.com/en/api-and-integrations?hsLang=en#api)
    - [CAT tools](https://support.laratranslate.com/en/api-and-integrations?hsLang=en#cat-tools)
    - [MCP Server](https://support.laratranslate.com/en/api-and-integrations?hsLang=en#mcp-server)
    - [Integrations](https://support.laratranslate.com/en/api-and-integrations?hsLang=en#integrations)
- [Data Security and Privacy](https://support.laratranslate.com/en/data-security-and-privacy?hsLang=en#main-content)

    - [Data security](https://support.laratranslate.com/en/data-security-and-privacy?hsLang=en#data-security)
    - [Privacy](https://support.laratranslate.com/en/data-security-and-privacy?hsLang=en#privacy)
- [Frequently Asked Questions](https://support.laratranslate.com/en/frequently-asked-questions?hsLang=en#main-content)

    - [Glossary](https://support.laratranslate.com/en/frequently-asked-questions?hsLang=en#glossary)
    - [Useful Tips](https://support.laratranslate.com/en/frequently-asked-questions?hsLang=en#useful-tips)

[![Lara translate logo](https://support.laratranslate.com/hs-fs/hubfs/Lara_logo_4333ad.png?width=140&height=59&name=Lara_logo_4333ad.png "Lara translate logo")](https://laratranslate.com)

© Translated · VAT IT07173521001

Copyright © 2025