Convert a Google Sheets range to JSON with TABLE_TO_JSON

Learn about the TABLE_TO_JSON function by the spread_cheats community.

Convert a data range to a JSON object with multiple items as an array. This function allows for indexing into the item array on one-to-many keys.

Links:

+--------------------------------------------------------------+

❓Learn how to install a cheat yourself

+--------------------------------------------------------------+
spread_cheats:

╱╱╱╭╮╱╱╱╱╱╱╱╭╮
╱╱╱┃┃╱╱╱╱╱╱╭╯╰╮
╭━━┫╰━┳━━┳━┻╮╭╯
┃╭━┫╭╮┃┃━┫╭╮┃┃
┃╰━┫┃┃┃┃━┫╭╮┃╰╮
╰━━┻╯╰┻━━┻╯╰┻━╯