Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Unable to import testcases from excel to Xray

I am getting the below-attached message: 

Please note: A Jira Summary, Xray Test Case Identifier and Custom Fields [Action] are required to enable import.

1 answer

0 votes

HI @Piyush Sahu 

The "Step" as been renamed to "Action" as you can see on the section of manual steps:

When using the Test Case Importer the correct mapping should be the "Action".

Then to recap, right now, by default, each Test Step has the following fields:

Action* - the action to be reproduced by the tester
Data - any data the related step requests (e.g., login credentials) to be used by the tester
Expected Result - the behavior the step should accomplish.
Attachments - external files that provide additional information related to the corresponding step. Attachments can only be added or removed in the Test Issue view page.

*Only the Action field is mandatory. All other default fields are optional.

However, to correctly import, you need to map Summary, Test Case Identifier, and Action.

Best Regards,

Team Xray

Hi Jose,


can you please help with steps detailed here ..?

@José Domingues [Xray] ,


Please help with steps here, i am also getting same issue.

I am also getting error and could not able to import test cases 


error 297.PNG

Hi @Siddhesh Patil 

It looks like the action column is missing from your file, please add the column like described in the documentation here.

If you need further help, please contact the Xray Support ( so that we can request additional information and investigate further.

Kind regards,
Rogério Paiva [Xray Support Team]

Like Asia DevOps Team likes this


I also faced the same error msg as Siddhesh Patil. The thing that worked for me was the file. Although the data was exactly the same, by copying the data and pasting it a new sheet I was able to import the file.

Trying to import as CSV, getting below error can someone help here.

*Missing mandatory Summary Field*

Does anyone has the answer to this?

Try writing one test case in X-ray, then export this text case and compare it with your existing JIRA test case csv file.  :)

Suggest an answer

Log in or Sign up to answer

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