<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

Examples Spreadsheet

Rows - The spreadsheet with superpowers

Standard Functions

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>

Untitled

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>

Untitled

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>

Untitled

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>

Untitled

View JSON data in columns and rows

https://rows.com/embed/1R0r2NCCSw4p31CnbtHsR4IkxfN4cmDROm8E5wgqTLo3/3897df2b-ebda-4557-9fdc-bfd9518ebf74?RW=hide