# 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
1. **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.
2. **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.
3. **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).
4. **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.
{% hint style="info" %}
**Note: To import data to a function, select function data from function module or test data management. Function data cannot be imported from within test case data.**
{% endhint %}
### Exporting Test Data Sets
1. **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.
2. **Export the Data**
* On the top right, click the Excel Import/Export button.
* Select “Export Excel” from the dropdown menu.
* **By default, all data iterations will be exported and downloaded as an Excel file (.xlsx).**
* Open the file to view or modify test data as needed.
{% hint style="info" %}
**Note:** When exporting test data that includes functions, the Excel file will contain separate sheets for better organization. Parameters at the test case level will appear in the **“TC”** sheet, while each function will have its own dedicated **“FN”** sheet, making it easy to manage and review complex data sets.
{% endhint %}
### 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.
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.simplifyqa.ai/test-data-management/import-and-export-test-data-sets.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.