Supported Save and Open File Formats

Unicode Tutorials - Herong's Tutorial Examples

∟Using Microsoft Excel as a Unicode Text Editor

∟Supported Save and Open File Formats

This section provides a quick summary on Excel saving and opening Unicode files. UTF-16 (Little-Endian with BOM) is the best format for Excel.

Now we learned that Excel can save Unicode text files 1 encoding format:

Unicode Text (*.txt) format - Text files saved in UTF-16 byte sequences in Little-Endian with BOM format.

Excel can open Unicode text files in 2 encoding formats:

UTF-8 format - Text files opened with encoding format automatically detected as "65001 : Unicode (UTF-8)".
UTF-16 (Little-Endian with BOM) - Text files opened with encoding format automatically detected as "Windows (ANSI)".

Excel can not open Unicode text files in UTF-16BE or UTF-16LE encoding format correctly.

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

Python Language and Unicode Characters

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

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

Archived Tutorials

Full Version in PDF/EPUB