Import via CSV

Import via CSV adds test cases to the current project in bulk, from your own spreadsheet or from another tool’s export.

Prerequisites

• An Arcus project with folders for the test cases.
• A .csv file. Convert .xlsx files first.

Get a CSV file

Your own file

Any .csv file with one test case per row works. Arcus maps its columns to test case fields during the import, so the column names don’t need to match.

TestRail

1. In TestRail, go to Projects > Test Cases.

2. Select the test cases, click the Export icon, and select Export to CSV.

3. In Export to CSV, select the Sections (folders) and Columns (properties and values) to export.

TestRail downloads the test cases as a .csv file.

Zephyr

1. In Jira, go to Projects, then select the Zephyr tab.

2. Select the folder that holds the test cases.

3. Select the test cases, click More, and select Export to Excel.

4. Convert the downloaded .xlsx file to .csv.

Note

Only test cases created with Zephyr’s Plain Text template can be imported.

BrowserStack

1. In BrowserStack Test Management, go to Projects > Test Cases, then select the folder that holds the test cases.

2. Select the test cases, click Export, and select Export as CSV.

BrowserStack downloads the test cases as a .csv file.

Note

Only test cases created with the Plain Text template can be imported.

To copy a whole project with its runs and history instead, use Quick import, which connects to TestRail, Zephyr Scale, BrowserStack, and six other tools directly.

Upload the file

1. In the left navigation, go to Settings, then select Import.

2. Click Import via CSV, then choose the template that matches your test cases:

   • Steps for test cases written as steps.
   • Document for test cases written as a single description.

3. Click Upload File and select the .csv file. Uploaded File Preview opens.

4. Check the file content, then click Next.

Map columns to Arcus fields

Map Properties and Values has two panels: Map Properties, where each CSV column is matched to an Arcus field, and Test Case Preview, which shows a test case as it will be imported. Arcus maps the columns automatically.

1. Review the mapped fields. Change any column that is missing or mapped to the wrong field.

2. Check the result in Test Case Preview.

3. Click Begin Import.

Arcus creates an import log on the Import page to track progress and results.

Review the import results

When the import finishes, open its log from the Import page. Import Results shows:

• Totals for all, imported, skipped, and failed test cases.
• Failed to import: each test case’s error type and the reason it failed, for example a duplicate title.
• Skipped test cases, for example ones that already exist in the project.
• The imported test cases, with their details.

To bring in the failed test cases, fix them in your .csv file and import it again.