Unicode Tutorials - Herong's Tutorial Examples - v5.32, by Herong Yang
Opening UTF-8 Text Files
This section provides a tutorial example on how to open a UTF-8 text file with Excel correctly by selecting the '65001 : Unicode (UTF-8)' encoding option on the Text Import Wizard dialog box.
First, let's try to use Excel to open the UTF-8 text file, hello.utf-8, created from the previous chapter.
1. Run Excel and click menu File > Open. The Open file dialog box comes up.
2. Select the hello.utf-8 text file and click the Open button. The Text Import Wizard dialog box comes up automatically. Excel detected the encoding to be "65001 : Unicode (UTF-8)" and suggests you to use it to read the text file. See the correct text in the preview section in the picture below:
3. Click the Next button and finish the import process. My UTF-8 text file opens in Excel correctly.
Very nice. This proves that Word can open UTF-8 text file correctly if the "Unicode (UTF-8)" encoding option is selected.
If you select a different encoding, like (65000 : Unicode (UTF-7), the UTF-8 text file will be opened incorrectly. Try it out yourself.
Table of Contents
ASCII Character Set and Encoding
GB2312 Character Set and Encoding
GB18030 Character Set and Encoding
JIS X0208 Character Set and Encodings
UTF-8 (Unicode Transformation Format - 8-Bit)
UTF-16, UTF-16BE and UTF-16LE Encodings
UTF-32, UTF-32BE and UTF-32LE Encodings
Python Language and Unicode Characters
Java Language and Unicode Characters
Encoding Conversion Programs for Encoded Text Files
Using Notepad as a Unicode Text Editor
Using Microsoft Word as a Unicode Text Editor
►Using Microsoft Excel as a Unicode Text Editor
Saving Files in "Unicode Text (*.txt)" Option