I have storred JSON objects in a Google sheet which i want to transform into Key and Values.
The data in the cell looks like this:
[{"ruimteInHuis_J":"Woonkamer voorraam","montageKeuze":"In de dag","breedte_J":2392,"hoogte_J":1630,"bedieningOptieTuimelen_J":"Rechts","bedieningOptieOptrekken_J":"Rechts","zijgeleidingNodig_J":"Nee","uitlijnen_J":null,"photo_J":"gridfs://registrationFiles/536b9a35-ac98-4663-84b0-699e60348b5f","notitie_J":""},
{"ruimteInHuis_J":"Woonkamer voor raam links ","montageKeuze":"In de dag","breedte_J":862,"hoogte_J":1630,"bedieningOptieTuimelen_J":"Links","bedieningOptieOptrekken_J":"Links","zijgeleidingNodig_J":"Nee","uitlijnen_J":"Ja","photo_J":"gridfs://registrationFiles/5aaadba7-b3d6-4457-ab06-e9e408735886","notitie_J":""},
{"ruimteInHuis_J":"Slaapkamer roze (dochter)","montageKeuze":"In de dag","breedte_J":960,"hoogte_J":1619,"bedieningOptieTuimelen_J":"Rechts","bedieningOptieOptrekken_J":"Rechts","zijgeleidingNodig_J":"Nee","uitlijnen_J":"Ja","photo_J":"gridfs://registrationFiles/b32ab512-e862-4786-8f68-7da2d968775e","notitie_J":""},
{"ruimteInHuis_J":"Slaapkamer roze deur ","montageKeuze":"In de dag","breedte_J":830,"hoogte_J":2232,"bedieningOptieTuimelen_J":"Links","bedieningOptieOptrekken_J":"Links","zijgeleidingNodig_J":"Nee","uitlijnen_J":"Ja","photo_J":"gridfs://registrationFiles/5375308c-bbb3-4a58-9ff1-6f149e2c08fe","notitie_J":""},
{"ruimteInHuis_J":"Slaapkamer groen (zoon)","montageKeuze":"In de dag","breedte_J":1787,"hoogte_J":1619,"bedieningOptieTuimelen_J":"Rechts","bedieningOptieOptrekken_J":"Rechts","zijgeleidingNodig_J":"Nee","uitlijnen_J":"Niet van toepassing","photo_J":"gridfs://registrationFiles/371bf8fd-ce67-42f5-8c18-ee69abf0b992","notitie_J":""},{"ruimteInHuis_J":"Keuken","montageKeuze":"In de dag","breedte_J":1610,"hoogte_J":1405,"bedieningOptieTuimelen_J":"Rechts","bedieningOptieOptrekken_J":"Rechts","zijgeleidingNodig_J":"Nee","uitlijnen_J":"Niet van toepassing","photo_J":"gridfs://registrationFiles/e7d2270d-3911-49e7-8313-7902e47cf160","notitie_J":""},{"ruimteInHuis_J":"Slaapkamer voor ","montageKeuze":"In de dag","breedte_J":655,"hoogte_J":1389,"bedieningOptieTuimelen_J":"Rechts","bedieningOptieOptrekken_J":"Rechts","zijgeleidingNodig_J":null,"uitlijnen_J":null,"photo_J":"gridfs://registrationFiles/a9fe90d8-42b9-40d2-b28e-77728c3d486f","notitie_J":""},
{"ruimteInHuis_J":"Slaapkamer voor links ","montageKeuze":"In de dag","breedte_J":1840,"hoogte_J":1389,"bedieningOptieTuimelen_J":"Links","bedieningOptieOptrekken_J":"Links","zijgeleidingNodig_J":"Nee","uitlijnen_J":"Ja","photo_J":"gridfs://registrationFiles/1b02c78b-8589-4d4b-b9bf-899bce9ee477","notitie_J":""}]
I have tried to use the formater and use JSON utility which was sugested but could not get it to work for me.
