Excel has detected that .csv is a SYLK file, but cannot load it

Ever get this error when opening a .csv file?

“Excel has detected that ‘xxx.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.”

This happens when the first 2 characters in the file are “ID” (Capital). This will actually cost Excel use that as an indicator that the file is SYLK (SYmbolic LinK). So, the solution is actually just as simple as renaming the first 2 characters other than “ID”.  Lower case “id” will works too.

5 thoughts on “Excel has detected that .csv is a SYLK file, but cannot load it”

  1. I can’t believe Microsoft would make it so easily broken… I can imagine a lot of situations where a CSV file would start with “ID”… a bit ridiculous. Thanks for the solution!

Leave a Reply

Your email address will not be published. Required fields are marked *