Print this page

SYLK: File format is not valid

Knowledge Article Number 000194165
Description When you try to open a text file or a comma-separated variable (CSV) file, you may receive the following error message:

                                                             "SYLK: File format is not valid"


This problem occurs when you open a text file or CSV file and the first two characters of the file are the uppercase letters "I" and "D". For example, the text file may contain the following text:


ID, STATUS

123, open
456, closed


This problem does not occur if the first two letters are lower case "i" and "d".
Resolution
As there is no permanent solution, below you can find a usable workaround:

To open your file in Excel, open the file in a text editor, and then insert an apostrophe at the beginning of the first line of text.
       

         To add an apostrophe to the beginning of the first line of text in your file, follow these steps:


             1.     Open the text file in a text editor, such as Notepad.

             2.     Click before the first character in the first line of text.

             3.     Press the APOSTROPHE key on your keyboard (').

             4.     Click on the File menu, then click Save. Quit the text editor.

             5.     You can now open the file in Excel.


Microsoft has confirmed that this is a problem in the Microsoft products. This affects Microsoft Office 2003 and 2013. To find more information regarding this issue, please follow the link below:

                                                            http://support.microsoft.com/kb/323626/en-us




promote demote