Automated translation with Google Translate in Google Spreadsheets | Bulk-Translate Simple formula

[@TeachmeCaleb]

Great stuff! Thanks for sharing

[@Graphicious]

You bet! Happy it helps.

[@lucasjr3988]

Thank you so much! This helped me a LOT

[@Graphicious]

Glad it helped!

[@WWSDM101]

I tried this but it doesn't work on my end. I have the Office 2013 package. Is that why? Can this be updated so that it works? Thank you.

[@Graphicious]

This tutorial is for Google Sheets not Excel or Office. I don’t think Excel has automated translation.

[@WWSDM101]

@@Graphicious Thanks for your swift reply!

[@awake5196]

But how to translate into phonetic alphabet?

[@Graphicious]

I don't think it has that option. You can add a workaround for the pronunciation, as discussed here: support.google.com/docs/thread/11864461?hl=en And in case you mean 'transliteration', I am working on a tool for that.

[@awake5196]

@@Graphicious thanks you, even though i checked out this support article before i started searching for this on KZbin, but it doesn't really matter because i finally found an overkill solution: In case you are also interested in it -there is a Dictionary add-on for g.sheets that does the job in the best possible way

[@awake5196]

@S. M 1st reply was suspended by auto mod, I guess, because I put a link into the message anyway, it's called "Dictionary Functions", you can find in "Google Workspace Marketplace"