Unicode Tutorials - Herong's Tutorial Examples - v5.32, by Herong Yang
Opening UTF-16LE Text Files
This section provides a tutorial example to prove that Excel can not open a UTF-16LE text file. Its Text Import Wizard only supports UTF-7 and UTF-8 encodings.
In the next test, I want to use Excel to open the UTF-16LE text file, hello.utf-16le, 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-16le text file and click the Open button. A warning message dialog box comes up.
I tried clicking OK to use the Text Import Wizard. But Excel does not provide the UTF-16LE encoding in the "File origin" list.
Too bad. This proves that Excel can not open UTF-16LE text files.
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