# Convert Data from Glidetable into JSON Type **URL:** \ **Category:** Ask for Help\ **Created:** [November 15, 2022, 8:58am UTC](https://community.glideapps.com/t/convert-data-from-glidetable-into-json-type/54190 "2022-11-15T08:58:34Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\ **Post date:** [November 15, 2022, 8:58am UTC](https://community.glideapps.com/t/convert-data-from-glidetable-into-json-type/54190/1 "2022-11-15T08:58:34Z")
Hi Community Is there a video or guide how to convert a set of data into JSON type? Currently I have create a column array Invoice Details ![steps](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/c/ec98d175005df5710c3701a9e6320b1518ab3e15.jpeg) Convert into a List ![2 Joined List](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/3/535e2dafb29d202c9112f39204e46df36c138577.jpeg) Then Transform into JSON ![3 Transform to JSON](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/e/1e3e4a9c938ac3c31f5c76a312d4e46a09652378.png) Kindly advise if this is the correct way? Any better method? Any advise is deeply appreciated. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [November 16, 2022, 7:49am UTC](https://community.glideapps.com/t/convert-data-from-glidetable-into-json-type/54190/2 "2022-11-16T07:49:24Z")
I saw this yesterday and forgot to respond. Your approach is all wrong. The Transform JSON plugin is used to _extract_ data from a JSON data structure, not to create one. Creating a JSON object inside Glide can be as simple as a single template column. Below is a short tutorial I made a while back: ---
**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\ **Post date:** [November 16, 2022, 8:32am UTC](https://community.glideapps.com/t/convert-data-from-glidetable-into-json-type/54190/3 "2022-11-16T08:32:14Z")
Awesome… Let me check ---
**Author:** ![Werther](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/werther/32/60106_2.png) [@Werther](https://community.glideapps.com/u/Werther)\ **Post date:** [August 17, 2023, 1:32pm UTC](https://community.glideapps.com/t/convert-data-from-glidetable-into-json-type/54190/4 "2023-08-17T13:32:26Z")
Hey, Darren. Thanks for the tutorial, it may help big time. Nevertheless, one question: we have a column called “Make JSON Object”, couldn’t it work too, in an easier way? I’m having some trouble setting this column up, and I can’t find any documentation on it. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/8/98d4b8b116344514cf091888794f8a3bce55df15.png) Thanks again. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 17, 2023, 1:40pm UTC](https://community.glideapps.com/t/convert-data-from-glidetable-into-json-type/54190/5 "2023-08-17T13:40:05Z")
yeah, for sure. Definitely use the Make JSON Object column. It’s much easier, and it also guarantees that you’ll get valid JSON - which may not always be true if you use a template column. The way it works is you have to define a series of keys and values in pairs. So the first pair are `k1` & `v1`, then `k2` & `v2`, and so on. If we use the Users table as an example, and lets say we want to create an object that contains the Users Name and Email, you’d set it up as follows: - k1: name - v1: replace with the Name column - k2: email - v2: replace with the Email column Like so: ![CleanShot 2023-08-17 at 21.40.54@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/f/6ffb7fcfd9243efa164f7f2308606d7cf6f678a9.png) Note: there is an even newer column (that can be enabled in Previews) that does the same thing and allows you to add an unlimited number of key/value pairs: ![CleanShot 2023-08-17 at 21.39.13@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/3/63166cbddd090367f8be64594763f46e298c6e67.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 18, 2023, 12:50am UTC](https://community.glideapps.com/t/convert-data-from-glidetable-into-json-type/54190/6 "2023-08-18T00:50:09Z")
JSON Object and JSONata are my favorite thing nowadays. ---
**Author:** ![Werther](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/werther/32/60106_2.png) [@Werther](https://community.glideapps.com/u/Werther)\ **Post date:** [August 29, 2023, 6:27pm UTC](https://community.glideapps.com/t/convert-data-from-glidetable-into-json-type/54190/7 "2023-08-29T18:27:48Z")
Wow, perfect! I was about to ditch the JSON column and use a template, since the first is limited to 12 values only. But then you gifted me with this newer column, thanks!! This should be it, I’ll use the “JSON Object” column. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 30, 2023, 1:03am UTC](https://community.glideapps.com/t/convert-data-from-glidetable-into-json-type/54190/8 "2023-08-30T01:03:35Z")
And you’ll enjoy it a hell lot. It’s much easier to work with that column, in my honest opinion.