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.