# Put the text from a .txt file into a column

**URL:** <https://connect.superhuman.com/t/put-the-text-from-a-txt-file-into-a-column/39261>\
**Category:** Ask the Community\
**Created:** [April 19, 2023, 4:46pm UTC](https://connect.superhuman.com/t/put-the-text-from-a-txt-file-into-a-column/39261 "2023-04-19T16:46:36Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![David\_Knell](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/david_knell/32/20502_2.png) [@David\_Knell](https://connect.superhuman.com/u/David_Knell)\
**Post date:** [April 19, 2023, 4:46pm UTC](https://connect.superhuman.com/t/put-the-text-from-a-txt-file-into-a-column/39261/1 "2023-04-19T16:46:36Z")

</div>

The Google Drive Pack allows me to have a table of all files in a given folder. That’s great! What I would LOVE is this: If the file is a .txt file, put the text of that file into a Text column. Does anyone have any ideas on how to do that?

My use case: I have lots of voice memos and AI-generated transcripts, which I save as .txt files in Google Drive. I would love to use generative-AI (eg, ChatGPT) to summarize the text, suggest a title for the file, list action items, etc.

---

<div class="post-metadata">

**Author:** ![Rickard\_Abraham](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/rickard_abraham/32/35007_2.png) [@Rickard\_Abraham](https://connect.superhuman.com/u/Rickard_Abraham)\
**Post date:** [April 20, 2023, 2:46pm UTC](https://connect.superhuman.com/t/put-the-text-from-a-txt-file-into-a-column/39261/2 "2023-04-20T14:46:08Z")

</div>

I did a quick experiment a few weeks ago, cleaned it up a little and published it for you!

https://coda.io/embed/MVRa7tcuGD/_suiRH?viewMode=embedplay&hideSections=true#Experiments_tuCRS/r53&view=full

> **[File Reader Pack, extend Coda with File Reader | Coda](https://coda.io/packs/file-reader-21274)**
>
> Read a file!
> 
> https://...

---

<div class="post-metadata">

**Author:** ![Samuel\_Langford](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/samuel_langford/32/47844_2.png) [@Samuel\_Langford](https://connect.superhuman.com/u/Samuel_Langford)\
**Post date:** [April 20, 2023, 3:43pm UTC](https://connect.superhuman.com/t/put-the-text-from-a-txt-file-into-a-column/39261/3 "2023-04-20T15:43:22Z")

</div>

This is great, does it only work for txt files?

---

<div class="post-metadata">

**Author:** ![Rickard\_Abraham](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/rickard_abraham/32/35007_2.png) [@Rickard\_Abraham](https://connect.superhuman.com/u/Rickard_Abraham)\
**Post date:** [April 20, 2023, 3:50pm UTC](https://connect.superhuman.com/t/put-the-text-from-a-txt-file-into-a-column/39261/4 "2023-04-20T15:50:36Z")

</div>

Should work for most files! 🙂

---

<div class="post-metadata">

**Author:** ![David\_Knell](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/david_knell/32/20502_2.png) [@David\_Knell](https://connect.superhuman.com/u/David_Knell)\
**Post date:** [April 21, 2023, 2:37pm UTC](https://connect.superhuman.com/t/put-the-text-from-a-txt-file-into-a-column/39261/5 "2023-04-21T14:37:00Z")

</div>

Rickard, you wonderful human, thank you!!! I didn’t realize there was a Pack already. Thank you for making it and telling me about it!

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [April 24, 2023, 2:37pm UTC](https://connect.superhuman.com/t/put-the-text-from-a-txt-file-into-a-column/39261/6 "2023-04-24T14:37:19Z")

</div>

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