Each of the column inside my row has this data which is parsed from a csv file as shown in the image [image] [image] Now, I want to make these seperate objects like [image] How can I do this such that it will become like a collection which I can create a table of. I am uploading and creating…

A relation doesn’t return an object, but anyway… Here is a simple example using your sample JSON: [CleanShot 2025-06-02 at 20.34.03@2x] To extract each attribute into a separate column, I used a JavaScript column like so: const json = JSON.parse(p1); return json[p2]["Transaction date"]; [Clea…

Pass the HTML source to a CSV to JSON column. You can then use that to add new rows, either with a workflow loop, or by preparing a JSON body and sending to the Glide API.

Can you please explain how I can do this? as I have tried converting to json and I am on explorer plan so I can’t use Glide API and I want to show it as a simple collection table

Yes, I like that approach and it would work but it is quite costly as my program’s main functionality is to store transactions data which is a lot like 100 rows usually and in 250 updates I cannot manage that every time as there will be about 30-40 users using my app for uploading their transacitons…

Is there like a way when we create a relation we get objects coming. Can we not replicate those types of objects by using json directly and not involving a lot of Add Rows, I want it to be specific for each row like I have the data there should be a way to just convert each json array into the glide…

If you just want to store the JSON, then expand it into a list when you want to view it, then yes that is possible. Essentially you need a Helper Table with numbered rows, temporarily write the JSON into the Helper Table, apply it to every row, then extract the items into rows and columns using a co…

Here is JSON structure, usually these JSONS include about 35 values but to showcase I have shared you the transaction json which includes only 2 values. I want to preview them as a table [ { "Transaction date": "14-Mar-25", "Value date": "16-Mar-25", "Transaction reference": "00045205…

I am looking for something like this for the transactions json [image]

Your sample JSON does not appear to correspond to the sample table in any way. I don’t see any of “Name”, “CSV Name”, “Created At” or “ID” in the JSON data.

In sample I showed the type of table design I want

How to parse CSV into a collection

Ask for Help

Darren_Murphy June 2, 2025, 10:10am 4

If you’re on the Explorer plan, then the API is not an option. So you would need to use a workflow. Below is a video done by a different Darren, that demonstrates one way to do it.

Topic		Replies	Views
Turn JSON array into rows in separate table Ask for Help	12	248	August 10, 2025
Import data via front end Ask for Help	16	729	February 16, 2025
Fetch JSON and JSON transform Ask for Help	16	703	November 2, 2022
CSV uploads in your app Project Showcase tutorial	4	157	May 8, 2025
JSON data to display in the list Ask for Help	7	686	May 11, 2024

How to parse CSV into a collection

Related topics