# How to get a text from a text file (TXT\\CSV) into a text column? **URL:** \ **Category:** Ask for Help\ **Created:** [September 16, 2024, 11:19am UTC](https://community.glideapps.com/t/how-to-get-a-text-from-a-text-file-txt-csv-into-a-text-column/76410 "2024-09-16T11:19:28Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![Alexey\_Baranov1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexey_baranov1/32/43581_2.png) [@Alexey\_Baranov1](https://community.glideapps.com/u/Alexey_Baranov1)\ **Post date:** [September 16, 2024, 11:19am UTC](https://community.glideapps.com/t/how-to-get-a-text-from-a-text-file-txt-csv-into-a-text-column/76410/1 "2024-09-16T11:19:28Z")
Hi gliders! I want to get a data with 100-300 of rows from CSV file downloaded in UI. One way for doing this i found there is using same scripts and Call API. But my Plan is Maker, and i can only use [Make.com](http://Make.com) to parse text and nake bulk add\update rows. The Problem is to get a text content of CSV-file. All the rest is clear. Will be glad for any ideas, thank you. ---
**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 16, 2024, 11:29am UTC](https://community.glideapps.com/t/how-to-get-a-text-from-a-text-file-txt-csv-into-a-text-column/76410/2 "2024-09-16T11:29:58Z")
You can use the following in a JavaScript column: ```auto const response = await fetch(p1); const data = await response.text(); return data; ``` `p1` should be the URL of your CSV file. ---
**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 16, 2024, 3:14pm UTC](https://community.glideapps.com/t/how-to-get-a-text-from-a-text-file-txt-csv-into-a-text-column/76410/3 "2024-09-16T15:14:08Z")
Do you have a link of that file somewhere in your app? This would probably get you the same result. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/7/b7e8bd0865cfd93ac345b11fd1f8a5e2e32e0b05.png) ---
**Author:** ![Alexey\_Baranov1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexey_baranov1/32/43581_2.png) [@Alexey\_Baranov1](https://community.glideapps.com/u/Alexey_Baranov1)\ **Post date:** [September 17, 2024, 9:47am UTC](https://community.glideapps.com/t/how-to-get-a-text-from-a-text-file-txt-csv-into-a-text-column/76410/4 "2024-09-17T09:47:56Z")
Darren, thank you, but it’s not working unfortunately ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/6/764c6601f5b13eb767e85f276c248806ad16b1dc.png) ---
**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 17, 2024, 10:02am UTC](https://community.glideapps.com/t/how-to-get-a-text-from-a-text-file-txt-csv-into-a-text-column/76410/5 "2024-09-17T10:02:09Z")
Works for me. ![CleanShot 2024-09-17 at 18.00.05@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/d/fdd12cb0e457e9248666a9d67e8e8ec60b318a43.png) Looks like your CSV is stored in Google Drive. That’s most likely why it isn’t working for you. What happens if you load the URL in a web browser? Do you get the actual CSV data, or a Google Webpage? ---
**Author:** ![Alexey\_Baranov1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexey_baranov1/32/43581_2.png) [@Alexey\_Baranov1](https://community.glideapps.com/u/Alexey_Baranov1)\ **Post date:** [September 17, 2024, 10:10am UTC](https://community.glideapps.com/t/how-to-get-a-text-from-a-text-file-txt-csv-into-a-text-column/76410/6 "2024-09-17T10:10:08Z")
@ThinhDinh thank you, it works, but there is not the text what we see when open the file with Text Editor or G-Sheets. There are many coding \ binary symbols. And i did not found there source (CSV text) unfortunately(. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/4/444f516c171905655c4143c35ab15c36ebaa1271.jpeg) Only this part of binary bla-bla looks similar to source text, but there are not sourse emails from CSV and nothing from CSV. Probably we need to add same conversion? I tryed a few, with 0 result yet. Thank you any way 🙏 ---
**Author:** ![Alexey\_Baranov1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexey_baranov1/32/43581_2.png) [@Alexey\_Baranov1](https://community.glideapps.com/u/Alexey_Baranov1)\ **Post date:** [September 17, 2024, 10:14am UTC](https://community.glideapps.com/t/how-to-get-a-text-from-a-text-file-txt-csv-into-a-text-column/76410/7 "2024-09-17T10:14:35Z")
Source CSV opened by GS ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/9/e9b6908ffeb0d1d2ae7b60402192c6c84d620f63.png) Source CSV opened by Windows Notepad ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/e/fe042e2e89d99d9867883b6474860a01c4e5d0c1.png) ---
**Author:** ![Alexey\_Baranov1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexey_baranov1/32/43581_2.png) [@Alexey\_Baranov1](https://community.glideapps.com/u/Alexey_Baranov1)\ **Post date:** [September 17, 2024, 10:18am UTC](https://community.glideapps.com/t/how-to-get-a-text-from-a-text-file-txt-csv-into-a-text-column/76410/8 "2024-09-17T10:18:10Z")
Only this part in @ThinhDinh’s suggestion case looks as some list, but too different things( from source. And it’s maybe 10% of all the Column content. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/d/ad9d97aea9e9a8d95690ee31a305f2cd5f46e63a.png) ---
**Author:** ![Alexey\_Baranov1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexey_baranov1/32/43581_2.png) [@Alexey\_Baranov1](https://community.glideapps.com/u/Alexey_Baranov1)\ **Post date:** [September 17, 2024, 10:20am UTC](https://community.glideapps.com/t/how-to-get-a-text-from-a-text-file-txt-csv-into-a-text-column/76410/9 "2024-09-17T10:20:58Z")
Yes, my CSV stored in Google Drive. Am going to try with another cloud store. ---
**Author:** ![Alexey\_Baranov1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexey_baranov1/32/43581_2.png) [@Alexey\_Baranov1](https://community.glideapps.com/u/Alexey_Baranov1)\ **Post date:** [September 17, 2024, 12:25pm UTC](https://community.glideapps.com/t/how-to-get-a-text-from-a-text-file-txt-csv-into-a-text-column/76410/10 "2024-09-17T12:25:36Z")
Hey collegues! Seems i found the issue 🙉 It should be not the same link what we take from Google Drive to share it, but another option - a link to download. In my case - the link to Open from GD looks [Import3.csv - Google Drive](https://drive.google.com/file/d/19wKe7UbLsouKDkxaPt0nFxaGbMKdW_Hg/view?usp=sharing), - the link for direct downloads looks differently [https://drive.google.com/uc?export=download&id=19wKe7UbLsouKDkxaPt0nFxaGbMKdW\_Hg](https://drive.google.com/uc?export=download&id=19wKe7UbLsouKDkxaPt0nFxaGbMKdW_Hg) Thank you very much for your support! 🙏 🙏 ---
**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 17, 2024, 2:30pm UTC](https://community.glideapps.com/t/how-to-get-a-text-from-a-text-file-txt-csv-into-a-text-column/76410/11 "2024-09-17T14:30:11Z")
Good to hear it worked eventually! ---
**Author:** ![Alexey\_Baranov1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexey_baranov1/32/43581_2.png) [@Alexey\_Baranov1](https://community.glideapps.com/u/Alexey_Baranov1)\ **Post date:** [September 18, 2024, 3:28pm UTC](https://community.glideapps.com/t/how-to-get-a-text-from-a-text-file-txt-csv-into-a-text-column/76410/12 "2024-09-18T15:28:24Z")
And seems your solutions works also for the cases when a file was downloaded into Glide cloud, not just a link in the 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:** [September 18, 2024, 11:21pm UTC](https://community.glideapps.com/t/how-to-get-a-text-from-a-text-file-txt-csv-into-a-text-column/76410/13 "2024-09-18T23:21:12Z")
What do you mean by “a file was downloaded into Glide cloud”? Do you mean files that are uploaded to Glide? As long as the link is public, it should work. ---
**Author:** ![Alexey\_Baranov1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexey_baranov1/32/43581_2.png) [@Alexey\_Baranov1](https://community.glideapps.com/u/Alexey_Baranov1)\ **Post date:** [September 19, 2024, 8:49am UTC](https://community.glideapps.com/t/how-to-get-a-text-from-a-text-file-txt-csv-into-a-text-column/76410/14 "2024-09-19T08:49:04Z")
Yes, i mean uploading a file to Glide by File Picker component, not just storing a shared link in the Column. In my case there are two different results as you can see above 🤔 ---
**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 19, 2024, 2:23pm UTC](https://community.glideapps.com/t/how-to-get-a-text-from-a-text-file-txt-csv-into-a-text-column/76410/15 "2024-09-19T14:23:16Z")
I think the file picker option should give you the right result. ---
**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 26, 2024, 2:24pm UTC](https://community.glideapps.com/t/how-to-get-a-text-from-a-text-file-txt-csv-into-a-text-column/76410/16 "2024-09-26T14:24:08Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.