Need a example Excel file for import

[Jeson Duthie]

Can someone give me a template of the Excel that can be used for importing

[Petter Gonçalves · Accepted solution]

Hello @Jeson Duthie

Welcome to the Atlassian Community.

You can extract the ideal CSV template directly from your own site. These would be the steps:

1. If you still don't have any issues created, manually create a new issue in your Jira site. If you already have, jump to the next step
2. At the top header of any Jira page, click in the Filters menu > Advanced issue search
   
3. In the new page, keep the filter bar empty and click enter. It will return all the issues created in your site
4. Click in export > Export Excel CSV (all fields):
   

The file exported will have all the fields you currently have for your issues described in the first row, so you can simply delete the values from the next rows and use the header as a template. The only required fields to make the import works are Summary, Project Key, and Project Name, so it's okay If you want to keep some fields empty.

For more details about CSV imports, you can check the documentation below:

Importing data from CSV 

Let us know if you have any questions.