How to Type Hindi in MS Excel (एमएस एक्सेल में हिंदी टाइपिंग कैसे करें)
To type Hindi in MS Excel cells, activate the Windows Hindi Phonetic language keyboard (Win + Spacebar), select the Excel cell, and type phonetically. To convert existing English lists to Hindi in Excel, use our online transliteration tool or Google Sheets GOOGLETRANSLATE formula and export back to Excel.
Step-by-Step Instructions
Set Input Language
Enable Windows Hindi language pack and press Win Key + Spacebar.
Select Excel Cell
Click on any worksheet cell or press F2 to enter edit mode.
Type Hindi Entry
Type Roman phonetic characters to generate Hindi Devanagari text.
Save Spreadsheet
Save file as Excel Workbook (.xlsx) or CSV UTF-8 (Comma delimited).
Method 1: Direct Hindi Data Entry in Excel Cells (एक्सेल में डायरेक्ट टाइपिंग)
Type Hindi text inside individual cells in Excel sheets:
- 1. Enable Windows Hindi Phonetic keyboard under Settings > Time & Language.
- 2. Open your Excel spreadsheet (.xlsx).
- 3. Press Windows Key + Spacebar to switch system language to Hindi.
- 4. Double-click or press F2 on an Excel cell.
- 5. Type phonetically (e.g. 'naam' -> 'नाम', 'pata' -> 'पता'). Press Enter to move to the next cell.
Method 2: Batch Converting English Name Lists to Hindi for Excel (नाम सूची का हिंदी रूपांतरण)
If you have a column with 100+ English names and need to generate Devanagari Hindi entries:
- 1. Copy the column of English names from Excel.
- 2. Paste into Google Sheets in column A.
- 3. In column B, enter formula: =GOOGLETRANSLATE(A1, "en", "hi").
- 4. Drag formula down to convert all rows into Devanagari Hindi.
- 5. Copy column B results and paste back into MS Excel as Values.
Method 3: Using Kruti Dev 010 in Excel (कृतिदेव 010 से एक्सेल में काम करना)
For government department spreadsheets requiring Kruti Dev 010 format:
- 1. Select the required cell range or column in Excel.
- 2. Change font from Arial/Calibri to 'Kruti Dev 010' in the top font dropdown menu.
- 3. Type using Kruti Dev key map on your physical keyboard.
Technical & Benchmark Facts
| Supported Excel Versions | MS Excel 2007, 2010, 2013, 2016, 2019, 2021, Office 365 |
| UTF-8 CSV Support | Full Unicode Devanagari export support |
| Formula Compatibility | VLOOKUP, INDEX/MATCH, CONCAT, IF support Hindi strings |
Frequently Asked Questions
When saving as CSV in Excel, choose 'CSV UTF-8 (Comma delimited) (*.csv)' instead of standard CSV to preserve Devanagari characters.