how to insert the following dataset in to a calc-table
with comma-sepeated data-formate - or how would you do this task
note: i have somewhat 1800 or 2000 lines of this:
- Code: Select all
{'url': 'http://myurl', 'a_name': 'Mister Spock', 'name': 'Henry Spock', 'email': 'spaceship-enterprise@austin-texas.com'}
{'url': 'http://yoururl', 'a_name': 'Dil Bert', 'name': 'Dil Bert', 'email': 'DilBert@aol.com'}
{'url': 'http://hisurl', 'a_name': 'Ted Bear', 'name': 'Teddy Bear', 'email': 'Teddy-Bear@zoo.com'}