how do I change a csv extension file to an xls file and use it?
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)
debby wrote:
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?
--
Dave Peterson
|