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

Request a Demo

Get started - it's free 

How to upload test cases in Azure DevOps?

In this article

Test cases can be uploaded to Azure DevOps using several methods:

  1. Manual Creation: In Azure DevOps, navigate to Test Plans and select a Test Plan and a Test Suite. Click New test case to create test cases one by one, defining steps and expected results.  
  2. Import from CSV or XLSX: In Test Plans, within a Test Suite, use the Import option (up/down arrows icon). Prepare a CSV or XLSX file with specific column headers (e.g., Title, Steps, Expected Result). Import the file, mapping columns to test case fields.  
  3. Copy and Paste with Grid View: In Test Plans, switch to Grid View. Copy test cases from other sources (e.g., Excel) and paste them into the grid.  
  4. REST API: Use the Azure DevOps REST API to programmatically create and update test cases.  
  5. Test Management Tools: Some test management tools (e.g., TestArchitect) offer direct integration with Azure DevOps, allowing you to upload test cases and results.  

Tags can be used to categorize and organize test cases. Link test cases to requirements for traceability and use shared steps to reuse common test steps.

How to export test cases from Azure DevOps to Excel?

To export test cases from Azure DevOps to Excel:

  1. Install the Azure DevOps Office Integration extension from the Visual Studio Marketplace if not already installed.
  2. Open Excel and navigate to the Team tab.
  3. Click New List, connect to your Azure DevOps project, and select the query that retrieves the test cases you want to export.
  4. Click OK to load the test cases into Excel, where you can save or edit them as needed.

How to import test cases in Azure DevOps from Excel?

To import test cases into Azure DevOps from Excel:

  1. Install Azure DevOps Office Integration: Download and install the Azure DevOps Office Integration extension from the Visual Studio Marketplace.
  2. Prepare the Excel File: Ensure your test cases are structured with columns for title, description, steps, expected results, and other relevant fields. Save the file in .xlsx format.
  3. Connect Excel to Azure DevOps: Open Excel, go to the Team tab, click Connect to Azure DevOps, sign in, and select your project.
  4. Open a Test Case Template: Click New List, choose Test Case as the work item type, and load the template fields.
  5. Add Data and Publish: Copy your test case data into the template columns, ensure it matches the required fields, and click Publish to import the test cases into Azure DevOps.
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