Question

Normalize JSON data to name values storred in Google Sheet

  • 10 April 2024
  • 1 reply
  • 22 views

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.


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @Mathijs123 

Give this a try: