<aside> <img src="/icons/book_red.svg" alt="/icons/book_red.svg" width="40px" /> Formatting JSON in Rows can be tricky so I've created the below guide to share the JSON objects that I often create and the formulas that I use to create them. I’ve kept the examples as simple as possible, to make them easy to interpret.
If there's anything else that you think I should add, please let me know!
</aside>
Quick Links
Rows - The spreadsheet with superpowers
Create a key value pair
https://rows.com/embed/1R0r2NCCSw4p31CnbtHsR4IkxfN4cmDROm8E5wgqTLo3/a6014e68-86a8-4a0c-a9d3-1a8989126c34?RW=hide
<aside>
<img src="/icons/code_red.svg" alt="/icons/code_red.svg" width="40px" /> =PAIR2JSON(A2,B2)
</aside>
Create an array of objects from a range
https://rows.com/embed/1R0r2NCCSw4p31CnbtHsR4IkxfN4cmDROm8E5wgqTLo3/4c02dd83-a44e-4eba-bef2-50b0727fb8a5?RW=hide
<aside>
<img src="/icons/code_red.svg" alt="/icons/code_red.svg" width="40px" /> =RANGE2JSON(A2:A4,B2:B4)
</aside>
Extract content from an object, navigating with JSONPath
https://rows.com/embed/1R0r2NCCSw4p31CnbtHsR4IkxfN4cmDROm8E5wgqTLo3/d82185ee-9516-4ff5-ae6e-98dc4a7181e2?RW=hide
<aside>
<img src="/icons/code_red.svg" alt="/icons/code_red.svg" width="40px" /> =PARSE(A2,"[0].['Email']")
</aside>
Get JSON data as text
https://rows.com/embed/1R0r2NCCSw4p31CnbtHsR4IkxfN4cmDROm8E5wgqTLo3/57af0760-4337-4c2d-b42a-dd78d9bffd16?RW=hide
<aside>
<img src="/icons/code_red.svg" alt="/icons/code_red.svg" width="40px" /> =TO_TEXT(A2)
</aside>
View JSON data in columns and rows
https://rows.com/embed/1R0r2NCCSw4p31CnbtHsR4IkxfN4cmDROm8E5wgqTLo3/3897df2b-ebda-4557-9fdc-bfd9518ebf74?RW=hide