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 to parse text and nake bulk add\update rows. The Problem is to get a text content of CS…

You can use the following in a JavaScript column: const response = await fetch(p1); const data = await response.text(); return data; p1 should be the URL of your CSV file.

Do you have a link of that file somewhere in your app? This would probably get you the same result. [image]

Darren, thank you, but it’s not working unfortunately [image]

Works for me. [CleanShot 2024-09-17 at 18.00.05@2x] 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?

@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] Only this part of binary bla-bla looks similar to source text, but the…

Source CSV opened by GS [image] Source CSV opened by Windows Notepad [image]

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]

Yes, my CSV stored in Google Drive. Am going to try with another cloud store.

Hey collegues! Seems i found the issue :hear_no_evil: 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 , the link for direct downloads looks differently https:/…

Good to hear it worked eventually!

And seems your solutions works also for the cases when a file was downloaded into Glide cloud, not just a link in the column?

How to get a text from a text file (TXT\CSV) into a text column?

Ask for Help

Alexey_Baranov1 September 17, 2024, 9:47am 4

Darren, thank you, but it’s not working unfortunately

Topic		Replies	Views
Extract CSV rows from a user uploaded file Ask for Help	7	285	October 4, 2024
Generate CSV treating text column as number Ask for Help	6	29	April 30, 2026
Using email trigger to receive a csv file and parse it Ask for Help	11	99	September 10, 2025
Export Glide Table/ Google Sheet Data to CSV using Joined List & Apps Script Project Showcase	12	4034	February 1, 2024
Get access to data in a file that is uploaded to the Glide internal storage Ask for Help	29	1045	November 13, 2021

How to get a text from a text file (TXT\CSV) into a text column?

Related topics