Import JSON from sheet

[qeet]

Import JSON from sheet

[qeet]

Hi,

This is not something I plan to implement I'm afraid. However you can use something like this:

https://extendsclass.com/json-storage.html

This allows you to paste your json data and then gives you a http address you can use to import the data via IMPORTJSONAPI

[qeet]

Actually I could easily implement this so the first parameter could be a json string: e.g

=IMPORTJSONAPI(A2, "$", "@")

Where cell A2 (or any other cell) contains the JSON data as a string. Would this work for you?

[oli]

@qeet That would be perfect! 😍 Thank you for considering this idea 🙇

[qeet]

OK. Will try and do this sometime this weekend.

[qeet]

@oli It is done.

[oli]

@qeet This works perfectly, even when the cell is on another sheet. Thank you so much! 🎉