nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Importing issues from JIRA to Excel using API

Sherwin R

I am trying to automate exporting issues from JIRA to excel workbook periodically. Is it possible to achieve this using Rest API. I read that it is posssible to export the issues to JSON format using the API, but is there a way to directly export the issues to excel or is it possible to convert the JSON to Exce, as if were exported to excel manually ?

Accepted answers

Pramodh M

Hi @Sherwin R

Welcome to the Community!!

Here's an article that may help you for creating issues from Excel via API using Python Script

https://community.atlassian.com/t5/Jira-discussions/Reference-code-to-create-JIRA-issue-using-atlassian-JIRA-Python/td-p/1942861#U1942872

Looping Praveen Chitturi for any help

Thanks,
Pramodh

Levente Szabo _Midori_

@Sherwin R

Is the direct usage of the REST API a requirement?

If you are on Jira Server or Data Center, you can easily do this by automating Excel exporting (and saving, emailing, or attaching to issues) with the combination of Better Excel Exporter and Better Excel Automation for Jira.

More on how to set up the necessary apps here in the Documentation of Better Excel Automation.

All comments

Pramodh M

Hi @Sherwin R

Welcome to the Community!!

Here's an article that may help you for creating issues from Excel via API using Python Script

https://community.atlassian.com/t5/Jira-discussions/Reference-code-to-create-JIRA-issue-using-atlassian-JIRA-Python/td-p/1942861#U1942872

Looping Praveen Chitturi for any help

Thanks,
Pramodh

Sherwin R

Hi @Pramodh M

Thanks for the answer. Actually I want to export issues from JIRA as a excel worksheet and not create an issue.

Thanks,

Sherwin

Pramodh M

Hi @Sherwin R

You could export a maximum of 1000 issues at a time using Jira UI itself.

Using API if you need to get the issues, the response will be in JSON. Using Pagination, you can get all the issues from instance using API

Tools like JQ will help in converting the issues from JSON to CSV.

Here's a guide on how to do that

https://stackoverflow.com/questions/32960857/how-to-convert-arbitrary-simple-json-to-csv-using-jq

Let me know which fields you need to track in Excel I will send out a command for that

Thanks,
Pramodh

Sherwin R

Hi @Pramodh M ,

Thanks again for your quick reply.

So the fields I want to export for each issue are:

Issue type, Key, Summary, Assignee, Reporter, Status, Due Date, Hourly rate 1, Hourly rate 2, Checklist, Resolution, Components and Initiator.

Some of them are custom fields.

And I also want to export only Issue Type == Activity.

Thanks,

Sherwin

Levente Szabo _Midori_

@Sherwin R

Is the direct usage of the REST API a requirement?

More on how to set up the necessary apps here in the Documentation of Better Excel Automation.

Sherwin R

Yes, but it would be better in my case if i can use REST API directly to achieve that.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

atl-gruland