You have come to the right place if you are looking for the answer or some unique tips to translate an Excel file to English. There are some easy ways of how to translate an Excel file from Japanese to English. In this article, I will explain how to translate an Excel file from Japanese to English using Microsoft 365 version.
Download Excel Workbook
You can download the Practice Workbook that I used to prepare this article. Furthermore, you can change or modify data & find new outputs accordingly.
2 Methods to Translate an Excel File from Japanese to English
Here, I will demonstrate 2 suitable methods with detailed steps of how to translate an Excel file from Japanese to English. For your better understanding, I am going to use the following dataset. Which contains four columns. Furthermore, all of those are written in the Japanese language.
Now, I will show you how you can easily translate them into English or even any other language. So, let’s see the methods.
1. Using Excel Translate Feature for Translating Japanese to English
You can simply use Microsoft Translator in Excel to translate Japanese to English or even any language to others. Here, you can follow the steps below.
- First, open the Excel file where the Japanese language data contains.
- Then, select a cell that contains the Japanese language data.
- After that, go to the Review tab in the top ribbon and click on the Translate option.
As a result, a new window named Translator will appear on the right side.
- Then, select the language to which you want to translate by clicking on the drop–down icon beside the language name. Here, I have selected English as it is.
As a result, you instantly see that the translated version of the data from the selected cell will be displayed in English.
- Now, copy the translated value in English using the CTRL+C shortcut and paste the value in cell B4 using the CTRL+V shortcut.
Finally, you will see the translated result in the B4 cell.
- Then, move to the next cell and similarly Copy-Paste the translated text to the C4 cell.
- So, do the same thing for all other cells. And by this, you can translate any language data into English.
Note: Similarly, you can easily translate Chinese, German, Gujarati, Arabic, Hindi, French, Spanish, Korean, or any other language data to English.
Furthermore, if you want to ignore the manual process of a +0.copy-pasting cell by cell then you can use Notepad. Simply, copy all values and paste them to Notepad. Then, again copy those from Notepad and paste them to your desired worksheet.
2. Use of Google Translator to Translate an Excel File
There is another way to translate an Excel file into English. You can use Google Translate. For this, follow the steps below.
- Firstly, go to the link given below:
- Secondly, go to the Documents option on the web page.
- Thirdly, click on the “Browse your computer”.
- Then, select the Excel file that you want to translate.
- Subsequently, press Open.
- After uploading the Excel file in the webpage, you will see the name of the Excel file.
- Then, choose English and click on the Translate button.
- After that, simply click on the “Download translation” button to download the translated Excel file.
- After downloading, you will see that all cell values, that were in foreign languages, are converted into English.
Furthermore, Google Translator will translate not exactly the way you want. Like it translated the US Region as We Area. Because us and we are synonyms of words. So, you should recheck it always.
Here, I have modified the format. So, you can also format it to your preferred one.
How to Convert PDF from Translated Excel File of Japanese to English
In this section, I will explain how you can convert your translated Excel file into a PDF file. Let’s see the steps.
- Firstly, translate your Excel file.
- Secondly, go to the File tab.
At this time, a new window will appear.
- Then, go to the Save As option.
- Now, from the drop-down arrow >> choose PDF (*.pdf) extension.
- Then, click on the Save button.
Lastly, you will see your translated PDF file.
💬 Things to Remember
- Here, using a built-in translator in Microsoft Excel requires an internet connection.
- Also, while using the built-in translator, you have to copy and paste manually for each cell. Here, you may use Notepad.
- However, to translate large datasets, you should use Google Translate.
- Moreover, there can be some error translations, you should recheck it always.
Now, you can practice the explained method by yourself.
I hope you found this article helpful. Here, I have explained 2 suitable methods of how to translate an Excel file from Japanese to English. You can visit our website Exceldemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.