Contruct .json configuration with data from .xls file

We have a .xls file wich we want to use to construct a .json configuration file. Here are the formats what the expected output: XLS sample data: /motive/aahomusic /motive/aajtak_tej /motive/aastha_bhajan output should be: { "label": “Aahomusic, "src": "[login to view URL]" }, { "label": “Aajtak Tej, "src": "[login to view URL]" }, { "label": “Aastha Bhajan, "src": "[login to view URL]" } The label should be filled and formatted for ex from aahomusic to Aahomusic or aajtak_tej to Aajtak Tej (remove all other characters like _ and cap each word). You can use any method to accomplish this, we only want the .json file configuration part.