This small application should synchronize XLS with tickets in JIRA.
It can be easly done using https://studio.plugins.atlassian.com/wiki/display/JCLI/JIRA+Command+Line+Interface or WSDL soap interface. Each line in XLS should be synchronized in JIRA.
Project can be realized "agile way", sample user stories are:
1. If JIRA field is empty ticket of type user story should be created, with two sub-tasks (development) (testing)
2. When User story ticket is created, summary and more information fields are taken from XLS.
2. if jira field is not empty in XLS, we need to synchronize current status and logwork from developement subtask.
I will provide draft of the project in VB.NET and template of XLS file.