Translate table data

Scriptcase 9 General
#1

I have about 150 tables which now I am about to convert into multi language. The small ones I can translate by Google and use spreadsheet to Export/import. There are some tables which are in a Master/Details relationships (sometimes called: Parent/Child). These tables consist of usually two or more columns to translate.
I am looking for some method to automate the translateion as doing this manually using Exclell(like) tools is very time consuming. I wonder is there is any method which can be used either through Google Translator API, or some direst SQL ?

here is the example

2025-03-31_02h08_44
2025-03-31_02h08_441653×580 175 KB

this table needs added some new records for another language and these have to be transleted in the “Industry Name” column. Google does not accept more than 500 characters at the time, so it is very limited. Some other services allow 1000 characters but it is still not enough.
Now with 150+ tables, adding new records and then translating them is not easy task. I wonder if anybody has any experience with that ?

here is 2 column example

2025-03-31_02h20_30
2025-03-31_02h20_301499×1000 308 KB

#2

Excel has a function = TRANSLATE(cell; “es”; “en”)
Here there is a video, i think can help you.
https://www.youtube.com/shorts/D885xPiiHdA

#3

Thank you for replying :wink:

I am already somewhat familiar with that, after watching this VID.

  1. It only allows to create a Macro to assign to some VBA script and translate on cell at the time. One can stack-up Macros and kinda do the job but with 180 tables and some with 1500-2000 records and 5-6 languages it is still very tedious job.

  2. My major challenge is that some of the tables are in Parent/child relation and therefore in a child table ont one but two columns need to be translated. then within the same table I have for example rows 1-673 as english then rows 674-1346 in Spanish, then the next section of 673 rows in German.

I am not using MS-OFFICE (I use Libre Office, Open Office and few other flavors). I stay away from anything that comes from Syping Agnecies like Microsoft.Will be testing it in next few weeks.

I am wondering if there is a way to do this within SQL? perhaps with some help of AI?

#4

OK, I have found a better method using Google sheets. It has built in function “googletranslate()”.
This works well.