Translating with Google Sheets

Google Translate is an amazing feat of engineering, which uses artificial intelligence to translate speech and text from a chosen language into another. In most cases, Google Translate's own interface embedded in Google Search or on translate.google.com Again, as in other Case Studies presented here, Google Sheets comes to the rescue! Other than formatting the file to your liking, you can create some drop-down lists for the Source and Target languages. This will help you being more productive as you do not need to search for the language codes every time you want to change them. In my case, I used the Data Validation feature using as a criterion a List from a Range.