Convert a .txt file in a .csv with a row every 3 lines

Question

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

Mario
[email protected]
+399038259953
Luigi
[email protected]
+395902385093
Yoshi
[email protected]
+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

score 20 · Accepted Answer · answered Jan 23 '21 at 19:06

20

Use paste to make a csv:

 paste -d,  - - - < file

Output:

Mario,[email protected],+399038259953
Luigi,[email protected],+395902385093
Yoshi,[email protected],+81293565291

answered Jan 23 '21 at 19:06

pLumo

26,204
2
57
87

5

... or ... `pr -3tas, < file` ... – Jan 23 '21 at 20:24
Thanks man! You saved my day! – Dario Costa Jan 23 '21 at 21:22
2

@bac0n Separate answer, so it can be voted on? – wizzwizz4 Jan 24 '21 at 14:22
... There is a third, I just can't find it... – Jan 25 '21 at 14:04

Convert a .txt file in a .csv with a row every 3 lines

1 Answers1