Excel has detected that filename.csv is SYLK file, but cannot load it

• by Samuele Resca

When I try to open a CSV file that starts with word “ID”, Microsoft Excel returns a message error:

“Excel has detected that filename.csv is 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.”

(CSV content)

ID, DESCRIPTION
123, Hank Moody
234, Jhon Dorian
345, Vincent Vega
456, Mia Wallace

 

To solve this error, you need to change the two initial characters, for example:

sep=,
ID, DESCRIPTION
123, Hank Moody
234, Jhon Dorian
345, Vincent Vega
456, Mia Wallace

Or..

CODE, DESCRIPTION
123, Hank Moody
234, Jhon Dorian
345, Vincent Vega
456, Mia Wallace

Microsoft ref: http://support2.microsoft.com/kb/323626

>ID, DESCRIPTION
123, Hank Moody
234, Jhon Dorian
345, Vincent Vega
456, Mia Wallace
 

To solve this error, you need to change the two initial characters, for example:

sep=,
ID, DESCRIPTION
123, Hank Moody
234, Jhon Dorian
345, Vincent Vega
456, Mia Wallace

Or..

CODE, DESCRIPTION
123, Hank Moody
234, Jhon Dorian
345, Vincent Vega>ID, DESCRIPTION
123, Hank Moody
234, Jhon Dorian
345, Vincent Vega
456, Mia Wallace

 

To solve this error, you need to change the two initial characters, for example:

sep=,
ID, DESCRIPTION
123, Hank Moody
234, Jhon Dorian
345, Vincent Vega
456, Mia Wallace

Or..

CODE, DESCRIPTION
123, Hank Moody
234, Jhon Dorian

sep=,
ID, DESCRIPTION
123, Hank Moody
234, Jhon Dorian
345, Vincent Vega
456, Mia Wallace


Or..


CODE, DESCRIPTION
123, Hank Moody
234, Jhon Dorian
sep=,
ID, DESCRIPTION
123, Hank Moody
234, Jhon Dorian
345, Vincent Vega
456, Mia Wallace


Or..


CODE, DESCRIPTION
123, Hank Moody
234, Jhon Dorian
sep=,
ID, DESCRIPTION
123, Hank Moody
234, Jhon Dorian
345, Vincent Vega
456, Mia Wallace


Or..


CODE, DESCRIPTION

123, Hank Moody

234, Jhon Dorian

345, Vincent Vega