From data to report in one minute or less. Ajelix BI is launched! 🚀 Get started for free.
  • Home
  • Blog
  • excel
  • Effortless Localization: Ajelix Excel Add-in Setup for Translations

Effortless Localization: Ajelix Excel Add-in Setup for Translations

  • Author:
    Agnese
  • Published on:
    July 4, 2023
  • Category:
  • Last updated:
    April 6, 2024
  • Tags:
Ajelix excel add-in setup for translations

Creating API keys for translation is crucial for smoothly integrating translation services into your apps or workflows. API keys are secure credentials that let you use translation APIs from services like Google Translate or DeepL.

This tutorial will guide you on obtaining API from various providers. You can easily set up these keys in the Ajelix portal for convenient text translation.

Learn More About Excel Translations with Ajelix Add-in.

Why Do You Need an API Key?

API keys serve as a means of authentication and authorization when accessing translation APIs. Obtaining an API key ensures secure and controlled access to the quality translation services offered by Google Translate or DeepL. Without a valid API key, Ajelix Excel Add-in won’t be able to utilize translation tool.

Why Ajelix Doesn’t Provide Translation Characters in Subscription Plan?

Our plan has many tools and apps, with a low price, so all users can afford our services. However, we don’t provide translation characters so we would have to outsource this service and that would make subscription pricy. Additionally, we can’t forecast how many characters each user will use, so we decided to offer only integration.

Related Article: How To Create Excel Template?

Why Choose Google Translate API Key?

Currently, Google offers 500k characters free every month (even if it’s a full account and not a trial one). They claim that you will incur charges only if you exceed 500k characters. Also, the price is not that high only 20$ for one million characters which is approximately 1 paperback book. Translation accuracy doesn’t really differ from DeepL and both services offer the highest quality translations.

Google translate API key pricing

Screenshot from Google Cloud pricing

Make sure to review Google’s pricing information to understand any potential costs associated with API usage.

How To Register Google Cloud Account? (this step is mandatory to get an API Key)

To obtain an API key, first, you need to create a free Google Cloud account.

1.Go To Google Cloud Platform

2. Click on Get Started For Free

Create Google Cloud Account - step 1

3. Set up your account, by filling out your country, organization, and email.

Create Google cloud account - set up your free account

4. Insert the verification code from your email

Create google cloud account

5. Fill out the payment information to verify your account. You must fill in this field in case you overspend your free characters.

6. You should be all set up

How To Obtain Google Translate API Key?

The section provides comprehensive instructions on creating a project, enabling the Translation API, and generating a key. Once you have a Google Cloud account you can set up your Google Translate API key.

1.Go to Google Cloud Console

2. Type in the search bar Google Translate API and select this item

Get Google Translate API key

3. In the new window click on Enable

Get Google Translate api key - enable cloud translations

4. You will be forwarded to the dashboard. On the left corner click on Credentials

Google translate api key setup - fill out the credentials

5. Choose Create Credentials and click on the API key

Google translate API key, create

6. You should now have a ready-to-use API key you can now find it under the API keys section. Click on the Show Key and you will be able to copy it and insert.

Google translate api key

Once you copy the key, go to the Ajelix portal and insert it under the API keys section.

What Are The Costs Of DeepL API Key?

DeepL has a simple guide to get the translation key and they give 500K free characters per month. After reaching the limit, DeepL provides an API key for $4.99/month + $20 for every 1 million characters used.

deepl api translation pricing

DeepL pricing model for API translation key

How To Obtain DeepL Translation API Key?

Once you have chosen to use DeepL for your translations go to deepl.com and register a new account. After creating the account, you need to find an API key.

1.Find the menu dropdown on the right corner

2. Find Account settings

How to get deepl api key - guide

3. Scroll to the bottom and you’ll find Authentication Key for DeepL API. Copy the key and add it to your Ajelix account.

Related Article: How To Delete Chart in Excel?

How To Set Up API Keys in Ajelix Portal?

Get a key from Google Translate or DeepL, then follow these steps to set it up in the Ajelix portal.

1.Open the Ajelix portal

2. Navigate to the API keys section within the portal by accessing API Keys section

insert translation api key on ajelix portal to access translations

3. Copy the DeepL or Google Translate key and insert it into one of the fields in portal. And choose engine settings based on which translator have you chosen.

Insert API key in you account

4. Connect the Excel add-in with Ajelix portal to start translating. In the “Ajelix API Key (For Apps and Add-Ons)” box, click on the “Generate New” button.

generate ajelix api key

5. Copy the API key and paste it into your Excel or integration for using the translation service.

Ajelix excel add-in insert API key

6. Remember to click “Save” to ensure that the Ajelix portal successfully stores the API key.

Related Article: How To Remove and Uninstall Excel Add-in

Troubleshooting Common Issues

While setting up API keys for translation, you may encounter some common issues. Here are a few troubleshooting tips to help resolve them:

  1. Double-check the accuracy of the API key by ensuring there are no extra spaces or characters.
  2. Verify that the API key corresponds to the correct translation service provider (Google Translate or DeepL).
  3. If encountering errors, refer to the official documentation or support resources provided by the translation service provider for further assistance.
  4. Contact the Ajelix support team at support@ajelix.com if you require additional help or encounter any issues specific to the Ajelix platform.

Related Article: Remove Conditional Formatting in Excel

Conclusion

Setting up API keys for translation is a crucial step in integrating translation services into your applications or workflows. This tutorial will teach you how to obtain API keys from popular providers like Google Translate or DeepL. It will also guide you on how to set up these keys in the Ajelix portal. With the API keys correctly set up, you can enjoy seamless translation capabilities to enhance your productivity and language support.

If you need help, the Ajelix support team is always there to assist you with any problems or questions you have. Happy translating!

New Articles

Speed up your spreadsheet tasks with Ajelix AI in Excel

Excel formula generator from Ajelix - more than 15 ai tools for spreadsheets

Similar posts

How to analyze data in Excel spreadsheet banner by author

How To Analyze Data In Excel Spreadsheet

April 4, 2024
Excel is the workhorse of data analysis in countless businesses. It can unlock valuable insights from spreadsheets, but for many, its pow…
How to add drop down list in Excel banner

How To Add Drop Down List in Excel

November 2, 2023
Let’s take a look at how to add drop down list to make your spreadsheets more professional and user-friendly. We’ll take a lo…
How to add checkbox in Excel banner

How To Add Checkboxes In Excel

October 31, 2023
This article will cover steps to add checkboxes in Excel with screenshots and tips to help you tackle this task. Learn how to enable the …

Online Calculators

10 equipment rental KPIs for rental business owners banner

10 Equipment Rental KPIs For Rental Business

July 25, 2024
Equipment rental KPIs are measurable values that track how well your rental business is using its equipment to generate profit and satisf…
15 financial KPIs for finance department to track banner

20 Financial KPIs For The Finance Department

July 23, 2024
Financial KPIs are quantifiable metrics that businesses use to track their financial health and performance. They provide valuable insigh…
15 ecommerce kpis for online business owners banner

15 Ecommerce KPIs Any Online Business Should Track

July 18, 2024
Ecommerce KPIs track how well your online store is performing. These metrics provide insights into different areas of your business, like…
Accounting KPIs for your accounting department banner

15 Accounting KPIs For Your Accounting Department

July 16, 2024
Accounting KPIs are measurable metrics that track how well an accounting department is performing. These metrics help accountants assess …
KPI For Quality Assurance calculate quality kpis formulas and examples banner

15 KPI For Quality Assurance: Calculate Quality KPIs

July 11, 2024
Quality KPIs are key performance indicators for quality management used to assess a company’s performance in delivering quality pro…
Free EBIT calculator online with formula and examples banner

Free EBIT Calculator Online With Formula Examples

July 4, 2024
An EBIT calculator is a tool that helps you calculate a company’s earnings before interest and taxes (EBIT). EBIT is a financial me…

Business Intelligence

15 financial KPIs for finance department to track banner

20 Financial KPIs For The Finance Department

July 23, 2024
Financial KPIs are quantifiable metrics that businesses use to track their financial health and performance. They provide valuable insigh…
15 ecommerce kpis for online business owners banner

15 Ecommerce KPIs Any Online Business Should Track

July 18, 2024
Ecommerce KPIs track how well your online store is performing. These metrics provide insights into different areas of your business, like…
Accounting KPIs for your accounting department banner

15 Accounting KPIs For Your Accounting Department

July 16, 2024
Accounting KPIs are measurable metrics that track how well an accounting department is performing. These metrics help accountants assess …
KPI For Quality Assurance calculate quality kpis formulas and examples banner

15 KPI For Quality Assurance: Calculate Quality KPIs

July 11, 2024
Quality KPIs are key performance indicators for quality management used to assess a company’s performance in delivering quality pro…
generative AI for data analytics banner blog article by ajelix

Generative AI For Data Analytics: What You’re Missing Out

April 18, 2024
Organizations across all industries are turning to data analytics to inform strategic decisions, optimize processes, and gain a competiti…
Hoe to calculate business growth rate with examples and formula banner by ajelix

How to Calculate Business Growth Rate? Formula & Examples

April 16, 2024
Whether you’re a seasoned entrepreneur or just starting, measuring progress is vital to identify areas of strength, pinpoint opport…