Importing

Importing standard issues

With ImpEx Cloud, you can import issues from Excel to Jira.

There are 3 mandatory columns you need to use when importing:

Please be aware that ImpEx Cloud only accepts the full name or the key of the project!

Create the columns and copy the lines with the correct column names from Excel by pressing Ctrl+C.

The correct Date/Time format

yyyy.MM.dd. HH:mm a

To import the copied cells, you have to open the import dialog and select the Import... menu.

After opening the import dialog you will see some useful information about:

On the top left corner you can find a link to the documentation (Tutorial)
A 3-step visual guide presenting the import steps under the "Follow our guide!" section
On the bottom of the screen you can see the color guide of the import process

To insert your data click in the Paste here (Ctrl+V) cell and press Ctrl+V to preview the import.

PRO TIP

You have to include the correct column names when pasting the values!

To copy columns names and see the right format of fields:

About the colors that will help you:

If there is any problem with the import, you will see the problematic cells turn into red.

If you hoover over a red cell an error message appears, that can help you with troubleshooting.

The cells colored with orange will be ignored.

If you fix the problems, you will see the preview without any red cells and you can click on Create.

And the issues are created!

Please note, that we currently support the following fields to import:

Summary
Issue Type
Project
Description
Epic name
Labels
Due date
Priority
Status (Each uploaded issue's status will be set to selected Issue Type's first available status!)

About creating subtasks:

To create Sub-tasks use the Parent Issue Key (impex) column to specify the parent issue.
Sub-tasks without the column Parent Issue Key (impex) will be assigned automatically to the closest non-sub-task issue above them.