Need help with data importing/formatting

[Chijphilla]

I am trying to import a number of contact entries into a single, sorted format.
The contact entries are of the following format:

Name: → firstname lastname
Email: → email1
Phone: → phone1
Url: → site1

but not all contact have all these entries so for some these is no phone number and no entry for it:

Name: → firstname lastname
Email: → email1
Url: → site1

I need a proces to import these entries into a single spreadsheet while keeping the entries sorted.

[Wanderer]

@Chijphilla

need a proces to import these entries

I’d suggest to google for json2csv and adapt an available solution.

[LeroyG]

All entries are in the same column (i.e., A1:A32)?
Do all lines contain the corresponding title (Name:, Email, etc.)?