Supported Save and Open File Formats

<< Using Microsoft Excel as a Unicode Text Editor

<< Unicode Tutorials - Herong's Tutorial Notes

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.

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