To convert English text in Excel to Hindi, enter the text in a cell and use Microsoft 365’s TRANSLATE function, or select text and choose Review > Translate. The function is the practical choice for a list because you can fill it down; the Review tool is useful for translating a single item. Both produce Hindi text in Devanagari script, but translations may need checking for context.
What You’ll Need
- Excel for Microsoft 365, preferably updated, to use the
TRANSLATEworksheet function. The function may not be available in older perpetual Excel versions. Excel for the web also supports current Microsoft 365 features, though the interface can vary. - An internet connection and access to Microsoft’s connected translation services. Translation is an online feature, so your organization’s settings or policies may limit its availability.
- English text arranged in cells, ideally one phrase or sentence per row, and enough blank space in the adjacent column for the Hindi results.
Step-by-Step
- Set up a source column. Open the workbook and put English text in one column, with a heading such as English in A1. Enter the first phrase in A2, the next in A3, and continue down the column. Keeping the original text means you can compare it with the translation and fix mistakes without losing the source. For example, a small list might contain “Good morning,” “Thank you,” and “Where is the station?” in separate rows.
- Add a Hindi heading in the next column. Type Hindi in B1, or use another empty column if your sheet already has data. It is helpful to keep source and translated text side by side. Check that the output column is empty below the heading; otherwise, you could overwrite existing information when you fill the formula down.
- Enter the translation formula. With English text in A2:A20 and the first phrase in A2, enter
=TRANSLATE(A2,"en","hi")in B2. The first argument refers to the cell to translate; “en” identifies English as the source language, and “hi” identifies Hindi as the target language. These are language codes, not words to translate. Press Enter. For a source cell containing “Good morning,” Excel should return a Hindi translation such as “सुप्रभात”; exact wording can vary with context. - Fill the formula down for the rest of the list. Select B2, point to the small square at its lower-right corner (the fill handle), and drag down to the last row of English text. You can also copy B2, select the destination cells below it, and paste. Excel adjusts the cell reference as it fills, so the next row uses A3, then A4, and so on. If you have a long list, double-clicking the fill handle can fill down alongside a continuous adjacent data range; check the last row afterward.
- Wait for online results and review them. The function relies on an online translation service, so results might appear after a short delay. Read each Hindi result and compare it with the English source. A word can have multiple meanings, and short phrases often lack the context needed to choose the right one. For anything customer-facing, technical, legal, medical, or otherwise important, ask a fluent Hindi speaker to review the wording.
- Keep a stable copy if you need to share the translations. Formula results can depend on the translation service and may recalculate. To preserve the current Hindi wording, select the translated cells, copy them, then use Home > Paste > Paste Values to place fixed text over the formulas or in another column. If you want to retain both, paste values into a separate Hindi final column and keep the formula column until you have checked the output.
- Translate one-off text with the Review tool instead. Select a cell containing the text, then choose Review > Translate. In the Translator pane, set the destination language to Hindi if it is not already selected. Review the proposed wording and use Insert if the pane offers it to place the translation in the selected cell. Check the cell afterward, especially if it contains a longer paragraph or formatting you need to preserve. If Translate is unavailable, use the formula method if your Excel version supports it, or ask your administrator whether connected experiences are enabled.
On Excel for Mac, look for Translate on the Review tab; the ribbon layout and pane can differ slightly from Windows. Excel for the web may also show a different ribbon arrangement. The formula method works the same way when the function is available. If a formula entry is rejected because of your regional settings, check your Excel list-separator setting; some regional configurations use semicolons between arguments rather than commas.
Common Mistakes
- Reversing the language codes. In the formula, “en” is the source and “hi” is the target. Reversing them asks Excel to translate Hindi into English. If Excel cannot identify the source language, it may also help to specify “en” rather than leaving the source language for automatic detection.
- Expecting transliteration instead of translation. Translation converts meaning into Hindi. Transliteration represents the English sounds using Devanagari characters. For example, a name such as “Rahul” should generally remain a name, rather than be translated as if it were an ordinary English word. If you want English words written phonetically in Hindi script, state that requirement clearly and use a transliteration tool or a Hindi speaker; this worksheet function is not a dedicated transliteration feature.
- Replacing the original before checking the result. Pasting Hindi over the English source removes your reference and makes corrections harder. Keep the two languages in separate columns until the translations are approved.
- Translating isolated words with several meanings. A single word such as “right” can mean correct, the opposite of left, or a legal entitlement. Provide a full sentence when possible, or review ambiguous terms manually.
- Assuming every result is final or private by default. Machine translations can be imperfect, and online translation features may send text to a service for processing. Follow your organization’s data rules and do not submit sensitive content unless your policy permits it.
Tips
- Translate complete phrases rather than fragments. A complete sentence gives the service more context for tense, politeness, and word sense. Keep each sentence in one cell unless a deliberate line-by-line layout is important.
- Use consistent terminology. If a product name, department, or technical term must stay in English, maintain a small glossary and check every occurrence. A translation function may handle the same term differently in different sentences.
- Format the Hindi column for reading. Widen column B, turn on Wrap Text from Home > Wrap Text for long sentences, and use a readable font. Current Windows versions usually display Devanagari with a suitable font automatically. If characters appear as boxes, update Office or Windows and choose a font that supports Devanagari, such as Nirmala UI where available.
- Test on a few representative rows first. Try a greeting, a full sentence, a proper name, and a phrase with specialized vocabulary. This reveals whether your workbook has the function and whether the output style suits your audience before you process a large list.
- Preserve row alignment when sorting. Sort the entire table, not just one language column, so English and Hindi entries stay together. Consider converting the data into an Excel table with Ctrl+T on Windows; on Mac, use Command+T when the range is selected. Confirm the selected range includes both language columns.
- Use a human review for high-impact text. A formula is useful for drafts and routine lists, but it does not guarantee a culturally appropriate or legally accurate translation. Have a qualified reviewer check important notices, instructions, and public material before distribution.
Troubleshooting
- The formula returns an error or Excel says the function is unknown. Confirm that you are signed into a supported Microsoft 365 version and that Excel is updated. The worksheet function is not included in every older Excel edition. If it is unavailable, try Review > Translate for individual selections, or use an organization-approved translation service and paste checked results into the Hindi column.
- The result shows a connection, busy, or service error. Check your internet connection, wait briefly, and try again. Close and reopen the workbook if the error persists. Your organization may disable connected experiences; check with its Microsoft 365 administrator rather than changing managed privacy settings yourself.
- The wrong language appears or the result is unchanged. Verify that the source cell really contains English and that the formula uses “en” first and “hi” second. If the source text mixes languages, abbreviations, or names, automatic detection can be unreliable. Separate the text or rewrite it with enough context, then translate again.
- Hindi letters display as boxes, question marks, or disconnected glyphs. First confirm the cell contains Hindi characters by selecting it and checking the formula bar. If the formula bar looks correct, the issue is likely display or font support: update Office, try a Devanagari-capable font, and reopen the workbook. If the formula bar itself contains question marks, check that the text was not damaged during copying or import.
- The Review tab has no Translate command. Expand the ribbon or check the Review tab’s available commands. Some builds, accounts, or administrator policies may not expose the same translation features. Update Excel and verify that connected experiences are enabled for your account. When the command is still missing, use the function if available or an approved alternative.
- Only some rows translated. Check that the fill operation reached the final source row and that the destination cells were not blocked by existing content. Select a result near the bottom and inspect its formula reference. If it points to the wrong row, copy the correct formula down again and review the range before saving.
Frequently Asked Questions
Can I translate an entire Excel column from English to Hindi at once?
Yes. Put the English text in one column, enter the translation formula in the first output row, and fill it down. Review the results rather than assuming every row translated correctly.
What language code should I use for Hindi?
Use “hi” as the target-language code. For English-to-Hindi translation, specify “en” as the source and “hi” as the target.
Does the TRANSLATE function work in every version of Excel?
No. It is a Microsoft 365 feature and may not be present in older perpetual versions. If Excel does not recognize it, check your version and updates, then try Review > Translate if that command is available.
Can Excel translate Hindi back into English?
Yes. Use “hi” as the source code and “en” as the target code, while referencing a cell that contains Hindi. Review the result, since translating back may not reproduce the original English wording.
Will Excel convert English letters into Hindi script?
Not as a dedicated transliteration function. TRANSLATE converts meaning between languages; it does not simply spell English sounds in Devanagari. Use a transliteration tool or a fluent Hindi speaker when phonetic spelling is what you need.
Can I use these translations in an official document?
You can use Excel to prepare a draft, but machine translation should not be treated as certified or authoritative. Have a fluent, qualified person review important or regulated material, and follow any applicable organizational requirements.
Related
- How to Compare Lists in Excel for Differences
- How to Compare Two XML Files in Excel
- How to Compare Differences in Excel: Cells and Sheets
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formula to Join Two Text CellsTo join two text cells in Excel, enter =A2&B2 in another cell, replacing A2 and B2 with the…
- COUNT vs COUNTIF in Excel: Which One Should You Use?COUNT counts cells containing numbers, while COUNTIF counts cells that meet a condition you specify. Use COUNT for…
- Excel Data Sorting: Sort Rows, Columns, and Lists CorrectlyTo sort data in Excel for Microsoft 365 on Windows, click a cell in the column you want…
- Excel Formula to Build a Table AutomaticallyYes—Excel formulas can build a changing, table-shaped result, but a formula cannot create an actual Excel Table object.…
- Excel Table Header Formula: What Works and What Doesn’tExcel table headers are column labels, not the place to put a formula you expect to calculate or…
- DAX vs Excel Formulas: How They Differ and When to UseDAX and Excel formulas both calculate results, but they work in different places and answer different kinds of…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.