10

Let's say I have a txt file like this:

Mario
mario@me.com
+399038259953
Luigi
luigi@live.com
+395902385093
Yoshi
yoshi@yahoo.com
+81293565291

[and so on for 300 lines...]

How do I make a .ods (or .xls, or .csv, it does not matter) file which has three rows (name, email, phone number)? I need it so I can easily convert it in a .vcf file and bulk save these numbers in my phone.

Thanks

19

Use paste to make a csv:

 paste -d,  - - - < file

Output:

Mario,mario@me.com,+399038259953
Luigi,luigi@live.com,+395902385093
Yoshi,yoshi@yahoo.com,+81293565291
4
  • 5
    ... or ... pr -3tas, < file ... – bac0n Jan 23 at 20:24
  • Thanks man! You saved my day! – Dario Costa Jan 23 at 21:22
  • 2
    @bac0n Separate answer, so it can be voted on? – wizzwizz4 Jan 24 at 14:22
  • ... There is a third, I just can't find it... – bac0n Jan 25 at 14:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.