Fix the CSV File Format and Extension Warning in Excel 2016
Question details
The user needs to open CSV files in Excel 2016 without a file format and extension warning and with data separated into columns.

- Product
- Microsoft Excel 2016
- Device & OS
- not provided
- Scenario
- Opening CSV files from a network drive or downloaded folder on computers running Office 2016.
- Observed behavior
- Excel 2016 displays a file format and extension warning, while the same files open with data separated into columns in Excel 2007 and 2013.
Confirm that the CSV comes from a trusted source and note whether it uses commas, semicolons, or another delimiter. Compare the affected computers' regional settings with those on a computer where the files open as expected.
Import the CSV with the Correct Delimiter in Excel 2016
Use Excel's text import options to control how CSV data is separated into columns.
A delimiter or regional setting can affect column separation, but it does not necessarily explain a file format and extension warning.
Open Excel 2016 and go to Data > From Text/CSV. In some Excel 2016 installations, use Data > Get External Data > From Text instead.
Browse to the trusted CSV file, select it, and click Import.
In the import preview or Text Import Wizard, choose the delimiter used in the file, such as comma or semicolon. Select the correct file origin or encoding if the characters look incorrect.
Click Load or Finish, then check that the headers and values appear in the intended columns.

Check the CSV Contents and Windows Regional Settings
Use these checks when multiple CSV files show warnings or open differently across computers.
Open and Review CSV Files with WPS Spreadsheets
WPS Office is a free, lightweight alternative for working with spreadsheets. Its familiar interface and Microsoft Office format compatibility make it easy to move existing files, although it does not change Excel 2016's warning behavior.

Frequently Asked Questions
Why does Excel show a format and extension warning for a CSV file?
The file's contents may not match its .csv extension. Open a trusted file in Notepad to check whether it contains delimited text, and ask the sender for a proper CSV export if it contains another format.
Why does all my CSV data appear in one column?
Excel may be using a different list separator from the delimiter in the file. Import it through Data > From Text/CSV, or Data > Get External Data > From Text, and select the correct delimiter.
Where can I check the Windows list separator?
Open Control Panel > Region > Additional settings and look for List separator. Also check the Decimal symbol, since regional number settings can affect how data is interpreted.
Will changing a file extension to .csv fix the warning?
No. Renaming a file does not convert its contents. Open it in the application that created it and export or save it as a genuine CSV file.
What should I do if accented characters look wrong after import?
Import the file through Excel's text import options and choose the encoding used by the file, such as UTF-8, in the file origin or encoding setting.




