Using Power Query in Excel to Translate Data Using the Google Translation API

[smozgur]

smozgur submitted a new Excel article:

Using Power Query in Excel to Translate Data Using the Google Translation API - How to make basic API calls in Power Query

When I started reading Jeffrey McManus' Database Access with Visual Basic book decades ago, I was very much aware that data was everything. I was keep saying "You have a project only if you have a data set to manage". However, back in those days, you were mostly limited with the data included in the project that you were working on and you had to create that data source first. Perhaps it...

Read more about this Excel article...

 

[malayaka]

Thank you so much for the helpful and useful article!

I'm running into a privacy level issue. Is it possible to have all sources (including Google Translate) set to "private?" So far, the only level that work is "Organizational." I was hoping to set the level to "private" given the sensitivity of the data.

Any help is greatly appreciated! Thank you in advance!

 

[YOUSSEF FARIS]

HOW MUCH WORDS CAN WE TRANSLAT IN ONE CELLS WITH THIS API ?

 

[claus1812]

Excellent solution and exactly what I've been looking for.
However I'm struggling using it:
When trying to reproduce your example I always get this error (see image attached).
I did set the sheet name to "Original" and even saved the file under "Original.xlsx" - same Error remaining.
What's wrong ?

 

[smozgur]

Excellent solution and exactly what I've been looking for.
However I'm struggling using it:
When trying to reproduce your example I always get this error (see image attached).
I did set the sheet name to "Original" and even saved the file under "Original.xlsx" - same Error remaining.
What's wrong ?

The implementation works with a table named as "Original". So, you need to:

1. Select the source data range on the worksheet
2. Create a table (Insert->Table (with headings))
3. Name the table as Original

Then it will find the table that it needs to get data from.

 

[James006]

@smozgur

Love your solution

How can you inject a dynamic link between the worksheet and the query, in order to have as variables:
1. en and tr
2. English and Turkish

Currently, I have a sheet dedicated to five languages and their codes, and your solution could be just perfect with this modification.

Indeed, a simple RefreshAll would immediately produce the expected results from any language to any other language

Thanks in advance

 

[smozgur]

@smozgur

Love your solution

How can you inject a dynamic link between the worksheet and the query, in order to have as variables:
1. en and tr
2. English and Turkish

Currently, I have a sheet dedicated to five languages and their codes, and your solution could be just perfect with this modification.

Indeed, a simple RefreshAll would immediately produce the expected results from any language to any other language

Thanks in advance

@James006: There are part 2 and part 3 of this article. I believe they will answer your question (especially part 3, but I suggest reading part 2 too, in the series order).

Power Query vs. Google Translation API - Part 2

In the first article of this series, Using Power Query in Excel to Translate Data Using the Google Translation API, we discussed retrieving data from a web server by using a simple API call. In the article, we used the Google Translation API...

www.mrexcel.com

Translate to Multiple Languages with Power Query - Part 3

In the previous article of this series, Power Query vs. Google Translation API - Part 2, we discussed how to make more effective Google Translation API calls by combining all rows as a whole text with a delimiter and send it to the web server in...

www.mrexcel.com

 

[James006]

@smozgur

Thanks a lot !!!

Really sorry I had not noticed there were 2 more sections in your article

 

[smozgur]

@smozgur

Thanks a lot !!!

Really sorry I had not noticed there were 2 more sections in your article

I hope it helps!

Note: Last article also has an additional update to parameterize the source language instead of hardcoded English only.

 

[James006]

I hope it helps!

Note: Last article also has an additional update to parameterize the source language instead of hardcoded English only.

Many Thanks ...!!!

As soon as I have a moment, i will dive with delight ( zevk ) into your articles