csv file had 6 columns, now data is in 1 column separated by comma

I have a spreadsheet that was created with 6 columns, and now after being saved as a csv file, all the data is in 1 column separated by commas. Is there an easy way to convert back to 6 columns?

Thanks

Select (highlight) the column, then select Data, Text to Columns, and select the options Delimited, and the delimiter to Comma.

hth

Originally Posted by JBasch

I have a spreadsheet that was created with 6 columns, and now after being saved as a csv file, all the data is in 1 column separated by commas. Is there an easy way to convert back to 6 columns?

Thanks