Forum Discussion
Microsoft Excel not presenting CSV and Excel Workbook files correctly
Hello Excel Community, I am having challenges with my Excel app. Every time I'm opening a CSV or excel workbook file the file's cell data is not being put into sperate cells it's all being put in one...
When you open a CSV file, Excel should use your system's list separator to split the lines into columns.
If you happen to use comma as decimal separator, you probably use semi-colon as list separator. In that case, Excel won't split the lines automatically.
You can still use Data > Text to Columns to do that.
HansVogelaar Thank you so much Hans, the text to column method works really well. I'm super grateful for the help, greatly appreciated