Excel Error when opening CSV File: File was detected as SYLK File!
Question by Guest | Last update on 2023-03-23 | Created on 2013-02-19
When opening a normal CSV-File with Microsoft Excel, a strange problem occurs.
First, I get the following error message:
The file you are trying to open is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now? Yes | No | Help
After clicking on "Yes", the next error occurs:
Cannot read record 1. Continue reporting each error? Yes | No | Cancel
I click on "Yes" again, and I get the third error message:
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. OK | Cancel
Only after clicking "OK" in this third error message, my file is opened and ironically, it is displayed correctly.
As far as I can judge, there are no other problems with the file. Additionally, OpenOffice can display the contents properly. So what is it?
Unfortunately, I have to pass this CSV spreadsheet on to a customer and I would not like that every time he gets this error messages. Can someone help me with that issue?
Related Topics
XLS and XLSX: Maximum Number of Columns and Rows
Info | 2 Comments
Convert many CSV Files to XLSX or ODS Spreadsheets
Tutorial | 0 Comments
Lazarus: Program without GUI - Many WSRegister Errors
Question | 6 Answers
MySQL: CSV Export as File stored on the Server
Tutorial | 0 Comments
MySQL: CSV Export as automatic Download
Tutorial | 0 Comments
Delphi: Global Treatment of Errors (Exceptions)
Tutorial | 0 Comments
Create Custom Error Pages for Website
Tip | 0 Comments
Important Note
Please note: The contributions published on askingbox.com are contributions of users and should not substitute professional advice. They are not verified by independents and do not necessarily reflect the opinion of askingbox.com. Learn more.
Participate
Ask your own question or write your own article on askingbox.com. That’s how it’s done.
This error occurs, whenever the first two characters of a CSV file are "ID".
To prevent this error, you have to ensure that your CSV file is not starting with the string "ID". For example, writing "ID" in lowercase letters "id" is a workaround. Alternatively, you can put an apostrophe ' in front of the "ID".
Last update on 2023-03-23 | Created on 2013-02-22