Leverage power of world class machine level translation engines in your Excel
workbooks with easy to use custom functions
Google & Bing
Translate for Excel
API Configuraion Guide
Click here for Microsoft Translation Engine
Settings
Click here for Google Translate Settings
Technitya.com API Configuration Guide
Using Microsoft Translator Microsoft
Translate API sign up instructions
Step 1. Sign up
Subscribe to the Microsoft Translator 'dataset' in the Windows Azure Marketplace (requires a
Windows Live ID to sign in) at
https://datamarket.azure.com/dataset/1899a118-d202-492c-aa16-ba21c33c06cb
If you do not already have a Windows Live ID, you will need to sign up for one first.
1. Microsoft Translator page
If you do not have a Windows Marketplace account, you will be directed to the account Registration
page
Technitya.com API Configuration Guide
2. Microsoft Marketplace Account Registration page
Fill required fields, switch ON I agree checkbox, click Continue and you will be directed to
following page
Technitya.com API Configuration Guide
3. Sign Up page
Switch ON I have read and agree checkbox, click Sign UP.
4. Microsoft Translator signing up final page
Step 2. Get Customer ID
Get your Customer ID by clicking on the link https://datamarket.azure.com/account
Technitya.com API Configuration Guide
5. Customer ID on Account Information Page
Copy Customer ID. It should be used at the next step.
Technitya.com API Configuration Guide
Step 3. Register application
'Register an Application' by clicking the 'Register' button on the Windows Azure 'Developers'
page: https://datamarket.azure.com/developer/applications/
6. Application registration start
Once you click Register you will see a new screen like the one below. Fill the fields as shown in
the screenshot below (leave unmarked fields as is) and click Create.
Technitya.com API Configuration Guide
7. Application registration
Technitya.com API Configuration Guide
Step 4. Excel Addin configuration for Microsoft Translate
Once, you have followed the steps above you have all that you need to configure the Microsoft
Translate (Bing) for Excel software.
Follow the steps below to configure the Addin with Client Secret.
8. Excel Addin settings
API configuration is done. Use the function like shown below
Technitya.com API Configuration Guide
Using Google Translator Google API sign
up instructions
Step 1. Enable Translate API
Login to Google API Console by going to the link below
https://code.google.com/apis/console/
You will be required to sign up with your Google ID. Then page like below will be presented.
Find Enable and manage APIs and click it.
9. Console start page
You will be proposed to create a new project. Fill required fields and click Create (see screen
below)
Technitya.com API Configuration Guide
10. New project creation Form
After that you will be directed to the API manager page as below. Find and click Translate
API link.
11. API manager page
Technitya.com API Configuration Guide
Enable Translate API by turning ON Enable switcher. See screen below
12. Translate API enabling page
Technitya.com API Configuration Guide
Step 2. Create API key
You should create a new key. For that go to Credentials page and click Create credentials
13. Credentials creating page
Choose API key on the presented credentials types list
14. API key choosing
On the Pop-up window click Browser key
Technitya.com API Configuration Guide
15. Browser key choosing
On the next window center any ame in the Name field. Leave following field empty Accept requests
from these HTTP referrers (web sites). Click Create.
16. Credentials parameters form
Created API key will be presented on the next pop-up window. Copy API key.
Technitya.com API Configuration Guide
17. Window with Google Translator API key
Also created key will be presented on the Credentials page like below. You will be able copy there.
18. Created API keys table
Technitya.com API Configuration Guide
Step 3. Enable Billing
Before you can use the API key that you have created in the previous step, you will need to enable
Billing in google API console.
Google charges you for this service at the rate of $20 per 1 M characters of text. The detailed information
of Googles pricing for Translation engine is available at the link below
https://developers.google.com/translate/v2/pricing
On the opened page you will see steps to enable billing for your project. Click Project settings link and
follow next steps. See screen below.
19. Billing enabling guide
(Note: you may use Microsoft (Bing) API as well in case you do not want to be charged. Bing translate
engine will give you Upto 2 Million Characters for Free per month).
Technitya.com API Configuration Guide
Step 4. Excel Addin configuration
Copy and paste API in the settings window in the software in Excel as shown below.
20. Excel Addin settings
API configuration is done. Use the function like shown below
Technitya.com API Configuration Guide
