How to import requirements using excel file?

QMetry helps you import requirements that are maintained in the Excel file. You can import bulk requirements and start maintaining them in QMetry. The requirements are imported in the same order that of in the Excel file.

If you want to import requirements from a Jira, then refer to Importing Requirements/Issues from Jira.

Best Practice: To carry out the import process smoothly, it is recommended that the size of the file you upload should be a maximum of 2 MB.

Fresh Import of Requirements from Excel File

First Time Import is when the organization does not have requirements in QMetry and they import requirements for the first time. This Import is the creation of test assets for the first time. Import always creates version 1.

Convert Requirement data into QMetry Format

Download either of the Requirement templates provided below. Fill the template with your requirement data that you want to import into QMetry. Enter comma-separated values for fields with a multi-lookup list. Make sure that all the columns in the Excel file have a corresponding field in QMetry. Majority of the columns in the Excel file should map to one of the QMetry fields. If there are columns which don’t really map, define those additional fields as User-Defined Fields in QMetry (Administration > Manage Fields).


 Steps to Import Requirements in QMetry

1. Go to the Requirements module.

2. Click on the settings icon on the toolbar and select Import.




It opens QMetry Import wizard showing the following three stages of import:

  1. Upload Source File
  2. Map Fields
  3. Select Import Folder


Step 1: Upload Source File

Browse the file and upload it to import. Select at least one sheet of the Excel file and click Next.

Note:If you receive an “Invalid file” message while uploading some Excel file formats, then open the file in Microsoft Excel and save the file as type “Excel Workbook” with a different name. After that try to import the newly created file.We suggest that file size limitation is 2MB.



The file name appears adjacent to theChoose Filebutton.

  • Header Row: Mention the row number that is considered as a header row so that all rows after that header row can be imported.
  • Select XLS Sheet: All the sheets that exist within the file are displayed on the drop-down. Select at least one sheet of the Excel file. Select the sheet that contains test cases you want to import and clickNext.

QMetry allows blank column/header/sheet to upload because it is possible that an organization can have its first-page containing the name, logo or just intro instead of the actual requirements itself.


Step 2: Mapping the Fields

The fields in the Excel file are displayed underSheet Fieldand fields in QMetry are displayed underQMetry Field.

Map the fields from Excel and QMetry one by one. Fields mandatory to map are displayed in red color.



Removing mapping between fields

If you think that the mapping was not carried out properly, then you can remove the mapping of fields one by one.

To remove a single field mapping, open the QMetry Field list and select "Select QMetry Field" option on it.


Step 3: Save Mapping

Before moving on, save your map so that if you ever need to re-import more requirements using the same file format you can avoid replication of the same mapping process. You can save the field mapping using theSave Mapbutton and giving the map a name. The saved mapping is available to use the next time when you go for mapping the fields. Just select the mapping name and automatically mapping will be done based on the mapping criteria set in the selected mapping. It will apply the same mapping as you did.

Additional Mapping Options

  • Auto Map:This option maps the fields automatically by using keywords in the header names.
  • My Mappings:The drop-down lists out all the mappings saved by all the users while importing requirements. If there is a Map Name on the drop-down, then it shows the mapping currently applied.

ClickNextto proceed towards the next step for import.


Step 4: Selecting Import Folder

Select a destination folder that you want to import the requirements into. The “Selected Path” shows the destination folder path as soon as you select the folder on the tree.

If you want to create a new folder under the tree, then first select the location on the tree, enter the Folder Name in the text box and then click the on theAdd Folderbutton.

ClickFinishto complete the Import wizard and start the import process.



Note: The option Import with warning if chosen will allow to import test cases having a summary of more than 255 characters. This will ignore the warnings and truncate the summary after 255 characters.


After completing the import wizard process the import will be scheduled. An Import Scheduled message will pop up and you can view the progress in the notification window on the application header.

This allows scheduled imports to run in the background and allows the user to continue with their other work.



Refer to Notification Window for Import Progressfor more details.


Re-import Requirements from Excel File

Users can export requirements from QMetry, make required changes in the Excel file and re-import the file into QMetry. This re-import will update the existing requirement details in QMetry. Re-import of requirements allows users to do bulk modification of already created requirements via excel. This saves time where bulk edit feature is not available. Re-import increases the existing version by 1.

You can export test cases from QMetry through Bulk Operations which provides options to Export as XLSX and Export as CSV. Refer to Exporting Requirements for more details.

Note: If the requirements that are being re-imported contain issues imported form Jira, then such issues will not be updated with the re-import.