It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to create Jira issus from Excel file?

When to use CSV importer

When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and is not necessary. If you learn using CSV importer, the time needed to create/update even hundreds or thousands of tasks will not take long.

pic1.jpg

Step 1: Prepare an Excel file

The Excel file needs to be properly formatted for importing data into Jira.

There are a couple of things important to notice

  1. Issue types that I am going to import depend on the project configuration where you want to import tasks. In my template, I have issue types Epic and Task. Unless you have them configured in Jira project, you will not be able to import these tasks.

  2. Just like the column name Issue Type, other column names also correspond to field names in Jira

  3. Epic names of Epics need to be exactly the same in the Epic Link column for tasks

  4. In the Summary column is the title of your issue/task in Jira

  5. Before importing Priority column data, check your configuration what your Priority names are.

  6. The content of the Assignee column depends on your user naming convention.

  7. Description field which is optional 

You can download this example file from this GoogleDrive location.

Step 2: Save as CSV file

pic2.jpg

Save the file as CSV UTF-8. This is important to select UTF-8 character coding to avoid problem later, especially when you use other language than English.
This is the CSV plain file opened in Notepad++. This is how Jira importer will ‘see it’

pic3.jpg

Notice, that in columns where there is no data, you still need commas there.

Step 3: Use the CSV Importer

Now go to Jira Administration / System tab / External system import and click the CSV button.

pic4.jpg

Step 4: See it in practice

If you want to see detailed instructions on how to import CSV file in Jira, please watch my detailed tutorial on YouTube.

pic5.jpg

I hope you found this article interesting and you have learnt something from it.

Please leave a comment below.

10 comments

Thanks @Bogdan Gorka

Very useful article. It happened to me few times, when I thought it would be great to have an easier way to create tons of tasks.

Bridget Community Manager Apr 27, 2020

Great Article, Bogdan!!

Like Bogdan Gorka likes this

Great article, @Bogdan Gorka ! JIRA CSV import is a very useful feature and I have used it a lot in my work.

@Bogdan Gorka - do you know if there's way to import in linked issues? I understand this may not be a common use case, but checking for a client. Thank you.

@Jennifer Mun you can link issues using CSV see the documentation at 

If the issue already exists at the time of importing with the CSV you add a column referencing the type of issue link required and then reference the existing issue by the issue key in that column (empty columns will not have any issue linked). 

However, suppose you want to create links between items that you are importing? In this case you need to create a second CSV with the linkings. Remember you only need a minimal set of fields to do a CSV import and if you include an issue key then this will update rather than create a new issue (assuming the issue key is valid of course). 

So a typical link CSV looks like....

Key, Summary, Blocked, Dependent on

ABC-12,,ABC-11,

ABC-13,,,ABC-11

Things to note here are the empty string for summary which means leave it as it is but is a required field. 

This will then create 2 issuelinks

ABC-12 Blocked by ABC-11

ABC 13 Dependent on ABC-11

Like Jennifer Mun likes this

@Jennifer Mun if you need more explanation on how to import issue links, there is a Knowledge Base article about it here: https://confluence.atlassian.com/jirakb/import-issue-links-from-a-csv-file-in-jira-server-740262715.html

Like Eric Windham likes this
Damian_E I'm New Here May 13, 2020

Good afternoon, I need in jira to create a validation where I can add text in comments. Eg .. before executing something that gives me a warning .. In the comment, the text that you have loaded must appear. when pressing a button called unfold manual that this warning appears and in a text comment, for example, are you sure?

cometario.jpg

This is excellent. Thank you for sharing!

Like Valentina_S likes this

Great solution for stand alone projects where you gather the information first. Thanks for this

What about flipping this around? Exporting existing tickets to CSV/Excel to perhaps showcase specific tasks, epics, support types etc?

Thanks for Info

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

1,799 views 10 18
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you