Meet 2025’s Top-rated Software Test Management Tool. Learn More >

Request a Demo

Get started - it's free 

How to import test cases in Azure DevOps?

In this article

Importing test cases into Azure DevOps can be done using the built-in tools or extensions. Below are the common methods to import test cases efficiently:

1. Using the Excel Integration (Test Case Migrator)

Azure DevOps integrates with Excel to allow you to import test cases.

Steps:

  1. Install Azure DevOps Office Integration: Go to the Download Center and install the ‘Azure DevOps Office Integration’ add-on.
  2. Prepare Your Test Cases in Excel: Ensure the Excel file contains fields such as Title, Steps, Expected Results, Priority, and Assigned To.
  3. Connect to Azure DevOps: Open Excel and navigate to the Team tab in the ribbon. Click on New List and connect to your Azure DevOps project.
  4. Map Your Columns: Select the Test Case work item type and map the columns in Excel to the corresponding fields in Azure DevOps.
  5. Publish the Test Cases: Click Publish to upload the test cases to Azure DevOps.

2. Using the Azure DevOps REST API

If you need to automate or handle bulk imports programmatically, you can use the Azure DevOps REST API.

Steps:

  1. Authenticate: Use a Personal Access Token (PAT) to authenticate your API calls.
  2. Prepare the Data: Format your test cases in JSON according to Azure DevOps API specifications.
  3. Create Test Cases: Use the POST endpoint to create test cases. Provide the necessary fields like name, description, and action steps.
  4. Execute the API Call: Use tools such as Postman or Python scripts to perform the import.

3. Using Third-Party Tools

Several tools/extensions simplify importing test cases into Azure DevOps, such as:

  1. Test Case Migrator Plus: An extension that supports migrating test cases from Excel or other tools into Azure DevOps.
  2. Test Management Extension for Azure DevOps: Offers robust importing, reporting, and management features.

4. Using CSV Import via Test Plans (Preview Feature)

Azure DevOps has a CSV import feature for test cases, which may need enabling.

Steps:

  1. Enable the Feature: Go to Project Settings > Preview Features. Enable the Test Plans: Import test cases from CSV option.
  2. Prepare the CSV File: Use a simple structure with headers such as Test Case Title, Steps, and Expected Results.
  3. Import the CSV: Navigate to Test Plans in Azure DevOps. Select Import test cases and upload the CSV file.

How to import test cases from QA Touch into Azure DevOps?

To enhance the process of importing test cases from QA Touch into Azure DevOps, start by leveraging QA Touch’s custom export feature to ensure the exported test cases include all necessary fields such as Title, Steps, Expected Results, and custom attributes. Use Azure DevOps’ Excel Integration or CSV Import tools for uploading. For large-scale imports, consider automating the process by scripting with Azure DevOps REST API, ensuring consistent field mapping between QA Touch and Azure DevOps. Additionally, QA Touch’s integrations with Azure DevOps can simplify data synchronization, reducing manual effort and maintaining traceability between test management and development workflows.

Picture of Sridhar K

Sridhar K

All Posts

Deliver quality software with QA Touch

Questions? Explore our docs, videos, and more just one click away!

Schedule my demo

Real people with life changing results

Insights from QA Teams on QA Touch’s Impact

Frequently asked questions

Everything you need to know about the product and billing

Why QA Touch?

QA Touch is an AI-driven test management platform built by testers for testers. It simplifies collaboration between developers and QA engineers while helping to manage, track, and organize test cases efficiently. Streamline your testing processes, enhance QA visibility, and deliver high-quality software with ease.

QA Touch offers comprehensive features to manage the entire test management process. From easy migration with CSV files to audio-visual recording of issues and activity logs and a shareable dashboard for real-time reporting to stakeholders, we ensure the testing teams are always on top of things.

Our focus is on providing complete visibility and control over testing workflows and fostering collaboration between testers and other stakeholders (both internal and external). You can have a look at all the features here.

Once you sign up, it takes only 30 minutes to get your QA Touch account up and running. After registration, you will receive an account activation email with all the details. Log in with your account details and create your first test project on QA Touch—it’s that simple. You are now ready to start inviting your team and assigning them roles.

If you are finding it difficult to log in or facing any difficulty, feel free to reach our support team at info@qatouch.com

Why is QA Touch the best test management tool for me?

QA Touch is an AI-driven test management platform that simplifies collaboration between your developers and testers. Beyond creating, organizing, and executing test cases, QA Touch enables you to manage projects, track bugs, and monitor time—all in one platform.

With an intuitive UI and seamless two-way integrations, QA Touch adapts to your workflow, making test management, project oversight, and bug tracking smarter and more efficient.

With secure OKTA, Microsoft Azure SSO, and Google SSO enterprise features, you can stay connected in every app.

We have integrations with dozens of major apps like Slack, Jira, Monday.com, Cypress, and many more. Explore the whole list of integrations now supported here: Explore integrations

The test management tool is a modern software application that helps QA teams and developers manage their testing process efficiently. It provides a structured approach to creating, organizing, executing, and tracking tests to ensure software applications meet specified requirements and function properly before release.

Don’t just take our word for it.

QATouch is a leader in G2 market reports.
Get started - it's free
Talk to a Human