search

jazzido / mondrian-rest

A REST interface for Mondrian ROLAP server
MIT License
32 stars 8 forks source link

SYLK file format warning when opening in excel #11

Open jspeis opened 7 years ago

jspeis commented 7 years ago

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/