When I open a CSV files in Excel 2019 the file is not being parsed correctly. When I opened the same files in Excel 2016 they would be parsed correctly, with the commas used as delimiters. But I have just installed Excel 2019 and it is opening files without recognizing that they are CSV.

I am not trying to import data from a CSV file I opening it directly. This always worked just fine. And I thought that 2019 would be better with CSVs.

Here's an example file samplecsvs.s3.amazonaws.com/Sacramentorealestatetransactions.csv

How can I tell excel that a CSV file is a CSV file?!?! Is there an option somewhere? I don't want to use the "import data" option, it should work automatically.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.