Unicode Tutorials - Herong's Tutorial Examples - Version 5.20, by Dr. 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.
Last update: 2009.
Table of Contents