Using Microsoft Excel as a Unicode Text Editor

<< Unicode Tutorials - Herong's Tutorial Notes

This chapter provides notes and tutorial examples on using Microsoft Excel as a Unicode text editor. Topics including testing to open text files in 3 encodings: UTF-8, UTF-16BE, and UTF-16LE; saving and opening Unicode text files in UTF-16 (Little-Endian with BOM) format.

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

Conclusions:

• Excel can be used to edit Unicode text files.
• Excel allows you to save Unicode text files in UTF-16 (Little-Endian with BOM) format.
• Excel allows you to open Unicode text files in UTF-8 and UTF-16 (Little-Endian with BOM) formats.
• The BOM character is the "ZERO WIDTH NO-BREAK SPACE" character, U+FEFF, in the Unicode character set.