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

If you close the file and reopen in Excel it should sort it out for you but if not use the Text to Columns option on the data menu

R