Skip to main content
Question

Normalize JSON data to name values storred in Google Sheet

  • April 10, 2024
  • 1 reply
  • 30 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.

Did this topic help you find an answer to your question?
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

Troy Tessalone
Forum|alt.badge.img+14

Hi @Mathijs123 

Give this a try: