# How to Extract and Map JSON Data to Multiple Columns in Glide?

**URL:** <https://community.glideapps.com/t/how-to-extract-and-map-json-data-to-multiple-columns-in-glide/76078>\
**Category:** Ask for Help\
**Created:** [September 3, 2024, 2:48am UTC](https://community.glideapps.com/t/how-to-extract-and-map-json-data-to-multiple-columns-in-glide/76078 "2024-09-03T02:48:40Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![smallpond](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/smallpond/32/61256_2.png) [@smallpond](https://community.glideapps.com/u/smallpond)\
**Post date:** [September 3, 2024, 2:48am UTC](https://community.glideapps.com/t/how-to-extract-and-map-json-data-to-multiple-columns-in-glide/76078/1 "2024-09-03T02:48:40Z")

</div>

I have a JSON text generated by AI, which summarizes voice data into specific topics and calculates the time spent by each speaker as well as the total time for each topic. The JSON structure looks like this:

{  
“topics”: {  
“topic\_1”: {  
“Summary”: “Summary text for topic 1”,  
“speaker\_01”: “00:01:00”,  
“speaker\_02”: “00:01:06”,  
“total\_time”: “00:02:06”  
},  
“topic\_2”: {  
“Summary”: “Summary text for topic 2”,  
“speaker\_01”: “00:01:00”,  
“speaker\_02”: “00:01:51”,  
“total\_time”: “00:02:51”  
}  
}  
}

My goal is to extract this data and display it in separate columns within a Glide Table like this:

- `topic1_summary`
- `topic1_time_speaker1`
- `topic1_time_speaker2`
- `topic1_time_total`
- `topic2_summary`
- `topic2_time_speaker1`
- `topic2_time_speaker2`
- `topic2_time_total`

What’s the best way to achieve this in Glide? I’m currently struggling with parsing the JSON and mapping these specific values to individual columns. Is there a built-in feature, a combination of computed columns, or perhaps a plugin that could help with this?

Any advice or guidance would be greatly appreciated! Thank you in advance!

---

<div class="post-metadata">

**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:** [September 3, 2024, 3:02am UTC](https://community.glideapps.com/t/how-to-extract-and-map-json-data-to-multiple-columns-in-glide/76078/2 "2024-09-03T03:02:09Z")

</div>

Use the Query JSON column. For your use case, it’s basically no more than point and click 🙂

---

<div class="post-metadata">

**Author:** ![smallpond](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/smallpond/32/61256_2.png) [@smallpond](https://community.glideapps.com/u/smallpond)\
**Post date:** [September 3, 2024, 4:41am UTC](https://community.glideapps.com/t/how-to-extract-and-map-json-data-to-multiple-columns-in-glide/76078/3 "2024-09-03T04:41:03Z")

</div>

@Darren_Murphy It worked! Thank you for your quick response!

---

<div class="post-metadata">

**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:** [September 3, 2024, 3:06pm UTC](https://community.glideapps.com/t/how-to-extract-and-map-json-data-to-multiple-columns-in-glide/76078/4 "2024-09-03T15:06:37Z")

</div>

If you don’t mind, can you tell me how you generated a structure like that? Is that through a specific third-party service or just prompting? Thank you.

---

<div class="post-metadata">

**Author:** ![smallpond](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/smallpond/32/61256_2.png) [@smallpond](https://community.glideapps.com/u/smallpond)\
**Post date:** [September 3, 2024, 10:36pm UTC](https://community.glideapps.com/t/how-to-extract-and-map-json-data-to-multiple-columns-in-glide/76078/5 "2024-09-03T22:36:08Z")

</div>

@ThinhDinh It’s generated through just prompting.

---

<div class="post-metadata">

**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:** [September 4, 2024, 12:19am UTC](https://community.glideapps.com/t/how-to-extract-and-map-json-data-to-multiple-columns-in-glide/76078/6 "2024-09-04T00:19:12Z")

</div>

That’s awesome. Thank you. I was wondering how you can get exact timestamps for each one.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [September 11, 2024, 12:19am UTC](https://community.glideapps.com/t/how-to-extract-and-map-json-data-to-multiple-columns-in-glide/76078/7 "2024-09-11T00:19:13Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.