Batch Translate

Last modified: May 7, 2026

Introduction

Batch translate allows you to enter texts in one language that correspond to texts in another language.

You usually translate from the default language to a second language, but you can use any other dictionary of texts. For example, if your default language is English, United States, you may already have translated the text into Dutch, Netherlands and you can use this as a reference for translating into Dutch, Belgium because there are likely to be more similarities.

Using Batch Translate

Batch translate translates between two languages. When you select batch translate, you are prompted to select the two languages you want to use: a Source language to use as a reference, and a Destination language that you want to update.

Select source and destination languages

Documents/Modules

You can select one or more modules you want to use for batch translate. For example, you may already have translations for imported and system modules and want to concentrate on translating your own modules.

Click Select… and select the modules you want to work on.

Module selection screen

By default, batch translate works on all modules in the app.

To search for a particular phrase in the source language text, type the text you want to search for. You cannot search for text in the destination language.

Batch translate search

By default, all translatable text from the selected module (or modules) is shown.

Each found text is displayed in the Source column. The # column shows the number of times it occurs in the selected module (or modules).

If you select a line, you can look in the Show occurrence section to see the Object containing the text and the Document it appears in. Double-clicking or clicking Show occurrence opens the document and selects the object so you can easily see the context.

Translation

In Translation, type new text that you want to use instead of the existing text. Click Translate to confirm the replacement.

If you have two texts that are identical in the source language but different in the translation language, you must review and change these individually. This is not very common, but imagine, for example, you have used Order Lines to both describe the lines on an order and to label a button that sorts some lines. See Working in the Currently Selected Language in Language Menu to find how to change individual texts.

Exporting and Importing Text

If you want to translate a language outside Studio Pro, you can export the translatable texts to Microsoft Excel (.xlsx) format, make changes, and then import the changes from the updated Excel file.

This is particularly useful if you are working on multiple apps and you want to apply your translations to a different app.

Export to Excel

Click Export to Excel to export the currently displayed text items to a Microsoft Excel (.xlsx) format file.

The file is in the format shown below:

Sample Excel file
  • Row 1Filter: indicates the modules that are included in the exported file
  • Row 2 – indicates the source and translation language; the first column represents the current text, the second column the translation text
  • Rows 3+ – show the current texts

You can make changes in column B that are processed if the file is imported.

Import from Excel

Click Import from Excel… to import a correctly constructed Microsoft Excel (.xlsx) format file.

This does the following:

  • The selected module (or modules) are set to the ones in the Filter: line of the file
  • Any texts that are empty in column B are ignored
  • Any texts in column A that do not match translatable texts in the selected module (or modules) are ignored
  • Any text in column B that is not ignored is entered into the Translation column

Changes are only made if you click Translate.

Read More