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:
⇒ view tutorial: https://sheets.guide/table_to_json
⇒ copy tutorial: https://sheets.guide/table_to_json/copy
⇒ code: https://sheets.guide/table_to_json/code
⇒ spread_cheats post: https://sheets.guide/table_to_json/post
+--------------------------------------------------------------+
❓Learn how to install a cheat yourself
⇒ https://www.spreadcheats.com/how-to-a...
+--------------------------------------------------------------+
spread_cheats:
find us at https://www.spreadcheats.com
join the community at https://bit.ly/spread_cheats
follow us / spread_cheats
╱╱╱╭╮╱╱╱╱╱╱╱╭╮
╱╱╱┃┃╱╱╱╱╱╱╭╯╰╮
╭━━┫╰━┳━━┳━┻╮╭╯
┃╭━┫╭╮┃┃━┫╭╮┃┃
┃╰━┫┃┃┃┃━┫╭╮┃╰╮
╰━━┻╯╰┻━━┻╯╰┻━╯