Jonathan Gennick wrote:
Did Excel provide any warning that the data was ignored? Or did Excel just silently proceed as if nothing was wrong?
Hi Jonathan, I think that your question provides an excellent example of the misunderstanding being discussed here, and I am delighted to provide an answer.
CSV file format is comma separated values. It is a very old protocol, used for transferring data between systems. It has the advantages of being very flat, meaning that the file contains very little metadata and so is small as possible; the format is well-known, so it is easy to process; and the file contains nothing but text.
In other words, it is not an Excel file. The format was designed to transfer data between systems. Just because Excel can open a CSV file and display it, that does not mean that the file is native to Excel or that Excel is the correct application to display it.
This is not a criticism of you or your knowledge. Many people lack this understanding, which is the point of Steve's post.