💻 Software
Saving a file in a CSV type in Excel always removes the BOM
Fresh5 days ago
Mar 15, 202637637 viewsConfidence Score0%
0%
Problem
I've been trying to find a reasonable solution/explanation (unsuccessfully) to find out why Excel defaults to removing the BOM when saving a file to the CSV type. Please forgive me if you find this a duplicate of this question. This handles reading CSV files with non-ASCII encoding, but it doesn't …
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Saving a file in a CSV type in Excel always removes the BOM
Low Risk
There are no polite answers to questions of the form "Why does Excel do X?". Why don't you just adopt "Save as Unicode Text" as your standard transfer format? Excel Save as ensures there's a BOM, uses TAB as a delimiter, quotes fields just like CSV …
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix