![]() |
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? |
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