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



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

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 format change if .xlt save as .csv in Excel 2007 1
CSV file 2
creating csv file 3