I had a requirement to parse a json data in android. I used the following online services to quickly get the json format from excel and then convert it into Java class using Gson notation.
- Convert the excel data into csv format. Paste one record from the CSV file here https://shancarter.github.io/mr-data-converter/ . At the bottom pane you can see the json data
- Copy the parsed json data and paste it here http://www.jsonschema2pojo.org/
- Enter the java package name and other optional params
- Click “preview” and you get the Java class.
Copy the Java class and use it in the project.