How to convert text from csv to json?

Discuss
1

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?

2

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

3

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

4

Yes

Yes, please post a sample of your csv

1 Like
5

image
image1366×768 87.7 KB

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

7

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
    image674×157 7.04 KB

  3. make a copy of the code

    image
    image334×431 17.8 KB

  4. deploy with your email account

    image
    image310×259 6.11 KB

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

    image
    image846×100 9.46 KB

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

    image
    image237×546 7.17 KB

8

e1.txt (197.2 KB)

here is a sample of my csv file

9

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

e1.json (386.3 KB)

10

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

image
image1053×307 28.2 KB

1 Like
11

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