Uploading Test Cases to ALM via Excel

A Quick Manual on how to Upload Test Cases to ALM using Excel

Creating test cases on HP Application Life-cycle Management (ALM) sometimes could be frustrating; the application may be running slow, it could be under maintenance, or maybe the tester has the test cases on a spreadsheet. Luckily we have Excel to save the day. Below are the steps needed to create and upload test cases into ALM.

1. Go to your ALM application.

2. Click on the Help menu on the left panel.

3.  Click on the Add-ins button:

1. Click on the Microsoft Excel Add-In button.

1. Click the Download Version link to save and install the downloaded file.

2. Open Microsoft Excel; at the top menu, click on “HP ALM Upload Add-in.”

3. Click on the ALM Login button:

Revolutionize Your Business With Generative AI

From product design and software development to virtual agents, content creation, and reporting, GenAI is transforming business. Our AI experts help you unlock GenAI’s full potential and drive growth.

Let’s Get Started

1. Enter the ALM address, user, password, domain, and project fields. Click on Login.

2. On the spreadsheet, create the following columns, and take a look at how each test case is identified; in the example below, we have two test cases: Test1 and Test2.

Column Subject is the location within Test Plan where the test cases will be placed; the next columns are self-explanatory.

1. Click on the Mapping button within the HP ALM Upload Add-in menu. Select “Tests” as the Entity type and create the following mapping:

1. Click on Validate button within the HP ALM Upload Add-in menu; a process will run, and then a confirmation message will be prompted: “The validation has passed.”

2. Finally, Click on Upload to ALM.

After the process runs and confirmation is prompted, go into ALM and look for the test cases under the Test Plan section.

This is a very convenient way to create test cases; maybe you can find it faster than creating them directly on ALM.