ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I change a csv extension file to an xls file and use it? (https://www.excelbanter.com/excel-discussion-misc-queries/255558-how-do-i-change-csv-extension-file-xls-file-use.html)

Debby

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

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


All times are GMT +1. The time now is 10:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com