CSV file detected as SYLK file in Excel
May 19 2011 · Random
Working on some CSV export code and encountered this weird error when opening the CSV file in Excel,
The file was certainly a CSV file; I had no clue what an SYLK file was.
The issue, as I discovered here, is due to the first 2 letters in the file being “ID” (which was the name of the first column); change this to something else (e.g. “Id”) and the file loads correctly without any warnings or errors.