Jira And Excel or Google Sheets

[Filipe Ferreira Sousa]

Hi, Jira Group

My name is Filipe.

I am a script developer for Excel and Google Sheets.

We have a project to develop a VBA script to fill out a ticket in Jira automatically using Google Sheets or Excel.

The information will be written in Excel cells and, with a button, the script runs and fills in the fields in Jira.

Or, I would like to know if there is the possibility of exporting an Excel spreadsheet with all the tickets that we need to open and automatically fill in on the Jira platform.

[Kalyan Sattaluri]

Hello @Filipe Ferreira Sousa 

There are third party add-ons which do this and avoids custom implementation and maintanence?

OTOH, if you do want to implement (and I am not a developer), one solution comes to mind is that for each row in excel, you need to make a POST REST API call to create issue.

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Creating-Jira-Issue-from-Excel-vba/qaq-p/505691

https://codereview.stackexchange.com/questions/244387/part-1-send-http-request-for-each-row-in-excel-table

So maybe do a POC like the first link and if it works, you need to extend it so you can create it for each row.

Hope it helps.

[Hannes Obweger - JXL for Jira]

Hi @Filipe Ferreira Sousa

this doesn't directly answer your question, but just to second what @Kalyan Sattaluri said above:

There are third party add-ons which do this and avoids custom implementation and maintanence

As an example, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing and -creating, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a range of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting. Of course, you can create new issues, too, like so:

Issue creation will also respect the configured grouping and hierarchy, i.e., you can easily create a new sub-task below a parent task, etc.

I know that an app might not match your requirements as perfectly as a custom implementation would, but depending on your use case, it might be worth a consideration.

Any questions just let me know,

Best,

Hannes

[Filipe Ferreira Sousa]

Hi Hannes and Kalyan.

Thanks.

I will develop the project over the next few days and, as I do, I will update it here.