# How to turn a csv list into choice component options?

**URL:** <https://community.glideapps.com/t/how-to-turn-a-csv-list-into-choice-component-options/60577>\
**Category:** Ask for Help\
**Created:** [April 15, 2023, 8:00pm UTC](https://community.glideapps.com/t/how-to-turn-a-csv-list-into-choice-component-options/60577 "2023-04-15T20:00:32Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\
**Post date:** [April 15, 2023, 8:00pm UTC](https://community.glideapps.com/t/how-to-turn-a-csv-list-into-choice-component-options/60577/1 "2023-04-15T20:00:32Z")

</div>

Is there a way to turn a comma separated list of items into a set of choices for the choice component (the chips/tags)  
Typically your choices would be in separate rows within a column, my choices are in a single cell in csv format.

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [April 15, 2023, 8:20pm UTC](https://community.glideapps.com/t/how-to-turn-a-csv-list-into-choice-component-options/60577/2 "2023-04-15T20:20:53Z")

</div>

Yes you could do that with a helper table.

- create New table

- Add an Index Column where you hard code the values E.g 0,1,2,3,4,5

- Add a Single Value Column and target your comma separated list of choices

- Add a Split Text Column and target your new Single Value.

- Add another Single Value Column and target your Split Text Column where the From Start → Row is your Index Column

Just remember to start your Index Column with 0. Because the first position in an array is actually 0.

---

<div class="post-metadata">

**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\
**Post date:** [April 15, 2023, 8:22pm UTC](https://community.glideapps.com/t/how-to-turn-a-csv-list-into-choice-component-options/60577/3 "2023-04-15T20:22:46Z")

</div>

Thanks for that, i’ll try this now👍

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [April 15, 2023, 8:24pm UTC](https://community.glideapps.com/t/how-to-turn-a-csv-list-into-choice-component-options/60577/4 "2023-04-15T20:24:40Z")

</div>

Sounds good 👍

Actually reading a little closer what you wana do is in your helper table use a single value column to grab your comma separated list and then use a split text column which targets the single value. I updated the original post.

---

<div class="post-metadata">

**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\
**Post date:** [April 15, 2023, 8:47pm UTC](https://community.glideapps.com/t/how-to-turn-a-csv-list-into-choice-component-options/60577/5 "2023-04-15T20:47:26Z")

</div>

Works great, thanks for that.

---

<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:** [April 16, 2023, 8:47pm UTC](https://community.glideapps.com/t/how-to-turn-a-csv-list-into-choice-component-options/60577/6 "2023-04-16T20:47:33Z")

</div>

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