TRANSLATE
Translates text or a cell value with AI credits, then reuses the saved translation while the source text and target language still match.
Use TRANSLATE(text, source_language, target_language) when a table should translate short text automatically with AI. The source text can come from another cell or from a quoted literal. Languages are normalized case-insensitively, so forms such as EN, en, English, and english are treated the same.
The first time a translation formula runs, TableStudio shows a warning that AI translation uses credits. The dialog explains the approximate credit usage using the same account guidance shown on the main page: about 1 AI credit for 17,000 input words and 4,200 output words. It then lets you continue once, continue and hide the warning for the session, or continue and hide it for the current file.
Translations are cached at cell level. TableStudio stores the original text, source language, target language, and translated result. As long as the original text is unchanged and the same target language is requested, the saved translation is reused instead of calling AI again. Before sending a new request, TableStudio also checks the saved translation values in the workbook and reuses an identical translation if one already exists.
Normal edit on a translated cell lets you adjust the translated result directly while keeping the underlying =TRANSLATE(...) formula. Use F2 or Edit Cell Formula if you want to edit the underlying formula itself. While you type formulas, the formula help pane beside the cell can show the TRANSLATE signature, argument meaning, and related notes, but it intentionally does not preview the translation live because TRANSLATE(...) is asynchronous and uses AI credits.
This function is asynchronous. While a new request is running, the cell shows a translating status. If the user is not signed in, the function returns #SIGNIN!. The monthly AI allowance is enforced. A new translation is blocked with #CREDITS! when its estimate exceeds the remaining balance; unresolved billing contexts also fail closed.
Examples: =TRANSLATE(A1,"EN","RO"), =TRANSLATE("Site manager","English","Italian"). Related: TableStudio Functions, IF / AND / OR, Date Formulas.
Function
TRANSLATE(text, source_language, target_language)
Parameters
- text — The source text to translate. It can be a cell such as
A1, a cross-sheet cell such asSH2(B4), or a quoted text such as"Hello". - source_language — The source language. It can be written as
EN,en,English,english, and similar aliases.autoordetectare also accepted. - target_language — The target language. It accepts the same forms as the source language, such as
RO,Romanian,IT, orItalian.
Returns
Returns translated text. While a new AI request is running, the cell shows a translating status. Once the translation is saved, TableStudio reuses it until the source text changes or a different target language is requested.
=TRANSLATE(A1,"EN","RO") translates the text from cell A1 from English to Romanian.
=TRANSLATE("Hello","English","Italian") translates a literal text value.
Translate a cell value
Use a normal cell reference as the text source, then reuse the saved translation while the source text stays unchanged.
Translate a literal
Quoted text works too when the translation should not depend on another cell.
Enable JavaScript to use reading progress and usefulness ratings.