Randomblogs: February 2014

Google doesn't allow you to download audio from Google translate directly but you can download the audio clips indirectly using this link for English words http://translate.google.com/translate_tts?tl=en&q="actually"

Now you can choose another language by changing en in the link to another language code such as zh for Chinese. http://translate.google.com/translate_tts?tl=zh&q="世界"

Here's a list of language codes http://msdn.microsoft.com/en-us/library/ms533052(VS.85).aspx not all of them will work with Google translate.

The only part of the link that changes from word to word is the word at the end of the link. Google allows you to leave spaces between words and it doesn't have to be in quotation marks http://translate.google.com/translate_tts?tl=en&q=This still works

Copy the first part of the link to Excel http://translate.google.com/translate_tts?tl=en&q= changing the language code if needed.

In column B paste the list of words you want to download, in column C write =CONCATENATE(A1,B1) and drag this formula down column C.

Now you should have a list of links in column C that will lead you to the audio file in Google translate, try one of the links out first to make sure you have done it correctly..

To download all the audio files at once we want to put all these urls into a HTML file and turn them into links. To do this in column D type <a href=" and again drag this text down all the rows you want to fill. In column E type "> and in column F type </a>

In column G type =CONCATENATE(D1,C1,E1,B1,F1) now drag this formula down to all the rows you need.

Open up notepad type <html> at the top of the page, copy column G from Excel into notepad, at the bottom on the page write </html>

Do not copy more than 100 column from Excel at once, Google will not allow you to have too many request to their servers at once. I would suggest have multiple notepad documents all with 100 links in each.

Now click save as in notepad and save it as links.html , .html at the end is important. Where it "save as type" select "All files"

Open links.html in your browser, you should see a list of words and if you click one of the links it should take you to that word. To download all the audio files Install Firefox or open Firefox, install DownloadThemAll! Open up links.html in Firefox

Once installed and you have links.html running in Firefox right click and select DownThemAll!

Now you want all your files to be named correctly so select the tag below Renaming mask:

and select *text* , make sure this is first below Renaming mask:. This will save all the files as the link of the link.