Unable to import the test steps while importing the test cases from excel

Kishore Chava 0 Reputation points
2025-12-15T12:48:38.4166667+00:00

Unable to import the test steps while importing the test cases from excel

Azure DevOps
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Rakesh Mishra 4,030 Reputation points Microsoft External Staff Moderator
    2025-12-15T15:21:36.6433333+00:00

    Hi @Kishore Chava , It looks like you're having trouble importing test steps while importing test cases from Excel. This can happen due to some specific requirements and limitations within Azure Test Plans.

    Here’s what you can check:

    1. Mandatory Fields: When importing test cases, ensure that your Excel sheet includes all the mandatory fields. You need at least these nine headers to be correctly defined:
      • ID (leave empty for new cases)
      • Work Item Type
      • Title
      • Test Step
      • Step Action
      • Step Expected
      • Area Path
      • Assigned To
      • State
    2. File Format: Make sure the Excel file is saved in the correct format (XLSX) and that it doesn’t exceed size limitations. The data during import should not exceed 20 MB as JSON objects.
    3. Restrictions on Test Steps: It’s important to know that if you included both a shared step reference and step details in the same row, this may cause the import to update the existing shared steps work item. If you want to just reference shared steps without modifying them, make sure not to include step details in that row.
    4. Import State: Ensure that the test cases are in the “Design” state during the import process.
    5. Review Field Mapping: After you upload your file, double-check the proposed field mappings to ensure everything is automatically mapped correctly.

    If you're still stuck, please share below information to troubleshoot further:

    • What specific error message are you encountering during the import?
    • Can you confirm that your Excel file has all the required fields filled out correctly?
    • Are you using the updated import interface, or are you on the legacy interface?
    • Have you tried importing a smaller subset of test cases to see if that succeeds?

    Hope this helps you get things moving again! If there's anything else you need, feel free to ask!

    References:

    Note: This content was drafted with the help of an AI system.

    0 comments No comments

  2. Kishore Chava 0 Reputation points
    2025-12-16T06:38:20.3866667+00:00

    Yes, my Excel file contains the required fields. However, after uploading the file, I do not see any mapping screen. I have also tried maintaining the test steps both in the same row and in different rows, but they are not being imported. Even though I receive a success message, the test steps are not imported.

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.