Why does excel always say "..may contain features that are not compatible with CSV" when saving a CSV file?

Microsoft Excel will claim this when saving to just about any format other than .xls or .xlsx. The reason is that only these (proprietary Microsoft) formats can support Excel features like formulas, (conditional) formatting, charts, multiple worksheets, etc.

If all you're saving is data, you can safely ignore this message. I think you can even tell Excel to shut up and stop telling you that with a little "Don't show this warning again" tickbox on that "error" message.

To the person criticizing "your" CSV formatting, I'd shoot back that it's Excel, not you, generating the CSV file, so any error in the CSV format is Excel's error, not yours.


Looks like there is a way to fix this, I just found this article, which worked for me using Excel 2013.

Registry subkey 
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options
Value name  DisableSaveAsLossWarningOpenDocumentSpreadsheet
Value type  DWORD
Value data  0 - Display the warning message
            1 - Suppress the warning message

The registry value changes to

DisableSaveAsLossWarningOpenDocumentPresentation for Powerpoint and
DisableSaveAsLossWarningOpenDocumentText for Word

The features that Excel is complaining about are settings and functionality like cell formatting, column filters, formulas, and other Excel specific functionality that won't be saved when you save to a CSV.

For example, if you had a cell that contained a formula, such as =2+2, only the evaluated value of 4 would be stored in the CSV, the formula itself would be lost.