Unicode Tutorials - Herong's Tutorial Examples
Dr. Herong Yang, Version 5.10

Using Microsoft Excel as a Unicode Text Editor

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.

Table of Contents

 About This Book

 Character Sets and Encodings

 ASCII Character Set and Encoding

 GB2312 Character Set and Encoding

 GB18030 Character Set and Encoding

 JIS X0208 Character Set and Encodings

 Unicode Character Set

 UTF-8 (Unicode Transformation Format - 8-Bit)

 UTF-16, UTF-16BE and UTF-16LE Encodings

 UTF-32, UTF-32BE and UTF-32LE Encodings

 Java Language and Unicode Characters

 Character Encoding in Java

 Character Set Encoding Maps

 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

 Unicode Code Point Blocks - Code Charts

 Outdated Tutorials

 References

 Printable Copy - PDF Version

Dr. Herong Yang, updated in 2012
Using Microsoft Excel as a Unicode Text Editor