Language detection in Zoho DataPrep

Language detection

You can detect the language of the text in the selected text column using the Language detection operation powered DataPrep's own machine learning engine. As an example, if the text value in the selected column is, "Hello, World!", the Language detection operation will return: 'English'.


The transform supports over 70 languages in total. The list of languages supported are:

  • Afrikaans (af)

  • Aragonese (an)

  • Arabic (ar)

  • Asturian (ast)

  • Belarusian (be)

  • Breton (br)

  • Catalan (ca)

  • Bulgarian (bg)

  • Bengali (bn)

  • Czech (cs)

  • Welsh (cy)

  • Danish (da)

  • German (de)

  • Greek (el)

  • English (en)

  • Spanish (es)

  • Estonian (et)

  • Basque (eu)

  • Persian (fa)

  • Finnish (fi)

  • French (fr)

  • Irish (ga)

  • Galician (gl)

  • Gujarati (gu)

  • Hebrew (he)

  • Hindi (hi)

  • Croatian (hr)

  • Haitian (ht)

  • Hungarian (hu)

  • Indonesian (id)

  • Icelandic (is)

  • Italian (it)

  • Japanese (ja)

  • Khmer (km)

  • Kannada (kn)

  • Korean (ko)

  • Lithuanian (lt)

  • Latvian (lv)

  • Macedonian (mk)

  • Malayalam (ml)

  • Marathi (mr)

  • Malay (ms)

  • Maltese (mt)

  • Nepali (ne)

  • Dutch (nl)

  • Norwegian (no)

  • Occitan (oc)

  • Punjabi (pa)

  • Polish (pl)

  • Portuguese (pt)

  • Romanian (ro)

  • Russian (ru)

  • Slovak (sk)

  • Slovene (sl)

  • Somali (so)

  • Albanian (sq)

  • Serbian (sr)

  • Swedish (sv)

  • Swahili (sw)

  • Tamil (ta)

  • Telugu (te)

  • Thai (th)

  • Tagalog (tl)

  • Turkish (tr)

  • Ukrainian (uk)

  • Urdu (ur)

  • Vietnamese (vi)

  • Walloon (wa)

  • Yiddish (yi)

  • Simplified Chinese (zh-cn)

  • Traditional Chinese (zh-tw)

To detect the languages available in a column data:

1. Right-click the column and select Language detection transform from the context menu.


2. Provide a name to the resultant column in the New column name section. 

3. Select the type of output required. As the option name suggests, Language name will render the name of the language as the output, and Language code will render the code of the language.

4. For example, selecting the Language name will give 'English' as the output for an English text, and Language code for an English text will give 'en' as the output. 

5. DataPrep shows a live preview of the column during the transformation. You can click the Preview button at the bottom of the side panel to preview the output column.

6. You can apply this transformation to only one column. Click the Apply button to apply this transform.

Note: Language detection operation gives accurate results when the text length is 50 characters or more.


    Zoho CRM Training Programs

    Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

    Zoho CRM Training
      Redefine the way you work
      with Zoho Workplace

        Zoho DataPrep Personalized Demo

        If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

        Zoho CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now

            Get started with Zoho Sign

            in a few quick steps!

            Download Help Guide

                      Still can't find what you're looking for?

                      Write to us:



                        Zoho Marketing Automation

                          Zoho Sheet Resources


                              Zoho Forms Resources

                                Secure your business
                                communication with Zoho Mail

                                Mail on the move with
                                Zoho Mail mobile application

                                  Stay on top of your schedule
                                  at all times

                                  Carry your calendar with you
                                  Anytime, anywhere

                                        Zoho Sign Resources

                                          Sign, Paperless!

                                          Sign and send business documents on the go!

                                          Get Started Now

                                              Zoho SalesIQ Resources

                                                  Zoho TeamInbox Resources

                                                          Zoho DataPrep Resources

                                                            Zoho DataPrep Demo

                                                            Get a personalized demo or POC

                                                            REGISTER NOW

                                                              Design. Discuss. Deliver.

                                                              Create visually engaging stories with Zoho Show.

                                                              Get Started Now

                                                                                    • Related Articles

                                                                                    • Duplicate Column

                                                                                      Zoho DataPrep allows you to duplicate columns present in your dataset. To duplicate columns 1. Right-click on a column header and select the Duplicate columns option from the context menu. 2. Select the columns from the Columns to duplicate dropdown. ...
                                                                                    • Context menu

                                                                                      Zoho DataPrep offers various options in the context menu to perform column level operations.  A few basic options here are Sort, Rename, Delete and Move. To access the context menu, right click the column name and click any one of the icons to ...
                                                                                    • Cluster and merge

                                                                                      Cluster & Merge is used to replace multiple versions of the data which are expressed differently with the same version.  For example , if the following country names all appear in your data: U.S., U.S.A., USA. They all refer to the same country. You ...
                                                                                    • Convert units

                                                                                      DataPrep offers special operations to meet unique requirements with transforming data.  For example, if you need to share your dataset with different regions which use different standards of measurements, you can u se the Convert units special ...
                                                                                    • Change case

                                                                                      You can change the case of texts in a column using one of the following options: Upper case (E.g., ZOHO IS THE OPERATING SYSTEM FOR YOUR BUSINESS) Lower case (E.g., zoho is the operating system for your business) Title case (E.g., Zoho is the ...
                                                                                    Wherever you are is as good as
                                                                                    your workplace



                                                                                      Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.


                                                                                      Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.


                                                                                      Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.

                                                                                      CRM Tips

                                                                                      Make the most of Zoho CRM with these useful tips.

                                                                                        Zoho Show Resources