CX Translator Support

Support Topics

System Requirements

Overview of CX Translator

CX Translator is an Excel add-in (.xlam file) that enables you to translate text (in bulk) between a wide range of languages directly within an Excel spreadsheet. For example if you work with customer feedback or reviews in multiple languages, you can use CX Translator to translate them all into English, or any other common 'base' language for further analysis.

CX Translator has an 'auto detect' feature which means that if you have text in multiple languages, you can easily translate everything into a single base langauge with just one click!

You can also create your own formulas to translate text since CX Translator can be used as a function within individual cells on your spreadsheet.

Because CX Translator is a standard Excel add-in which doesn't make any changes to your system, you can install CX Translator without Administrator Priviledges. If you are installing CX Translator on a corporate computer, in most cases you will be able to do this yourself without any involvement from your IT department.

CX Translator uses cloud based processing meaning that your data will be sent unencrypted across the public internet. Before using CX Translator please ensure that you are comfortable with this.

Supported Languages

CX Translator supports the following languages:

Africaans (af), Albanian (sq), Amharic (am), Arabic (ar)*, Armenian (hy), Azerbaijani (az), Basque (eu), Bengali (bn), Bosnian (bs), Belarusian (be), Bulgarian (bg), Catalan (ca), Cebuano (ceb), Chinese Simplified (zh-CN), Chinese Traditional (zh-TW), Corsican (co), Croatian (hr), Czech (cs), Danish (da), Dutch (nl), English (en), Esperanto (eo), Estonian (et), Filipino (tl), Finnish (fi), French (fr), Frisian (fy), Galician (gl), Georgian (ka), German (de), Greek (el), Gujarati (gu), Haitian Creole (ht), Hausa (ha), Hawaiian (haw), Hebrew (iw)*, Hindi (hi), Hmong (hmn), Hungarian (hu), Icelandic (is), Igbo (ig), Indonesian (id), Irish (ga), Italian (it), Japanese (ja), Javanese (jw), Kannada (kn), Kazakh (kk), Khmer (km), Korean (ko), Kurdish (ku)*, Lao (lo), Latin (la), Latvian (lv), Lithuanian (lt), Luxembourgish (lb), Macedonian (mk), Malagasy (mg), Malay (ms), Malayalam (ml), Maltese (MT), Maori (mi), Marathi (mr), Mongoloan (mn), Nepali (ne), Norwegian (no), Nyanja (Chichewa) (ny), Pashto (ps)*, Persian (fa)*, Polish (pl), Portuguese (pt), Punjabi (pa), Romanian (ro), Russian (ru), Samoan (sm), Scots Gaelic (gd), Serbian (sr), Sesotho (st), Shona (sn), Sindhi (sd)*, Sinhala (Sinhalese) (si), Slovak (sk), Slovenian (sl), Somali (so), Spanish (es), Swahili (sw), Swedish (sv), Tagalog (Filipino) (tl), Tajik (tg), Tamil (ta), Telugu (te), Thai (th), Turkish (tr), Ukranian (uk), Urdu (ur)*, Uzbek (uz), Vietnamese (vi), Welsh (cy), Xhosa (xh), Yiddish (yi)*, Yoruba (yo), Zulu (zu)

Note: for the languages marked * above you can translate from these languages but not into them at the current time. For example you can translate Arabic text into English but not English into Arabic.

Licence Types

The licence types available for CX Translator are explained below:

Named User Licence - this licence allows a single named user to use CX Translator on any computer. This licence is ideal for individuals or small teams who don't use shared computers. Discounts are available for multiple purchases of this licence

Site Licence - A site licence enables unlimited users on the network at a single site to access the products. Also, individual copies are not locked to an individual user so multiple users can access the products on the same computer. This licence is ideal if you have large teams or teams using shared computers working on the same project

CX Translator is licenced on an annual basis

Discounts are available for educational and non-profit organisations

Installing CX Translator

The CX Translator add-in is installed just like any other Excel add-in:

  1. Extract the files from the file to a location on your computer e.g your Desktop
  2. Start Excel and ensure a blank workbook is open
  3. If you already have a version of the CX Translator add-in installed, please uninstall (delete) this before proceeding
  4. Click the File tab, click Options, and then click the Add-Ins category
  5. In the Manage box, click Excel Add-ins, and then click Go. The Add-Ins dialog box appears
  6. Click Browse, locate the CXTranslator.xlam add-in file
  7. click Open and then click OK
  8. Excel will ask you if you want to copy the add-in to your add-ins folder. Click Yes

When installed you will see a new item called CX Data Science on the Excel Ribbon

Congratulations! CX Translator is now installed and ready to use

First Use - Licence Activation

The first time you use CX Translator after installation you will be asked to enter your product key:

  1. Ensure that your computer has an internet connection
  2. With any workbook open, click the CX Translator tab, and then click the Translate button on the ribbon
  3. Enter your email address / username and product activation key exactly as supplied in the email from us, and then click Activate
  4. The latest configuration file will be downloaded automatically in the background
  5. The configuration file data will be copied into the add-in, this takes a few seconds
  6. The main CX Translator dialog box will appear. Click Cancel

Translating text using CX Translator

  1. Select the worksheet cells that contain your textual data. In this example we're going to use Tweets. You can select the actual cells containing text to translate or you can select an entire column (or columns). Only cells containing textual data will be processed.
  2. Select the CX Data Science tab on the Excel Ribbon, and then click the Translate button
  3. The main CX Translator dialog box will appear.
  4. Check that the range you selected is correct
  5. Select the source language and target language
  6. Select whether you want to insert the translated text in a new column or overwrite the existing data (undo is not available so be sure before you select this option)
  7. Click the Start Processing button
  8. Wait while CX Translator processes your textual data. Progress is displayed in the bottom left status area of the main Excel window
  9. When CX Translator has finished processing your data a summary dialog box will appear
  10. The translated text will be inserted either into a new column immediately to the right of the column containing the data you selected, or your existing text will be overwritten (depending on the option selected in the main dialog box)

Using CX Translator as a worksheet function

You can also use CX Translator as a worksheet function using the following syntax:

Updating your version of CX Translator

If you already have a version of CX Translator installed on your system, the safest way to update it is to remove the CXTranslator.xlam file from your system and then install the new one.

Uninstall CX Translator

  1. Start Excel
  2. Click the File tab, click Options, and then click the Add-Ins category
  3. Click on the CX Translator entry in the list of Active Application Add-ins
  4. The full file path for the add-in is shown below the Add-ins list. Make a note of this
  5. From Windows Explorer, browse to the location of the add-in and delete the CXTranslator.xlam file
  6. In Excel, click the File tab, click Options, and then click the Add-Ins category
  7. Click the Go... button next to Manage: Excel Add-ins
  8. CX Translator will still appear in the list of Add-ins. Select CX Translator and a warning message will appear. Click Yes
  9. CX Translator is now removed from your system