How do I change *.CSV excel file to column seperated file?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The useful data inported from remote is in excel *.csv format and to check it
I need to convert it so that it can be seperated by columns. Is there any way
to do this?
 
Change the .CSV extension to .TXT and open as a text file.

The text import wizard will pop up to help separate the data to columns.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

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 files 1
Excel CSV Files; Creating Of 3
how to save a single column as a seperate file 2
.csv Format, Hidden Columns, 2007 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
CSV->Excel Data Problem 1
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da 3
How to create .csv file 2

Back
Top