How to convert text from csv to json?

I have csv file in my app …

I can read it using file component and put the data in lists .

But now I need to convert the text I get from file to json so that to use the dictionary to create the lists …as it’s a fast option other than csv file …

Is there any way to do that?

Maybe convert csv to json before added to app with an online tool like

https://www.convertcsv.com/csv-to-json.htm

But is there any way to convert it with in the app? …
And does the file reads the json file?

Yes

Yes, please post a sample of your csv

1 Like

here are a smaple of my csv files used …
I want to use blocks to convert the text into json so to be used in the app in lists after that but using json not any thing else. …

thanks in advance

Yeap, here is the easiest and less painful method

  1. visit this page :arrow_right: CLICK HERE

  2. click the [script source is here]
    image

  3. make a copy of the code
    image

  4. deploy with your email account
    image

  5. get the script url and add ?id=enter_your_sheet_id&sheet=enter_your_sheet_name

  6. you will see the json structure of your gsheet as bellow in opera like this

e1.txt (197.2 KB)

here is a sample of my csv file

Upload this json to assets and see if it works for you

e1.json (386.3 KB)

I think you can do something like this :
JsonRepresentation.aix (5.5 KB)

1 Like