Retain Excel Settings When Adding New CSV
Try importing it as a csv file, instead of opening it directly on excel.
I've written a python/webdriver script that scrapes a table online, dumps it into a list and then exports it to a CSV.  It does this daily.
When I open the CSV in Excel, it is unformatted, and there are fifteen (comma-delimited) columns of data in each row of column A.
Of course, I then run 'Text to Columns' and get everything in order.  It looks and works great.
But tomorrow, when I run the script and open the CSV,  I've got to reformat it.
Here is my question:   "How can I open this CSV file with the data already spread across the columns in Excel?"