mondrian-rest icon indicating copy to clipboard operation
mondrian-rest copied to clipboard

Published 20 hours ago • verified publisher icon jazzido

SYLK file format warning when opening in excel

Open jspeis opened this issue 7 years ago • 0 comments

Oh Microsoft.

Yep. If the first record of your CSV file is “ID”, Excel will attempt to intepret the file as SYLK. Changing “ID” to anything else (including “Id” or “id”) fixes the issue.

https://annalear.ca/2010/06/10/why-excel-thinks-your-csv-is-a-sylk/

jspeis avatar Jun 15 '17 14:06 jspeis