# Generate CSV containing Lookup columns

**URL:** <https://community.glideapps.com/t/generate-csv-containing-lookup-columns/70821>\
**Category:** Ask for Help\
**Created:** [February 14, 2024, 1:33pm UTC](https://community.glideapps.com/t/generate-csv-containing-lookup-columns/70821 "2024-02-14T13:33:05Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![ra1ns](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ra1ns/32/49086_2.png) [@ra1ns](https://community.glideapps.com/u/ra1ns)\
**Post date:** [February 14, 2024, 1:33pm UTC](https://community.glideapps.com/t/generate-csv-containing-lookup-columns/70821/1 "2024-02-14T13:33:06Z")

</div>

I have a question about the Generate CSV action.  
In this action, the Computed Column (e.g. Lookup column with a single value Lookup from Relation) is not output to CSV.  
Is there a way to include the Lookup column in the output CSV?

---

<div class="post-metadata">

**Author:** ![Lucas\_Malguy1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_malguy1/32/54607_2.png) [@Lucas\_Malguy1](https://community.glideapps.com/u/Lucas_Malguy1)\
**Post date:** [February 14, 2024, 2:02pm UTC](https://community.glideapps.com/t/generate-csv-containing-lookup-columns/70821/2 "2024-02-14T14:02:53Z")

</div>

Hi,

Computed columns are not included in the CSV. Not sure if it’s the case for all of the computed columns type though.

---

<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:** [February 14, 2024, 3:01pm UTC](https://community.glideapps.com/t/generate-csv-containing-lookup-columns/70821/3 "2024-02-14T15:01:15Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/7/07ba25894f03dc3a8140422ed3a3263320c0b215.png)

Have you tried using “Select columns” here? I just tested and my lookup column does show in the list and I can include it with a check.

---

<div class="post-metadata">

**Author:** ![Lucas\_Malguy1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_malguy1/32/54607_2.png) [@Lucas\_Malguy1](https://community.glideapps.com/u/Lucas_Malguy1)\
**Post date:** [February 14, 2024, 4:10pm UTC](https://community.glideapps.com/t/generate-csv-containing-lookup-columns/70821/4 "2024-02-14T16:10:58Z")

</div>

EDIT: Just tried again @ThinhDinh and you were right I have the computed values in the CSV, always thought it was not included 🫠

On my side yes it appears on the list but the data from computed columns are not exported in the CSV so I always assumed it was normal behavior?

---

<div class="post-metadata">

**Author:** ![ra1ns](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ra1ns/32/49086_2.png) [@ra1ns](https://community.glideapps.com/u/ra1ns)\
**Post date:** [February 14, 2024, 4:28pm UTC](https://community.glideapps.com/t/generate-csv-containing-lookup-columns/70821/5 "2024-02-14T16:28:47Z")

</div>

Wow!  
I never realized there was a “Select Columns” option!  
Thanks to your guys’ advice, I was able to solve this problem perfectly.  
Thanks so much @ThinhDinh and @Lucas_Malguy1 for the advice!

---

<div class="post-metadata">

**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\
**Post date:** [February 14, 2024, 5:56pm UTC](https://community.glideapps.com/t/generate-csv-containing-lookup-columns/70821/6 "2024-02-14T17:56:11Z")

</div>

Hi, ThinhDinh! How you have configured your lookups. I tried and no luck.

---

<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:** [February 14, 2024, 11:52pm UTC](https://community.glideapps.com/t/generate-csv-containing-lookup-columns/70821/7 "2024-02-14T23:52:58Z")

</div>

It’s a simple single relation + lookup. Nothing special there. Do you not see those columns in the “select columns” screen?

---

<div class="post-metadata">

**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\
**Post date:** [February 15, 2024, 8:18am UTC](https://community.glideapps.com/t/generate-csv-containing-lookup-columns/70821/8 "2024-02-15T08:18:31Z")

</div>

Ah, yes, bit confusing. Just i was thinking about Lookup as an array that’s why was curious to know it possible to use in csv source. As single value it is clear. Thanks!

---

<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:** [February 22, 2024, 8:18am UTC](https://community.glideapps.com/t/generate-csv-containing-lookup-columns/70821/9 "2024-02-22T08:18:38Z")

</div>

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