How do I put the text in separate columns in the CSV file in Excel?

In order to properly view the data in the CSV file in Excel, you will first have to make sure that the values are divided into separate columns. You can do this as follows:

1. Select the first column (column A)

2. Click on 'Data' and then on 'Text to Columns'

3. The option 'Delimited' has been preselected. This is the correct option. Click on 'Next'.

4. Select the option 'Comma' and click on 'Finish'.


Read also: 

Can't find what you're looking for?

Please contact our support, for help.