Skip to content
DeepL Sheets: Translate Your Sheets

Getting started

Overview

DeepLSheets is a Google Sheets Extension that provides best translation service using DeepL API. You only need to buy the license once for lifetime usage ($39), no subscription needed.

Getting Started

Activate License

  1. Activate License (Buy $39 once for lifetime use): https://terrydjony.lemonsqueezy.com/buy/cd24ef65-f97a-4420-90b3-4b394e533a4d

You will get a license key after purchase on your email.

alt text

Your license key format should be something like NNNNNNNN-NNNN-NNNN-NNNN-NNNNNNNNNNNN with N being a character (can be a number or a letter).

  1. After you purchase the license, go to Google Sheets > Extensions > DeepL Sheets > Activate License and enter the license key that you got on the email after purchase.

alt text

alt text

After you put in the license key you got from email, click OK.

Next step, we will setup the DeepL API Key so you can use this extension.

Setup DeepL API Key

  1. Insert your DeepL API Key.

How to get DeepL API Key?

Make sure you have DeepL API account, not DeepL Translator account.

Go to https://www.deepl.com/en/pro#developer

Make sure you’re on the “DeepL API” tab.

Click “Sign up for free” on DeepL API Free

deepl-api-free

After you have created your account, you can go to Profile -> Account -> API Keys -> Create API Key to retrieve your API keys. alt text alt text alt text

Create your API Key and copy the value.

Then, you go to your Google Sheets document Open Extensions -> DeepL Sheets -> Setup API Key setup api key

Then you paste the API key you have copied from your DeepL API key account.

Contact [email protected] if you need help.

  1. Use =TRANSLATE(text, translate_to) to translate text

For the second parameter translate_to, you can use target language codes that’s supported by DeepL. Refer to DeepL developer supported language documentation

For example, executing =TRANSLATE("how are you", "JA") will translate “how are you” into Japanese. By default, DeepL will automatically detect the source language. However, you can also provide an optional third parameter, which is source language code, for example =TRANSLATE("how are you", "JA", "EN) will translate from English to Japanese.

You can refer to your cell just like any Sheets formula too, such as =TRANSLATE(A2, "JA") or even combine it with other Sheets formulas.

Advanced Translation Options

The TRANSLATE formula now supports additional parameters for more control over your translations:

The formula accepts these parameters:

  • text: The text you want to translate
  • translate_to: Target language code (required)
  • translate_from: Source language code (optional, defaults to auto-detection)
  • model_type: Translation model type (optional, defaults to “default”)

For example:

  • Basic translation: =TRANSLATE("hello world", "JA")
  • Specify source language: =TRANSLATE("hello world", "JA", "EN")
  • Use specific model: =TRANSLATE("hello world", "JA", "EN", "quality_optimized")

The model_type parameter accepts these values:

  • "default": The default value according to the DeepL API documentation
  • "prefer_quality_optimized": Prefer higher quality
  • "quality_optimized": Highest quality (may be slower)
  • "latency_optimized": Fastest translation

Please refer to the DeepL API Documentation for more details. Take note that a particular model type may only be available for DeepL API Pro subscribers.

DeepL Write

Besides translation, we also support DeepL Write API.

You just need to do =DEEPL_WRITE(text, target_lang) to improve your text using DeepL.

deepl_write

Per the DeepL API Documentation (Feb 11, 2025), this API is only accessible to DeepL API Pro subscribers , and there are 8 supported languages. Please refer to the DeepL Write API Reference