Working with Tamil Data in Microsoft Excel
Microsoft Excel is widely used across business organizations, accounting firms, government departments, and educational institutions for managing student databases, payroll registers, inventory records, and client contact lists in Tamil Nadu, Sri Lanka, and Singapore.
Excel fully supports standard UTF-8 Unicode Tamil text, enabling full search (Ctrl + F), auto-filter, and alphabetical sorting across Tamil data columns.
Essential Excel Tamil Operations Cheat Sheet
| Excel Task | Recommended Method | Best Practice / Note |
|---|---|---|
| Cell Data Entry | Enable Windows/Mac Tamil Phonetic IME or Copy-Paste from TamilKeyboard.in | Ensure cell font is set to Nirmala UI or Noto Sans Tamil |
| Alphabetical Sorting | Data > Sort A to Z (அ முதல் ன வரை) | Unicode sorts Tamil names according to dictionary sequence |
| CSV Export | File > Save As > CSV UTF-8 (Comma delimited) (.csv) | Do NOT use standard CSV; always select CSV UTF-8 |
| Monetary Words | Use our Number to Tamil Words tool | Generates formal monetary amounts (e.g. ₹5,000 → ஐந்தாயிரம் ரூபாய்) |
Preventing CSV Character Corruption in Excel
A common issue when opening CSV files in Excel is seeing garbled symbols like "வணகயமி". This occurs because legacy Excel opens `.csv` files using ANSI encoding by default.
To open Tamil CSV files cleanly in Excel:
- Open Microsoft Excel with a blank workbook.
- Go to the Data tab, click Get Data > From File > From Text/CSV.
- Select your `.csv` file, set File Origin to 65001 : Unicode (UTF-8), and click Load.