View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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