Import and Export Test Data Sets
SimplifyQA enables users to import and export test data sets, allowing for efficient data-driven testing. This ensures test cases can be executed with different input data sets without manually modifying test scripts.
Importing Test Data Sets
Navigate to Test Data Management
Open the User Navigation Panel.
Go to Test Management > Test Data.
Click on the “View Details” button of the relevant test data.
Importing Test Data
On the top right, you will find the Excel Import/Export button.
Click on “Import Excel” from the dropdown menu.
A pop-up window will appear with an option to upload an Excel file.
You will be prompted to drag and drop a file or browse through your computer to select the file.
You can also download a sample file which will provide you with a template in which you can fill with the test data and can be uploaded.
Prepare the Excel file
Before uploading, ensure that the test data file follows these guidelines:
Column Names should match the parameter names used in the test case.
Sequence Number must be provided for each iteration to maintain execution order.
Data Format should be consistent (e.g., date fields, numeric values).
Upload the File
Once the file is selected, click upload.
The tool will validate the data and display a confirmation message upon successful import.
And click Save, to save the data.
Exporting Test Data Sets
Navigate to Test Data Management
Open the User Navigation Panel.
Go to Test Management > Test Data.
Click on the “View Details” button of the relevant test data.
Export the Data
On the top right, click the Excel Import/Export button.
Select “Export Excel” from the dropdown menu.
All the iterations of The data will be downloaded as an Excel file (.xlsx).
Open the file to view or modify test data as needed.
Best Practices for Managing Test Data
Use consistent naming conventions for parameters.
Keep test data files updated to reflect real-world scenarios.
Ensure data integrity by avoiding missing or incorrect values.
Regularly export test data for backup and reuse.
By efficiently importing and exporting test data, teams can streamline their test execution and improve data-driven testing workflows in SimplifyQA.
Last updated