# Import Tests From CSV/XLS

If you have tests in CSV/XLS format - follow this guide to learn how to import your tests to Testomat.io

For now, Testomat.io supports import from CSV/XLS for these systems:

  • TestRail
  • Zephyr
  • Qase
  • QTest
  • Testomat.io

# How To Import Tests From CSV/XLS

You can use Import from CSV button on Tests page :

image

Or use Imports button on the side menu:

image

Then click on the Menu button and pick Import From CSV

image

Pick the format you are going to import:

image

Click on Choose file and pick your file:

image

Now click on Create button

image

And see Testomat.io importing your tests

Import From TR

# Example Files For Import

Here you can find samples for each of supported formats:

# Import CSV/XLS As BDD

Please note that this is experimental feature and some data can be imported wrongly.

Testomat.io allows converting CSV/XLS to BDD Scenarios, where your Precondition equals Given, Step = When, and Expected Result = Then.

image

For this moment this feature is implemented for TestRail. But you can request it for other systems here (opens new window).

# Create Custom XLS For Testomat.io

You can create your own XLS to import your tests to Testomat.io. There are such rules to create custom XLS files for Testomat.io import

Column name Content
ID leave it empty
Title put the title of your test here, one title per row
Status goes for test type manual or automated, can be blank
Folder place here the name of the suite, and use /suite name/sub-suite name format to create suites nesting
Emoji can be blank
Priority you can set priority to your test normal, important, high, critic or low, can be blank
Tags place here any tags you need, can be blank
Owner name of test owner, can be blank
Description put here the description of your test, Markdown format (opens new window)supported

You can download the custom Testomat.io example file here (opens new window).