How to Display Tamil Text Correctly in Excel CSV Files
Question details
The user needs to correctly view Tamil characters inside an Excel CSV file without experiencing text corruption or unreadable symbols.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Opening or importing a comma-separated values (CSV) file that contains data written in the Tamil language.
- Observed behavior
- Tamil characters display incorrectly as gibberish, question marks, or broken symbols due to mismatched encoding, incorrect delimiters, or improper import settings.
Ensure that your system has a standard Tamil Unicode font installed (such as Latha or Nirmala UI) and identify the specific delimiter (like a comma or semicolon) used in your original file.
Import the CSV File Using Data Tab with UTF-8 Encoding
Directly double-clicking a CSV file forces Excel to use default system encoding. Importing the file manually allows you to explicitly select UTF-8 encoding, preserving Tamil characters.
CSV files lack inherent formatting or encoding tags. By using the 'From Text/CSV' or Power Query feature, you intercept the data before it loads, allowing you to manually apply the universal UTF-8 standard that supports complex scripts like Tamil.
Launch Excel and open a completely new, blank workbook rather than opening the CSV file directly.
Click on the 'Data' tab located on the top ribbon, then select 'From Text/CSV' in the 'Get & Transform Data' group.
Browse your computer for the CSV file containing the Tamil text, select it, and click 'Import'.
In the preview window that appears, click the 'File Origin' dropdown menu and change it to '65001: Unicode (UTF-8)'.
Ensure the correct delimiter (such as Comma) is selected, check that the Tamil text displays properly in the preview panel, and click 'Load' to bring the data into your spreadsheet.

Verify Excel Language Settings and System Fonts
If importing the file with UTF-8 encoding does not resolve the issue, Excel or your operating system may lack the necessary language resources to render Tamil text.
Open Tamil CSV Files Correctly with WPS Spreadsheet
WPS Spreadsheet features an intuitive Text Import Wizard that automatically detects or lets you easily select UTF-8 encoding, ensuring that Tamil and other regional characters are perfectly preserved without complex configurations.
- 1. Launch WPS Spreadsheet: Open WPS Office and create a new blank spreadsheet.
- 2. Access Data Import: Go to the 'Data' tab on the top menu and select 'Import Data'.
- 3. Select Your File: Choose 'Select Data Source', browse for your Tamil CSV file, and proceed.
- 4. Set File Encoding: In the File Conversion prompt, select 'Other encoding', scroll down, and choose 'Unicode (UTF-8)'.
- 5. Complete the Import: Follow the rest of the text wizard to map your columns and load the perfectly formatted Tamil text into your sheet.

Frequently Asked Questions
Why do my Tamil characters turn into gibberish when I double-click a CSV file?
When you double-click a CSV file, Excel attempts to open it using your computer's default regional ANSI encoding. Since ANSI does not support complex scripts like Tamil, the characters are converted into unreadable symbols or question marks. You must use the Data import tool to specify UTF-8 encoding.
Can I save a CSV file containing Tamil text without losing the characters?
Yes. Instead of using the standard 'Save' shortcut, go to 'File' > 'Save As'. In the 'Save as type' dropdown menu, explicitly select 'CSV UTF-8 (Comma delimited) (*.csv)'. This ensures the Unicode formatting is embedded in the file.
Which fonts are best for displaying Tamil text in a spreadsheet?
Standard Unicode fonts provide the best compatibility for Tamil text. Fonts such as Nirmala UI, Latha, Arial Unicode MS, and Vijaya are highly recommended to ensure the script renders correctly without broken ligatures.




