Excel interprets CSV as SYLK

Created on 19 September 2016, almost 8 years ago
Updated 17 November 2023, 7 months ago

If the header of the first column of your CSV is "ID", Excel will complain when opening the file.

The file format and extension of 'file.csv' don't match. The file could be corrupted or unsafe. Unless you trust its source, don't open it. Do you want to open it anyway?

Excel has detected that 'file.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 is document at https://support.microsoft.com/en-us/kb/323626. The solution is to wrap "ID" in quotes.

While I acknowledge that this is a ridiculous Excel issue I believe it would be quite common to have ID as the first column header and a workaround could be provided in this module.

πŸ› Bug report
Status

Closed: outdated

Version

2.0

Component

Code

Created by

πŸ‡¦πŸ‡ΊAustralia mstrelan

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.69.0 2024