You cannot override this automatic filtering when opening the file. This makes sense after all, the file is supposed to contain comma-separated values (CSV). When you open a CSV file in Excel (either by double-clicking in Windows or by using File | Open in Excel), the program treats any commas in the file as delimiters. To understand that, it is critical to understand how Excel opens CSV files. The reason for this behavior is probably quite simple and has to do with the format in which the data is stored in the CSV file by the non-Excel program. Instead of the comma-separated values being in different columns, every record appears in a single column. The problem is that the file, when opened, isn't parsed by Excel. When Jan double-clicks the CSV file in Windows, Excel starts and then loads the file. This file can then be opened in Excel for further analysis.
0 Comments
Leave a Reply. |