how do I change a csv extension file to an xls file and use it?

  • Thread starter Thread starter debby
  • Start date Start date
D

debby

I have a file that was saved as a csv extention and want to put the
information from the comma delimited pieces into their own cells. How do I
convert from csv to xls (Excel 2007) and get the cells to be used?
 
Open excel
Open your file

The CSV data should go into separate columns.

Save the file as a normal workbook (*.xlsx) or .xls if you have to share it with
people who use xl2003 or earlier.

If the CSV data comes in and it's all in column A, then select column A
Then use Text to columns on the Data tab of the ribbon.

Delimited (by commas)
 
Back
Top