...
- Once you have opened your .CSV file, select the first column (A).
- Under the Data tab, click on Text to Columns.
- A Convert Text to Columns Wizard will open. Hence, you will be able to follow the steps depending the data format contained in your .CSV file. Here is an example with a delimited type of file:
- Once the wizard is finishedclosed, your file will resemble this:
- Save your file under the type .XLSX
It is possible to convert an .XLSX file to a .CSV file by following these steps:
...