10 July 2007
Excel CSV Import Error
Posted by Mikhail Esteves under: Miscellaneous; Tips .
When trying to open a CSV file in Excel, you may get this error:
Excel has detected that 'test.csv' is a SYLK file, but cannot load it.
Either the file has errors or it is not a SYLK file format.
Click OK to try to open the file in a different format.
Clicking ‘OK’ opens the file anyway. This usually happens when the CSV file starts with an ID column. Excel sees the ID column in the beginning and thinks it is a SYLK file.
To solve this, either double-quote the ID column, or rename it.
csv, export, import, excel, sylk One Comment so far...
Rob Fernandes Says:
21 January 2008 at 5:41 pm.
I’ve only been wondering what the hell caused this for two years! Thank god for you and thank god for Google!