ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to convert CVS into XLS (https://www.excelbanter.com/excel-worksheet-functions/167328-how-convert-cvs-into-xls.html)

elhossan

How to convert CVS into XLS
 
i have a excel file in CVS format how i can convert it into XLS and put every
value in seperate cell.

Pete_UK

How to convert CVS into XLS
 
Rename the file so that it has an extension of .txt, then with Excel
running use File | Open and browse to the folder and point to the .txt
file (you will have to change the File Type box to All files *.*).

Excel will automatically start the Data Import Wizard, in which you
have a lot of control over how the imported data is to be treated.

Alternatively, import the file into one column (presumably that is
what you are doing now) and use Data | Text-to-Columns to split the
data up.

Hope this helps.

Pete

On Nov 26, 8:53 am, elhossan
wrote:
i have a excel file in CVS format how i can convert it into XLS and put every
value in seperate cell.




All times are GMT +1. The time now is 01:42 PM.

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