Data Import & Export

How to Display Tamil Text Correctly in Excel CSV Files

Steven ParkerSteven Parker Nov 3, 2026 869 views

Question details

The user needs to correctly view Tamil characters inside an Excel CSV file without experiencing text corruption or unreadable symbols.

How to Display Tamil Text Correctly in Excel CSV Files
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.
Before you start

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.

Solution 1Recommended

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.

1
Open a Blank Workbook

Launch Excel and open a completely new, blank workbook rather than opening the CSV file directly.

2
Navigate to the Data Tab

Click on the 'Data' tab located on the top ribbon, then select 'From Text/CSV' in the 'Get & Transform Data' group.

3
Select the CSV File

Browse your computer for the CSV file containing the Tamil text, select it, and click 'Import'.

4
Apply UTF-8 Encoding

In the preview window that appears, click the 'File Origin' dropdown menu and change it to '65001: Unicode (UTF-8)'.

5
Verify and Load

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.

Import the CSV File Using Data Tab with UTF-8 Encoding
Pro Tip: Always use 'Save As' and select 'CSV UTF-8 (Comma delimited)' when saving your changes to prevent the Tamil text from corrupting again.
Easily Manage CSV Files

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. 1. Launch WPS Spreadsheet: Open WPS Office and create a new blank spreadsheet.
  2. 2. Access Data Import: Go to the 'Data' tab on the top menu and select 'Import Data'.
  3. 3. Select Your File: Choose 'Select Data Source', browse for your Tamil CSV file, and proceed.
  4. 4. Set File Encoding: In the File Conversion prompt, select 'Other encoding', scroll down, and choose 'Unicode (UTF-8)'.
  5. 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.
Fully compatible with Microsoft Excel CSV, XLS, and XLSX formatsStraightforward Text Import Wizard for accurate data encodingNative support for complex Unicode characters and regional scriptsFree, lightweight, and fast alternative to heavy spreadsheet software
QA img-9

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.