TRANSLATE
Unsupported (not recognized)Category: Text · Last tested 2026-09-01
Real compatibility results for the TRANSLATE function: executed in Excel for the web, Google Sheets and LibreOffice Calc, with desktop Excel behavior from Microsoft’s official documentation (we do not run desktop Excel — Excel for the web is a different application and is executed separately). Syntax and links to that documentation are below.
Support matrix
| Engine | Documented | Live-tested | Verdict |
|---|---|---|---|
| Excel (desktop) | Yes | No — documented only | n/a |
| Excel for the web | — | Yes (recalc, 2026-09-01) | Supported, behaves as documented |
| Google Sheets | No | Yes (Drive import, 2026-08-31) | Unsupported (not recognized) |
| LibreOffice Calc | No | Yes (25.8.7.3, 2026-08-31) | Unsupported (not recognized) |
LibreOffice version history
We executed the same test cases under each LibreOffice release to show exactly when TRANSLATE’s support changed — not documentation claims, real results.
| LibreOffice version | Verdict | Tested |
|---|---|---|
| 24.2.0.3 | Unsupported (not recognized) | 2026-08-31 |
| 24.8.7.2 | Unsupported (not recognized) | 2026-08-31 |
| 25.2.0.3 | Unsupported (not recognized) | 2026-08-31 |
| 25.8.7.3 | Unsupported (not recognized) | 2026-08-31 |
Why isn't TRANSLATE working in LibreOffice?
LibreOffice Calc does not implement TRANSLATE as of 25.8.7.3 — in our
executed tests it returns a #NAME? (unrecognized function) error. This is not a typo or a
settings problem, and saving the file as .xlsx does not change it: the function simply isn’t
available yet.
The same formula is documented for Excel.
Watch the LibreOffice version support page —
we re-run every test on each new release, so it will flip to Supported here as soon as it lands.
Why isn’t TRANSLATE working in Google Sheets?
Google Sheets does not implement TRANSLATE: we imported the formula into
Sheets on 2026-08-31 and every case came back #NAME?
(unrecognized function). Sheets is a rolling service with no version to pin, so this is a
statement about the service on that date, and Google’s own
function list does not document it either. Rewrite the formula with a documented
Sheets equivalent — see the
Excel ↔ Sheets equivalents table.
Executed test cases
Excel for the web (executed 2026-09-01 via OneDrive recalculation)
These values come from Excel for the web, not from desktop Excel. They are two different implementations of the calculation engine, and this run measured only the web one: the corpus was uploaded to OneDrive as .xlsx, recalculated by Excel for the web on open, and downloaded again for readback. Excel for the web is a rolling service with no pinnable version, so the run is identified by its date. Where a value here disagrees with the Expected column — which is Microsoft’s documentation of the desktop product — we cannot tell you whether the web engine diverges from the desktop one or the documentation is wrong about both, because we do not run desktop Excel.
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =TRANSLATE("Hello, World!","en","es") | Existence probe only: TRANSLATE calls Microsoft Translation Services over the network, so the documented result is not reproducible offline | ¡Hola, Mundo! | ProvenanceNOT DETERMINISTICALLY ASSERTABLE, and deliberately recorded as a probe rather than a support claim -- the same treatment batch D gave DETECTLANGUAGE, which is the same service behind the same disclaimer. Microsoft's page carries the Note box "This function is a service backed function. The supported languages and results may vary as languages are added or removed", and describes the function as translating "by using Microsoft Translation Services". THE PAGE PUBLISHES NO FORMULA/RESULT TABLE at all: its only example is prose, stating that =TRANSLATE(A1, "en", "es") on "Hello, World!" displays "Hola mundo!". Its four listed failure modes are properties of that service rather than of a spreadsheet engine, and NONE of them is given an error code -- "Text Too Long" ("You have too many characters in a cell"), "Error in Value" ("You have a non-text value in your cell"), "Invalid Language" ("You have entered an invalid language code or one we don't support") and "Request Throttled" ("You have exceeded your daily quota of the translation function"). No offline engine can reproduce "Hola mundo!", and an engine that DID return it from a local phrase table would not thereby be compatible with the documented service. What the run does establish is recorded separately: probing all four pinned LibreOffice builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) with the plain name, the _xlfn. storage form, the COM.MICROSOFT. add-in form, the ORG.OPENOFFICE. form and the _xlfn.ORG.OPENOFFICE. form returned #NAME? for ALL FIVE spellings on every build, which is the signature of a name the engine does not implement at all. Microsoft's page was read live on 2026-08-31 at https://support.microsoft.com/en-us/excel/functions/translate-function. FETCH NOTE FOR THIS BATCH: batch F recorded every /en-us/office/<name>-function-<guid> URL returning Microsoft's 'Sorry, the page you're looking for can't be found' body; today BOTH paths serve the article again -- the GUID form redirects to /en-us/excel/functions/<slug>-function -- and every page cited in this batch came back complete (217-223 KB) in one or two attempts, with no 87 KB stub responses. Nothing here is sourced from a search snippet or a mirror. |
Ran OK |
Google Sheets (executed 2026-08-31 via Drive import)
Google Sheets is a rolling service with no pinnable version, so this run is identified by its date. The corpus was imported to Drive as .xlsx, recalculated by Sheets, and exported back for readback.
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =TRANSLATE("Hello, World!","en","es") | Existence probe only: TRANSLATE calls Microsoft Translation Services over the network, so the documented result is not reproducible offline | #NAME? | ProvenanceNOT DETERMINISTICALLY ASSERTABLE, and deliberately recorded as a probe rather than a support claim -- the same treatment batch D gave DETECTLANGUAGE, which is the same service behind the same disclaimer. Microsoft's page carries the Note box "This function is a service backed function. The supported languages and results may vary as languages are added or removed", and describes the function as translating "by using Microsoft Translation Services". THE PAGE PUBLISHES NO FORMULA/RESULT TABLE at all: its only example is prose, stating that =TRANSLATE(A1, "en", "es") on "Hello, World!" displays "Hola mundo!". Its four listed failure modes are properties of that service rather than of a spreadsheet engine, and NONE of them is given an error code -- "Text Too Long" ("You have too many characters in a cell"), "Error in Value" ("You have a non-text value in your cell"), "Invalid Language" ("You have entered an invalid language code or one we don't support") and "Request Throttled" ("You have exceeded your daily quota of the translation function"). No offline engine can reproduce "Hola mundo!", and an engine that DID return it from a local phrase table would not thereby be compatible with the documented service. What the run does establish is recorded separately: probing all four pinned LibreOffice builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) with the plain name, the _xlfn. storage form, the COM.MICROSOFT. add-in form, the ORG.OPENOFFICE. form and the _xlfn.ORG.OPENOFFICE. form returned #NAME? for ALL FIVE spellings on every build, which is the signature of a name the engine does not implement at all. Microsoft's page was read live on 2026-08-31 at https://support.microsoft.com/en-us/excel/functions/translate-function. FETCH NOTE FOR THIS BATCH: batch F recorded every /en-us/office/<name>-function-<guid> URL returning Microsoft's 'Sorry, the page you're looking for can't be found' body; today BOTH paths serve the article again -- the GUID form redirects to /en-us/excel/functions/<slug>-function -- and every page cited in this batch came back complete (217-223 KB) in one or two attempts, with no 87 KB stub responses. Nothing here is sourced from a search snippet or a mirror. |
Error |
LibreOffice Calc 25.8.7.3 (tested 2026-08-31)
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =TRANSLATE("Hello, World!","en","es") | Existence probe only: TRANSLATE calls Microsoft Translation Services over the network, so the documented result is not reproducible offline | #NAME? | ProvenanceNOT DETERMINISTICALLY ASSERTABLE, and deliberately recorded as a probe rather than a support claim -- the same treatment batch D gave DETECTLANGUAGE, which is the same service behind the same disclaimer. Microsoft's page carries the Note box "This function is a service backed function. The supported languages and results may vary as languages are added or removed", and describes the function as translating "by using Microsoft Translation Services". THE PAGE PUBLISHES NO FORMULA/RESULT TABLE at all: its only example is prose, stating that =TRANSLATE(A1, "en", "es") on "Hello, World!" displays "Hola mundo!". Its four listed failure modes are properties of that service rather than of a spreadsheet engine, and NONE of them is given an error code -- "Text Too Long" ("You have too many characters in a cell"), "Error in Value" ("You have a non-text value in your cell"), "Invalid Language" ("You have entered an invalid language code or one we don't support") and "Request Throttled" ("You have exceeded your daily quota of the translation function"). No offline engine can reproduce "Hola mundo!", and an engine that DID return it from a local phrase table would not thereby be compatible with the documented service. What the run does establish is recorded separately: probing all four pinned LibreOffice builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) with the plain name, the _xlfn. storage form, the COM.MICROSOFT. add-in form, the ORG.OPENOFFICE. form and the _xlfn.ORG.OPENOFFICE. form returned #NAME? for ALL FIVE spellings on every build, which is the signature of a name the engine does not implement at all. Microsoft's page was read live on 2026-08-31 at https://support.microsoft.com/en-us/excel/functions/translate-function. FETCH NOTE FOR THIS BATCH: batch F recorded every /en-us/office/<name>-function-<guid> URL returning Microsoft's 'Sorry, the page you're looking for can't be found' body; today BOTH paths serve the article again -- the GUID form redirects to /en-us/excel/functions/<slug>-function -- and every page cited in this batch came back complete (217-223 KB) in one or two attempts, with no 87 KB stub responses. Nothing here is sourced from a search snippet or a mirror. |
Error |
Docs & syntax
- Excel (desktop): official documentation