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

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?
 
D

Dave Peterson

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CSV Tab Delimited 4
.csv Commas ? 2
Excel file extension is camouflaged as xls 1
Excel CSV Files; Creating Of 3
CSV to ASCII 4
*.csv format change if .xlt save as .csv in Excel 2007 1
CSV file 2
creating csv file 3

Top