smozgur

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

Overview Discussion
smozgur

smozgur

BatCoder
Builders Club Member
Joined
Feb 28, 2002
Messages
2,571
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...
Click to expand...

Read more about this Excel article...
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
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!
 
HOW MUCH WORDS CAN WE TRANSLAT IN ONE CELLS WITH THIS API ?
 
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 ?
 

Attachments

  • 2022-10-20 16_10_01-Query1 - Power Query Editor.jpg
    2022-10-20 16_10_01-Query1 - Power Query Editor.jpg
    10.1 KB · Views: 17
claus1812 said:
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 ?
Click to expand...
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.
 
@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 said:
@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
Click to expand...
@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).

www.mrexcel.com

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 www.mrexcel.com

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 www.mrexcel.com
 
@smozgur

Thanks a lot !!!

Really sorry I had not noticed there were 2 more sections in your article :oops:
 
James006 said:
@smozgur

Thanks a lot !!!

Really sorry I had not noticed there were 2 more sections in your article :oops:
Click to expand...
I hope it helps!

Note: Last article also has an additional update to parameterize the source language instead of hardcoded English only.
 
smozgur said:
I hope it helps!

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

Many Thanks ...!!!

As soon as I have a moment, i will dive with delight ( zevk ) into your articles :)
 
You must log in or register to reply here.

Forum statistics

Threads
1,216,503
Messages
6,131,022
Members
449,616
Latest member
PsychoCube

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top