Forum Discussion
Microsoft Excel not formatting CSV file correctly
We are trying to open a CSV file with Microsoft Excel (2013 and 2016) on Windows Desktop. Unfortunately, excel is not formatting the file correctly: each row is in a new row as it should be, but all ...
Can you provide a sample of this. You can just include a dummy information so it is easy to understand your requests.
Kind Regards,
Select the cells and click on Data, then Text to Column as shown below
Then choose Delimiter. Click on Next and select Comma on the next page, it will show you the preview of the solution.
Click on finish and you should have the data properly arranged in the columns.
Cheers
wumolad thank you so much for your reply! the issue is that we need to regularly update the ORIGINAL file, so that solution sadly does not apply in this case:/
