Retain Excel Settings When Adding New CSV
Question: 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?"**


Answer: Try importing it as a csv file, instead of opening it directly on excel.

