Skip to content
Google Sheets

DETECTLANGUAGE function in Google Sheets

Identifies the language used in text within the specified range.

=DETECTLANGUAGE(text_or_range)

DETECTLANGUAGE syntax and parameters

One argument, one required.

  • text_or_rangeanyRequired

    The text or reference to cells containing text to evaluate. If text_or_range is specified as a range, it must be a one-dimensional column range.

DETECTLANGUAGE examples

Formulas you'll actually reuse.

  1. The language code of a customer review:

    =DETECTLANGUAGE(A2)

    Result"de"

  2. Route non-English comments to a translation queue:

    =IF(DETECTLANGUAGE(A2) = "en", A2, "Needs translation")

DETECTLANGUAGE in Excel

Same name — your formula ports as-is.

Try DETECTLANGUAGE in the playground

Edit the example — nothing to install.

Preloaded with the DETECTLANGUAGE formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.