Unicode Tutorials - Herong's Tutorial Notes
Dr. Herong Yang, Version 5.00

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.

Sections in This Chapter

What Is Microsoft Excel?

Opening UTF-8 Text Files

Opening UTF-16BE Text Files

Opening UTF-16LE Text Files

Saving UTF-8 Text Files

Saving Files in "Unicode Text (*.txt)" Option

Opening UTF-16 Text Files

Supported Save and Open File Formats

Dr. Herong Yang, updated in 2009
Opening UTF-16LE Text Files