Some time in our projects we need data in json files(mostly web projects). But collecting and managing data in json files is harder(At least this is what I feel) compared to excel. I had recently ran into a similar situation where I need some data. Data is going to be provided by a non-technical person/client. And there going to be several rounds of it.
So I was looking for options what can be done here, where I found several online tools which could be used for same. But I don’t want to use that because of course privacy. I don’t want to upload an excel file to a unknown application which would process it server side give me results.
My search ended upon this. I found this nodejs module which was supper easy to use which would read your excel file and return a json object. So I created a small nodejs project which help me achieving solution to the problem.
So here is a repository link to source code. To run this you would need nodejs in your system.
You would need to a
npm install and
node index.js to this working.