How to convert CVS into XLS

E

elhossan

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

Pete_UK

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
 

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

Top