How to Translate Arabic to English in Excel (With Easy Steps)

This tutorial will demonstrate how to translate Arabic to English in Excel. In this modern era, global communication and trading have become very important. But it is very evident that one can’t take possession of every language. So, it is very important to learn to translate one language to another in Excel. In this article, we will try to translate Arabic to English in Excel. Please follow the article thoroughly to enjoy the journey of this learning.

How to Translate Arabic to English in Excel: With Easy Steps

Our target is to translate Arabic to English in Excel. To fulfill that purpose, at first, we’ll use a sample dataset overview as an example in Excel to understand easily. Then, we will gonna use the Translate option in Excel. This option will translate the desired cell values from Arabic to English. If you follow the steps correctly, you should learn how to translate in Excel on your own.

Step 1: Arranging Dataset

In this case, our goal is to arrange a dataset that will be further used to translate Arabic into English. In this instance, we have Arabic Sentence in Column B and an English sentence in Column C. We have managed some of the famous Arabic sentences and put them into Column B for our usage.

Step 2: Using Translate Option

After arranging the proper dataset, we will aim to translate Arabic sentences into English in Excel. To do so, we will take the help of the Excel built-in Translate option. It can easily convert one language text into another language text. Let’s describe thoroughly how to use the Translate option to achieve our aim.

Firstly, select the whole data range( in this case whole Column B) that you want to convert.

Secondly, right-click on the selected data and select the Translate option from the context menu option.

Thirdly, you can alternatively select the Translate option from the Ribbon. Select the data >> Review >> Translate options to do the same work. It is similar to the previous step. So, you can use any of the steps.

Step 3: Showing the Final Result

In this portion of the article, we want to show the final outcome of the Excel. The description is below.

To begin with, after using the Translate option, at the right side of your window, you will see a Translator portion has opened on the screen. In the From option select the source data language( you want to change) and in the To option select the desired language( you want the data to be changed into). In this case, we have tried to convert Arabic into English and got the below result.

In addition, then press Ctrl+C to copy the value from the Translator window and Ctrl+V to paste the value in the desired cell( in this case cell C5). Remember that you have to press the copy and paste every data individually.

Finally, if you have copied and pasted every data in Excel then you will get your desired result.

How to Translate English to Arabic in Excel

Our target is to translate English to Arabic in Excel. To fulfill that purpose, at first, we’ll use a sample dataset overview as an example in Excel to understand easily. Then, we will gonna use the Translate option in Excel. This option will translate the desired cell values from English to Arabic. If you follow the steps correctly, you should learn how to translate English to Arabic in Excel on your own.

Steps:

First, our goal is to arrange a dataset that will be further used to translate English into Arabic. In this instance, we have an Arabic sentence in Column C and an English sentence in Column B. We have managed some of the famously used English sentences and put them into Column B for our usage.

Secondly, you can alternatively select the Translate option from the Ribbon. Select the data > Review > Translate options to translate English to Arabic in Excel.

Thirdly, after using the Translate option, at the right side of your window, you will see a Translator portion has opened on the screen. In the From option select the source data language( you want to change) and in the To option select the desired language( you want the data to be changed into). In this case, we have tried to convert English to Arabic and got the below result.

Lastly, if you have copied and pasted every data in Excel then you will get your desired result. And that’s how Excel data can be translated from English to Arabic.

Things to Remember

In the 2nd step, for selecting the Translate option, we have shown two methods. You can use any of the methods to do the work.
After using the Translate option, you will get the result in the right-side Translator window at first. But this is not permanent. If you go to another data value it will show the result for that value. So, you have to copy and paste the translated value into your Excel.
We have shown the steps for Arabic to English. But you can apply to translate any other language too.

Download Practice Workbook

You can download the practice workbook from here.

Translating Arabic to English.xlsx

Conclusion

Henceforth, follow the above-described methods. These methods will help you to translate Arabic to English in Excel. We will be glad to know if you can execute the task in any other way. Please feel free to add comments, suggestions, or questions in the section below if you have any confusion or face any problems. We will try our level best to solve the problem or work with your suggestions.

<< Go Back to Translate in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!