Convert Japanese to English in Excel: A Step-by-Step Guide

How-to basics · Updated November 20, 2026

To convert Japanese text to English in Excel for Microsoft 365, enter =TRANSLATE(A2,"ja","en") in a blank cell if the Japanese text is in A2, then fill the formula down for more rows. You can also select a cell and choose Review > Translate to translate text manually. The formula is better for a list; the Translate pane is useful for a quick one-off translation.

Excel’s translation is machine-generated, so it can help you understand or sort text but may not capture context, tone, names, or specialized terminology perfectly. Keep the original Japanese alongside the English result, and have important translations checked by a fluent speaker.

What You’ll Need

  • Excel for Microsoft 365 on Windows, with an internet connection for the translation service. The TRANSLATE function is also available in Excel for the web and supported Microsoft 365 versions on Mac.
  • A worksheet containing Japanese text. You do not need to install a Japanese language pack to translate text already in the workbook.
  • A blank column or another safe place for the English output, so the original text stays unchanged.
  • Access to connected online services. If your organization disables connected experiences, or your Excel build does not include TRANSLATE, use the Review tab’s Translate command if available or ask your administrator about access.

Step-by-Step

  1. Make a copy or preserve the source column. Before translating a large list, save a copy of the workbook or duplicate the worksheet. Keep Japanese in its own column and put English in a separate column. This makes it possible to compare results, fix mistakes, and return to the source if a translation is unsuitable. If the workbook contains confidential material, check your organization’s policy before sending text to an online translation service.
  2. Check how the Japanese text is stored. Click a cell and look at the formula bar to confirm that it contains the text you expect. A Japanese phrase may be stored as ordinary text, or it may be the result of a formula. If the text displays as empty boxes or question marks, resolve the font or encoding issue first; translation cannot reliably recover characters that are already missing or corrupted. If the text is inside a longer sentence, the whole cell will be translated as a unit.
  3. Add a heading for the output column. For example, if column A is headed Japanese, enter English in B1. Keeping headings clear helps prevent you from pasting translated results over the original data and makes the worksheet easier to share. If your data has other columns, choose an unused column and check that it will not overwrite existing information.
  4. Enter the TRANSLATE formula for the first row. With the Japanese phrase in A2 and the English result intended for B2, select B2 and type =TRANSLATE(A2,"ja","en"), then press Enter. The first argument is the text or cell to translate; ja identifies Japanese as the source language, and en identifies English as the target. For example, if A2 contains おはようございます, the result is typically “Good morning.” The exact wording can vary with context and service updates.
  5. Check the first result before translating the rest. Compare the output with the Japanese source and confirm that the formula refers to the correct cell. If you see a formula error, verify that the function is available in your Excel version and that you have an internet connection. Test a short, ordinary phrase before using the formula on a large or important dataset.
  6. Fill the formula down the list. Select B2 and point to the small square at the lower-right corner of the cell selection, called the fill handle. Drag it down alongside the Japanese entries. You can also copy B2, select the destination cells, and paste. Excel adjusts the reference as it fills: the next row refers to A3, then A4, and so on. If the data is an Excel table, entering the formula in the first data row may fill the calculated column automatically.
  7. Review and preserve the completed results. Read a sample from the top, middle, and bottom of the translated list, and check unusual or business-critical phrases individually. If you need fixed text rather than formulas, select the translated cells, copy them, then use Home > Paste > Values to paste the displayed results over a separate destination range. Do not paste values over the Japanese source unless you deliberately want to replace it. Save the workbook after checking the output.

To translate one cell without a formula, select the cell and choose Review > Translate. In the Translator pane, confirm the source and target languages, read the English result, then copy it into a suitable cell. The pane is intended for reviewing selected text; it is less convenient than a formula when you need to process many rows. Menu placement can vary slightly by Excel build, but the command is on the Review tab in supported desktop versions.

On Excel for the web, enter the same TRANSLATE formula in a cell and fill it down; the workbook needs a working internet connection. On Mac, the formula works in supported Microsoft 365 versions, and the Translate command may be available on the Review tab. If you do not see a command or function, update Excel or use the web version where your account permits it. Excel menus and availability can differ by update channel and organization settings.

Common Mistakes

  • Using an unsupported Excel version. TRANSLATE is a newer Microsoft 365 function, not a universal feature of every older perpetual edition of Excel. If Excel displays #NAME? or does not recognize the function, check your version and update status. Use the Translate pane if available rather than assuming another similar-sounding formula exists.
  • Reversing the language codes. In =TRANSLATE(A2,"ja","en"), ja is the source and en is the target. Reversing them asks Excel to translate English into Japanese. Use the two-letter language codes in the formula, not language names such as “Japanese” or “English.”
  • Overwriting the Japanese source. Putting the formula in the same cell as the source removes the input the formula needs and can cause a circular reference. Use a separate output column and retain the original until you have verified the results.
  • Expecting a perfect translation of isolated words. Japanese meaning depends on context, formality, and the surrounding sentence. A short label, name, abbreviation, or product term may be translated inconsistently or literally. Review context-sensitive entries rather than treating every output as publication-ready.
  • Translating blanks or unrelated rows. If you fill the formula farther down than your data, Excel may try to translate empty cells. Keep the fill range aligned with the source list and inspect the last row. For irregular lists, select only the rows that contain Japanese text.
  • Assuming a displayed result is permanent. A formula result depends on its source cell and may update when the source changes or Excel recalculates. If you need a fixed snapshot, copy the output and paste values into a separate range after reviewing it.

Tips

  • Use one phrase or record per cell. Separate rows are easier to translate, filter, review, and correct than a large block of mixed Japanese and other content. If a cell contains several sentences, Excel translates the whole cell, which can make it harder to match each English sentence to its source.
  • Keep source and translation side by side. This makes spot-checking easier and gives reviewers enough context to flag a mistranslation. Use clear headers and avoid sorting only one column; sort the entire data range or table so each English result stays matched to its Japanese source.
  • Check proper nouns and technical terms manually. Names, addresses, model numbers, industry vocabulary, and brand terms may need a preferred spelling or may be better left untranslated. Add a review column if someone needs to approve the final English wording.
  • Translate a representative sample first. Try several types of content—short labels, full sentences, and specialized terms—before filling thousands of rows. This helps reveal whether the function is available, whether the language direction is right, and whether the output style suits the purpose.
  • Use formulas for repeatable work and the pane for inspection. A formula is efficient when many cells need the same language direction. Review > Translate is handy when you want to inspect one selection or translate text without building a formula. Neither method removes the need to verify important wording.

Troubleshooting

Excel returns #NAME? The function may not be supported in your edition or may not yet be available in your update channel. Check File > Account > About Excel to identify your installed version, then install available Office updates if permitted. If the function remains unavailable, select a cell and check Review > Translate, or use Excel for the web with your Microsoft account.

The formula is shown as text instead of producing a result. The cell may be formatted as Text, or the formula may have been entered with a leading apostrophe. Change the cell format to General, edit the cell, and press Enter again. Also confirm that the first character is an equals sign and that the quotation marks and parentheses match the example.

You get a connection or service error. Confirm that you are online, then try a short phrase again. A corporate firewall, privacy setting, or administrator policy may block connected translation services. If the problem affects multiple workbooks, check with your IT administrator rather than repeatedly editing the formula.

The result is in the wrong language or is awkward. Check that the source and target codes are ja and en in that order. For awkward wording, try translating a complete sentence instead of a fragment and review the result with a fluent speaker if accuracy matters. Machine translation can suggest meaning, but it does not establish an official or legally reliable translation.

Some Japanese characters look wrong. Check the original cell, not just the English output. If the source contains replacement characters or is garbled, obtain a clean copy from the original file or sender. Changing the font may fix a display issue, but it cannot restore data that was lost during import.

Only some rows translated. Check for gaps in the fill range, filtered or hidden rows, and formulas that point to the wrong source column. Select a result cell and inspect the formula bar. If you copied formulas, make sure the source reference changes by row and still points to the Japanese text.

Frequently Asked Questions

Can Excel translate a whole column at once?
Yes. Enter the TRANSLATE formula for the first Japanese row in a neighboring column, then fill it down. Check that the formula range matches the source rows and review a sample of the output.

Does TRANSLATE work without the internet?
Do not rely on it offline. The function uses Microsoft’s online translation service, so an internet connection and permitted connected experiences are needed. The Review > Translate command also relies on online translation in supported versions.

Can I translate English to Japanese instead?
Yes. With English text in A2 and the result intended for B2, enter =TRANSLATE(A2,"en","ja"). The first code is the source language and the second is the target language.

Can Excel translate a workbook’s menus or interface?
No. These steps translate text in worksheet cells or selected text through the Translate pane; they do not change Excel’s display language or translate every label in the workbook.

Can I use this for an official document?
Use Excel’s result as a draft or aid to understanding, not as a certified translation. For legal, medical, contractual, or public-facing material, have the wording reviewed by a qualified translator or appropriate subject-matter professional.

Why is there no Translate button on my Review tab?
Availability can depend on the Excel version, platform, update channel, and organization settings. Update Microsoft 365 if possible, check Excel for the web, or ask your administrator whether connected translation features are disabled.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.