Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
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
add comment

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

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

1 Answer

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.