DETECTLANGUAGE Function in Google Sheets

Detect the language of the given text using the DETECTLANGUAGE function.

DETECTLANGUAGE Function

The DETECTLANGUAGE function in Google Sheets is used to detect the language of the provided text or text range.

Syntax

DETECTLANGUAGE(text_or_range)
  • text_or_range`: The text or range of text you want to detect the language for. This is a required parameter.

Example

  1. Detect Language

Detect the language of the phrase “Bonjour tout le monde”:

=DETECTLANGUAGE("Bonjour tout le monde")

This will output “fr” indicating the text is in French.

Notes

  • The function returns a two-letter language code based on ISO 639-1 standards.