Bulk translate numerous columns of a CSV with 650 rows into to different languages. I copy pasted the CSV into a Google Sheet and would like to create 5 new tabs with the same data, but the columns with text (7 columns) translated into another language.
What is the problem & what have you tried?
Iām only able to translate 1 column row by row into DeepL and get these values back into the column of the new document, which means I have to set up 5 of these modules, costing a lot of operations since this is working only 1 row at a time.
The DeepL module only outputs one text, so I thought that if I combine the columns that I need to translate, I can translate all the columns at once, saving modules and operations, but I donāt know how to separate the data back into different columns from the string I get.
I tried all sorts of aggregrators, iteratators, text parsers, and different Google Sheet modules, and have also read other topics on this, but unfortunately I donāt have enough knowledge to get it to work, so wondering if someone get take a look at it. Maybe the whole workflow can be optimized, since I start off with a CSV file thatās on my computer, but I didnāt know how to get this data without copy-pasting it into Google Sheets.
as far as I know, DeepL will maintain the formatting of what you send it so define clear and unique cutoff points. Then you can use the split() function and break it up back in the same chunks.
At the moment you have a comma which is very generic and will most likely exist elsewhere as well. So change it to something else that wont appear in the text it self.
We are happy to help with Make, of course, and 650 x 7 x 5 (22.750) is a lot of cells to iterate and translate over one by one. But did you know that Google Sheets has an built-in function for translating?
You might hit rate limit errors on Googleās side, but that is another issue. You can even use AppScripts to translate the complete sheet. Make is a great solution, but not always the right fit.
Thanks for your great suggestions. I didnāt know about the built-in translation of Google Sheets, Iām going to start with this and see if I can produce the new sheets with these columns fully translated, hopefully being able to do so for the whole column after doing it for one cell.
If thatās not working I will definitely try the split() function, and use a unique separator to split the string. Very helpful, even though I hope the translate function will work this method will come in handy in some other automation.
Iāll keep you guys posted, cheers for giving these clear directions!
I thought the forum was down, only when I checked this afternoon in Chrome I discovered you can still login, and only after that seeing the login button in FF at the bottom. So donāt know if any moderators see this and of course others might not interpret it like this, but just wanted to share this experience in case it was unknown.
Hi @Henk-Operative , sorry for the delay, but your tip to use Google Sheets for this has been super helpful!
I was able to export the .CSV with the Collection List out of Webflow, then import it into Google Sheets. There I translated one cell of the desired column, after which translating the full column was a breeze. I takes a few minutes though, but that wasnāt a problem. I did this for 6 columns that needed cell translation. Some columns needed translation, but because of the prefab dropdown answers in the input field, those are translated in the Webflow Designer.
When importing I chose only the designated columns and everything was there! The smaller collection lists I just translated manually, same as with the static pages, so all in all it took an hour of 6 once I got the workflow ready.
Super happy with the result, so thanks again for your advice, and @Stoyan_Vatov for taking the time to respond with a ānativeā Make solution.
EDIT 31/1 8.30 PM CET: for anyone wanting to recreate this procedure, thereās one step I forgot to mention, is to click on top of the translated column to select all cells, then press CMD+C (Mac, on PC use Control) and then CMD+Shift+V (paste values only). This replaces the formula with real content. Iām not fully sure if this step is fully necessary or if the CSV export will do the same, but with these kind of processes you want to leave as little possibilities for errors as possible if you ask meā¦
What is your goal?
What is the problem & what have you tried?
Create public scenario page
Screenshots (scenario flow, module settings, errors)
