Convert JSON to .CSV

With the JSON text in cell A1, you could use this to split it into readable elements:

Formula:

=TEXTSPLIT(A1,,":")

From there, I suspect you could use WRAPROWS and/or WRAPCOLS to create "records" and then FILTER or CHOOSEROWS to get the records you want.

Just thinking out loud