Starting with a CSV file, like the following one, open it in Excel : each row is in one single cell, while you might want them to be separated.
CSV Comma Separated Values file
Select your column
Select CSV data column
Then click on the Data>Text to Columns option
Excel Data > Text to Columns option
In the Convert Text to Column Wizard, step 1, leave the default option, Delimitedfile type
Step 1 select Delimited file type
In the Convert Text to Column Wizard, step 2, select Commaas a Delimiters(or another one if necessary, like semicolon ; or pipe |)
Step 2 select comma separator
In the Convert Text to Column Wizard, step 3, you might want to change all the non numerical columns formatting to Text, this to avoiding loosing leading zeros for example
Step 3 change column format to text
Simply click on the first column, then while holding Shift butting, click on the last one or your selection – you can also add columns to the selection by holding Ctrl and clicking on the column – then select Column data format as Text.
Step 3 select multiple columns
Before hitting the Finish button, in case you get the error message “There’s already data here. Do you want to replace it ?“, or to avoid getting it
There’s already data here. Do you want to replace it ?
Select another Destinationcell, and click on an empty cell in the same sheet.
Select an empty cell
You can then click Finish– and voilà ! Your CSV values have been pasted properly in Excel cells
Result after formatting CSV file into Excel spreadsheet cells
