How to Translate an Excel File from Japanese to English

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.

Translate Excel File from Japanese to English


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.

πŸ“Œ Steps:

  • 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.

Using Excel Translate Feature for Translating Japanese to English

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.

Result of using Excel Translate tab to Translate from Japanese to English

  • 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.

 Lastly, Translate Excel File from Japanese to 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.

Read More: How to Translate Chinese to English in Excel (2 Simple Methods)


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.

πŸ“Œ Steps:

  • Firstly, go to the link given below:
https://translate.google.com
  • Secondly, go to the Documents option on the web page.
  • Thirdly, click on the β€œBrowse your computer”.

Use of Google Translator to Translate an Excel File from Japanese to English

  • 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.

Downloaded the Translated Excel File from Japanese to English

  • 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.

Read More: How to Translate Language in Excel Formula (with Easy Steps)


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.

πŸ“Œ Steps:

  • Firstly, translate your Excel file.
  • Secondly, go to the File tab.

How to Convert PDF from Translated Excel File of Japanese to English

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.

Translated PDF File from Japanese to English

Read More: How to Translate Portuguese to English in Excel (4 Effective Ways)


πŸ’¬ 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.

Practice Section

Now, you can practice the explained method by yourself.

Practice Section for Translating Excel File from Japanese to English


Conclusion

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.


Related Articles

Musiha

Musiha

I am Musiha, graduated from Naval Architecture and Marine Engineering Dept., BUET, currently residing in Dhaka, Bangladesh. And my passion is to grow up my skillsets with industry demands.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo