How to Change Encoding in Excel or Word

Text encoding determines how characters are stored and displayed in files. When you open a file with the wrong encoding in Excel or Word, you may see unreadable symbols, question marks, or broken special characters instead of normal text. This commonly happens with CSV, TXT, or data files created on different systems or exported from databases and web applications.

Microsoft Excel and Word both support multiple text encodings such as UTF-8, Unicode, and ANSI, but they do not always detect the correct encoding automatically. In many cases, you need to manually select the correct encoding while opening or saving a file to ensure the content displays correctly.

Changing encoding in Excel or Word involves using the correct import, open, or save options depending on the file type. The steps below explain how to change text encoding properly in both applications without corrupting data.

How to Change Encoding in Excel or Word

The methods in this section explain how to change or select encoding when opening or saving files in Excel and Word. Follow the steps carefully based on the application and file format you are working with.

1. Change Encoding When Opening a Text or CSV File in Excel

Excel allows manual encoding selection during import.

1. Open Excel.
2. Go to File.
3. Select Open.
4. Click Browse.
5. Change file type to Text Files or All Files.
6. Select your file and click Open.
7. When the Text Import Wizard appears, choose Delimited or Fixed width as needed.
8. Select the correct File origin (encoding), such as UTF-8 or Unicode.
9. Click Next and complete the import.

Choosing the correct file origin ensures characters display correctly.

2. Change Encoding When Saving a File in Excel

Saving with the correct encoding prevents future issues.

1. Open the file in Excel.
2. Go to File.
3. Select Save As.
4. Choose a location.
5. Click Save as type.
6. Select CSV UTF-8 (Comma delimited) or Unicode Text.
7. Click Save.

Using UTF-8 is recommended for international characters.

3. Change Encoding When Opening a Text File in Word

Word can prompt for encoding selection.

1. Open Word.
2. Go to File.
3. Select Open.
4. Click Browse.
5. Select the file.
6. Click the arrow next to Open.
7. Choose Open with encoding.
8. Select the correct encoding from the list.
9. Click OK.

This forces Word to use the chosen encoding.

4. Change Encoding When Saving a File in Word

Saving with a specific encoding preserves characters.

1. Open the document in Word.
2. Go to File.
3. Select Save As.
4. Choose a location.
5. Click Save as type.
6. Select Plain Text (.txt).
7. Click Save.
8. When prompted, choose the desired encoding such as UTF-8 or Unicode.
9. Click OK.

This ensures correct text encoding in the saved file.

5. Use Unicode or UTF-8 for Maximum Compatibility

UTF-8 is the most widely supported encoding.

1. Use UTF-8 when sharing files across systems.
2. Choose Unicode for Windows-only environments.
3. Avoid legacy encodings unless required.

Modern applications work best with UTF-8.

6. Fix Garbled Text After Opening a File

Incorrect encoding can be corrected by reopening the file.

1. Close the file without saving.
2. Reopen it using Open with encoding.
3. Try different encodings until text displays correctly.
4. Save the file with UTF-8 encoding.

This recovers unreadable text in most cases.

7. Convert Encoding Using Excel Import Instead of Double-Clicking

Double-clicking skips encoding selection.

1. Always open CSV or TXT files through File > Open in Excel.
2. Use the import wizard to choose encoding.
3. Avoid opening files directly from File Explorer.

This prevents automatic misinterpretation.

8. Verify Encoding After Saving

Confirm the file opens correctly.

1. Close Excel or Word.
2. Reopen the saved file.
3. Check special characters and symbols.
4. Adjust encoding again if needed.

Verification prevents data corruption.

Final Thoughts

Changing encoding in Excel or Word is essential when working with text files that include special characters, multiple languages, or data from external systems. Most encoding issues occur because Excel or Word automatically selects the wrong character set when opening or saving files.