Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a huge amount of phone numbers (for example), one for each line in .txt file.
202898990
909090090
909090900
...

I want to put each number in a a cell (phone numbers in the same column). I think I have first to convert it to .csv. But don't know how to do it.

Thanks a lot

share|improve this question

migrated from stackoverflow.com Jun 14 '12 at 18:36

This question came from our site for professional and enthusiast programmers.

4  
This is a valid single-column CSV file exactly as it is. Also, this question may be better on superuser (since it's not really a programming question, but an "how do I accomplish this task?" question, with shell programming as an assumed answer). – Charles Duffy Jun 14 '12 at 16:40
    
Just to add to Charles' comment, you can rename your file whatever.csv. The extension doesn't make it a csv file, but it will identify a properly formatted CSV file as such. – chepner Jun 14 '12 at 17:51

Since your file already is a valid CVS file, just change the file's extension to "csv" and open in your favorite spreadsheet. It should be imported the way you want.

share|improve this answer

You must log in to answer this question.