# Import via CSV

> Bring test cases into Arcus in bulk from a CSV file, including files exported from TestRail, Zephyr, or BrowserStack.

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](https://testsigma.com/docs/arcus/v2/create-and-manage/test-cases/#folders) for the test cases.
- A `.csv` file. Convert `.xlsx` files first.

## Get a CSV 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.

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.

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`.

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

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.

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](https://testsigma.com/docs/arcus/v2/settings/import/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.