# Import, Export

You can Import Test Cases and Requirements to BesTest with a simple Excel or CSV. 

This is useful if you already have an established set of testing asset which you want to reuse in BesTest quickly.

## Importing Test Cases

Start importing by selecting Import on Test Cases tab.

<figure><img src="https://3532578673-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmRekQAzTuU34yaMn8nFS%2Fuploads%2F7vqtHNrCDK9u5gi34zrz%2Fimage.png?alt=media&#x26;token=254e8165-df07-44cc-8d30-3f83ef63df19" alt=""><figcaption></figcaption></figure>

### Test Case Import Template

Import template always available with the *Download Template* button (it is a really simple Excel/csv).&#x20;

{% file src="<https://3532578673-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmRekQAzTuU34yaMn8nFS%2Fuploads%2FxdP3GgMn8AHDSRpggSYt%2Fbestest-tc-import-template.csv?alt=media&token=35fb8b65-8647-4daf-bd93-3b2b7973f291>" %}

The Import is a 4 step process:

{% stepper %}
{% step %}

### Upload the file

Select a starting folder (or leave empty) and upload your testcases with the filled template.

<figure><img src="https://3532578673-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmRekQAzTuU34yaMn8nFS%2Fuploads%2FpHueGsMaQrFWtoIMVPhF%2Fimage.png?alt=media&#x26;token=7585218f-1c36-409a-a317-72f8ac3f6fc4" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

### Map Columns

Connect your columns with the system fields. Import Basic attributes, test steps (traditional or BDD), and Already imported Requirement to auto-create coverage!

<figure><img src="https://3532578673-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmRekQAzTuU34yaMn8nFS%2Fuploads%2FS9NsQECab6DXlndzSPgm%2Fimage.png?alt=media&#x26;token=a80e9376-38b8-421d-811b-89063f936411" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

### Validate

Built in validators testing the most common mistakes like invalid data for a fixed-data field, or a non-existing Owner ID.&#x20;

{% hint style="info" %}
**Skip existing test cases**: use this if your first try failed and need to import again, so that test cases with the same name in the same folder won't be imported again.
{% endhint %}

<figure><img src="https://3532578673-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmRekQAzTuU34yaMn8nFS%2Fuploads%2FkmscpyXPe0QaRIN0CQ3r%2Fimage.png?alt=media&#x26;token=6a16aefb-0ddd-42fa-b64e-873b40ad635c" alt=""><figcaption></figcaption></figure>

The import progressing in batches of 100 test cases, and the file limit is a maximum of 10.000 rows or 10Mb. If you have more, you need to create multiple import files.
{% endstep %}

{% step %}

### Finish

When import done, you will get a summary of the result, with the list of imported test cases.&#x20;

{% hint style="info" %}
If you wish to import Requirements connected with your test cases, you can download the Result csv, so you have a table to connect your original test cases with their new TC Key -> that can be used in your Requirement Import csv!
{% endhint %}

<figure><img src="https://3532578673-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmRekQAzTuU34yaMn8nFS%2Fuploads%2FCf9chugsqLMK3Q1iJnHI%2Fimage.png?alt=media&#x26;token=94a999b1-009b-418a-a5b4-019ec660c2ef" alt=""><figcaption></figcaption></figure>

Any problem or error will be displayed on this screen. If you struggle with importing, feel free to contact support and we will help you moving in to your new home of QA :heart\_hands:
{% endstep %}
{% endstepper %}

## Importing Requirements

Similar as Test Cases, Requirements can be imported from your old system with a simple 4 step process.

<figure><img src="https://3532578673-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmRekQAzTuU34yaMn8nFS%2Fuploads%2FB37waMclbrx1SNDae3ez%2Fimage.png?alt=media&#x26;token=7d778dc5-da45-488e-a512-b3cd8feda2d1" alt=""><figcaption></figcaption></figure>

### Requirement Import Template

Import template always available with the *Download Template* button (it is a really simple Excel/csv).&#x20;

{% file src="<https://3532578673-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmRekQAzTuU34yaMn8nFS%2Fuploads%2F5WLuIQtU0IQS4RivBNLK%2Fbestest-req-import-template.csv?alt=media&token=876b73ac-1ba0-45eb-96e9-b6a39e2c42d6>" %}

{% stepper %}
{% step %}

### Upload the file

Start by downloading the template file, and create your own Excel / CSV import file based on that! Drag in when ready to start!

<figure><img src="https://3532578673-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmRekQAzTuU34yaMn8nFS%2Fuploads%2FoFMwnaEuwkCnu266Q2ez%2Fimage.png?alt=media&#x26;token=0bc45b57-e54f-4a3f-9b1e-9061398c8afc" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

### Map columns

Requirements have fields and Linked Test cases. To get test cases keys, you can either download the import result after importing them, or simply export selected test cases. Linking Test cases - as most of the fields - is optional.

<figure><img src="https://3532578673-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmRekQAzTuU34yaMn8nFS%2Fuploads%2FkwjFeLrXClyqezChy9Fm%2Fimage.png?alt=media&#x26;token=75661c7f-8aa9-4a8c-b6d0-3f12f71bfb67" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

### Validate

Let us check the most common mistakes to simplify your work with the built-in validators.

{% hint style="info" %}
**Skip existing requirements**: use this if your first try failed and need to import again, so that requirements with the same name in the same folder won't be imported again.
{% endhint %}

<figure><img src="https://3532578673-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmRekQAzTuU34yaMn8nFS%2Fuploads%2FVQ5zE0l4XxJsEfMQkuMx%2Fimage.png?alt=media&#x26;token=a6b263f8-f292-40b2-8afb-9428c7f046a0" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

### Finish

When import done, you will get a summary of the result, with the list of imported requirements.

{% hint style="info" %}
If you wish to import Test Cases connected with your Requirements, you can download the Result csv, so you have a table to connect your original requirements with their new REQ Key -> that can be used in your Test Case Import csv!
{% endhint %}

<figure><img src="https://3532578673-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmRekQAzTuU34yaMn8nFS%2Fuploads%2FpOaN79D80uFzYE9DH86u%2Fimage.png?alt=media&#x26;token=ca0759d9-b5e6-43d0-af9b-05f92c712a4e" alt=""><figcaption></figcaption></figure>

Any problem or error will be displayed on this screen. If you struggle with importing, feel free to contact support and we will help you moving in to your new home of QA :heart\_hands:
{% endstep %}
{% endstepper %}

## Exporting Requirements and Test Cases

Test Cases and Requirements also can be exported. This is useful when you&#x20;

* moving between instances (from testing to prod)&#x20;
* want to store your assets out of Jira as well

You can select items in the catalog then export in CSV or Excel.

<figure><img src="https://3532578673-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmRekQAzTuU34yaMn8nFS%2Fuploads%2Frv29xofrUXesypNVPTiw%2Fimage.png?alt=media&#x26;token=956f26ce-3541-4cd1-9b92-d88b44676915" alt=""><figcaption></figcaption></figure>