Community
Q&A
Jira
Questions
Is it possible to update fields in existing Jira tickets with an Excel file?

Is it possible to update fields in existing Jira tickets with an Excel file?

Hi everyone,

I need to update specific fields in already existing Jira issues using an Excel file. The issues are identified by their issue keys, and I want to modify certain fields (e.g., status, assignee, custom fields, etc.).

Is there a way to achieve this using Jira’s built-in import functionality, or do I need an external app like ScriptRunner or another plugin?

If anyone has experience with this, I’d appreciate any guidance or best practices.

Thank you in advance!

Best regards,

Karyna

2 answers

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

2 votes

Hi @Karyna Lysikova , yes, this can be done natively. You simply perform a CSV import, and you need to ensure that you include the issue key in one of the columns. Any values included for other existing fields will be updated. If you plan on doing this regularly I recommend that you first test with a single issue until you get it working the way you want and save the import template so it can be reused.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hello @Jack Brickey

thank you for your reply.

Could you please let me know if there are fields that are already filled in in existing tickets - will they be then with the new import overwritten?

How should I do that correctly, so that I only update fields (or fill new fields using import file) that I have in my CSV import file?

Appreciate your help.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi @Karyna Lysikova , basically whatever fields you include in your import will result in updating the field.

Example:

your header row = issue key, summary, custom field 1
you have three rows of data (three issues)
after import the three issues will be update including the Summary and the custom field 1 to match the CSV contents

if you dont want fields updated then don't include in the CSV file. What I recommend is to first create a JQL query and set you columns to represent the fields you will update. Export the query then massage the CSV to represent what you want updated then import.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • Karyna Lysikova likes this

Hi @Jack Brickey

thank you. I will try it. Thank you for your help :)

Have a good day

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • Jack Brickey likes this

Please let me know how it goes and if it all works out consider accepting the answer.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi @Jack Brickey

Thanks for the explanation. I tried to do this however I can't find the "Issue key" (yes, I also tried writing the 2 workds; screenshot shows typing "key"); could this be a project setting issue?

csv import test.png

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

That is odd. Something may have changed but unclear what that would be. If I get some time today I will have a look.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Same here, I can not see Issue Key in the mapping field. Is there any solution to this?

When tried to proceed without Issue Key mapping (could map Issue ID though), it creates a new issue, does not update the existing issue.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Hi @Karyna Lysikova,

I trust that you'll be able to resolve this using the CSV import as already suggested.

Just for future reference: If you're looking for a somewhat more interactive experience, and are open to solutions from the Atlassian Marketplace, 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, 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 long list of advanced features, including support for inline bulk editing via copy/paste. This works within JXL, but also between JXL and pretty much any other app, including Excel or Google Sheets.

This is how it looks in action:

So what you can do is to open your CSV file in Excel, and simply copy/paste the values over. You just want to make sure that you paste into the correct set of issues, of course.

I should also add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Was this helpful?

Thanks!

Jira

DEPLOYMENT TYPE

SERVER

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Is it possible to update fields in existing Jira tickets with an Excel file?

2 answers

Comments for this post are closed

Was this helpful?

Thanks!

DEPLOYMENT TYPE

TAGS

Community showcase

Atlassian Community Events