Excel to JSON Conversion

I want to retrieve specific values form excel and create a json of that like let say have some data in excel with some name and want to fetch that data into json with that name ? i want to create dynamic json based on excel data

@EdGibbs @Palaniyappan @HareeshMR

1 Like


You can try below component to convert DataTable into Json file and it was developed by @sandeep13



i think you attached wrong xmal

Sorry, I didn’t change the name of the xmal file.

1 Like

no i had just opened it but it was related to compress folder only not to json

This is the right file, sorry for the wrong file,
DatatableToJson.xaml (5.5 KB)


im not able to see that activity can you just take a screenshot of that send it me with properties panel ?

Check the screenshot download this package

Property panel,

1 Like

If you want to convert one column of a datatable to json string then use below linq query before the “Datatable to Json” activity,
" dt = NewDT.Select().CopyToDataTable().DefaultView.ToTable(False,“ColumnName”)"
and assign it to a new datatable variable.
Then pass the dt to the “Datatable to Json” activity.

1 Like

see what i want to do is that i have excel data like

and from that data i want numeric data to be fetch and dynamically update into my defined json like
so i want below week my data will be updated.


Whether “variable” column name is constant???..

1 Like


@Manish540 hey any answer please help …

cheers :smile:

In this video I do a lot of stuff with JSON (Chapter included)
15:55 Datatable to JSON
17:50 JSON to Datatable

Cristian Negulescu