For Excel 365, use the lastest add-in version
This analysis integrates the functionality provided by the Language Identification API. It allows to identify the language of a text easily and without any development. You can see all the detectable languages and how they are detected in this table.
This is the interface that will appear when you click the Language Identification button:
As you can see there are two sections in the interface: Input, which we have already covered in the corresponding section, and Analysis Settings.
In Analysis Settings there is a single value to set:
We've seen in the Settings section that there's an advanced settings menu with additional configuration options for the Language Identification. These are the options for Language Identification and their default values:
There are two differentiated sections: Input Configuration, with the options with which you will call Language Identification, and Output Configuration, to configure the output.
The results obtained from the analysis will be shown in a new Excel sheet called "Language Identification". This sheet will include a column with the source text, a column with the IDs if enabled, and then a column for each of the output fields configured in the advanced settings.
When the analysis is configured to output more than one language, each additional language associated to a text will be inserted as a new row, allowing a more flexible use of the results.
This is an example of a possible output of texts in different languages. IDs are enabled, cells at the output are combined and the configuration is set to show all the possible output fields and up to 3 languages.