What is Byte Order Mark & CSV-Excel Compatibility?

Published on November 10, 2026 • Last updated November 10, 2026

Official Definition

A Byte Order Mark (BOM) is a specific byte sequence (EF BB BF in UTF-8) placed at the start of a text file to signal Unicode encoding, ensuring Microsoft Excel renders special characters properly.

Detailed Explanation

In-Depth Guide

Key Takeaway

Although UTF-8 is the universal character encoding standard on the modern web and Linux systems, legacy software—most notably Microsoft Excel on Windows—historically opens CSV files using the computer's local ANSI code page (like Windows-1252) unless an explicit UTF-8 Byte Order Mark is present.

Without a BOM, accented characters (like é, ñ), currency symbols (like ₹, €), and non-Latin scripts degrade into corrupted mojibake characters (e.g., é).

Adding a UTF-8 BOM or converting CSV files into native Excel .xlsx workbooks preserves character fidelity and column types across all versions of Excel.

Frequently Asked Questions

BOM stands for Byte Order Mark. In UTF-8, it is a 3-byte signature at the beginning of the file that explicitly announces UTF-8 character encoding.

Excel automatically infers column data types and treats numeric strings like "01234" as numbers, stripping the leading zero to produce "1234". Converting to XLSX preserves text formatting.

Some older Unix command-line tools (such as certain grep or shell scripts) may treat the BOM as unexpected characters. However, for spreadsheet exports, UTF-8 BOM is recommended.

What do you need to work out next?

Search 276+ free tools by name, or pick a category below. Every one runs instantly in your browser — no signup, nothing to install.

More Finance tools
AI ADVISOR & COACH

Ask AI Advisor

Ask AI