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.
Best Answer
Check your system separator in Excel > File > Options > Advanced and make sure that Decimal and thousands separators are set correctly (., resp. ,).