Preparing Test Cases on Excel for JIRA Transition

Current Labels, Components, and Versions: https://docs.google.com/spreadsheets/d/14mmSjy2Xrb-ZRAOkDySsGR2Z8MU0I1WjxnXuwJA8BbE/edit?usp=sharing

Type of Columns have to be the same across all sheets on the excel document for it to work properly on the Zephyr Importer.

Example: Column A, Sheet1 = Test Scenario – Column A, Sheet2 = Test Steps - Both columns Test Scenario and Test Steps will import as the Name field on the Zephyr importer which will not be correct.

Recommended column layout for smooth transition to Zephyr Importer:

Column Order - *Required columns

A – Test Case Name*

B – Test Steps*

C – Expected Results*

D – Test Data*

E – External ID*

F – Labels

G – Comments

H – Versions

I – Components

J – Priority

K - Assignee

L – Description

M – Due Date

N – Issue Key* - not required but will cause errors if not included

Recommended row layout for smooth transition to Zephyr importer.

Add an empty row after every test cases. This will help Zephyr importer indicate individual test cases. Can also add empty rows under every test cases later if preferred with the sort function.

Additional test steps, data, or results can be added by entering it into the row below it. Also enter in the same External ID number on that row if test cases aren’t separated by empty rows yet. Other columns on this row can be left empty. After the last step, data, or result you can enter in the empty row to indicate the test case is done.

The Test Steps column requires a value so if a Test Case does not have any steps just put something like N/A or none

The Test Datas and Test Results do not require a value but will come up as “null” in Jira if nothing is there

Related articles