Skip to content
Docs
Arcus
Popular questions
↑↓ to navigate↵ to selectesc to close
Book a demo

Import from 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.

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.

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

  1. Open the project switcher at the top of the left navigation, click Project Settings, then open Import.

    Project Settings > Import. Callouts mark (1) Import, and (2) Import via CSV and (3) Quick import from.

  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.

    The Import via CSV menu. Callouts mark (1) Steps and (2) Document.

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

    The CSV upload screen with Upload File outlined.

  4. Check the file content, then click Next.

You can also open the Import page from the Dashboard, under Import Test Cases (.csv), by clicking Import, or from Test Cases, by clicking the more options icon (⋯) at the top of the page and then Import.

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.

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.

Step groups import from the Step Groups tab of the same Import page. There’s no template to choose.

Lay the file out with one step group per block of rows. A row with a title starts a new step group, and the rows below it, up to the next title, are its steps.

Title,Description,Step,Expected result
Log in as admin,Signs in with the admin account,Open the sign-in page,The sign-in form shows
,,Enter the admin email and password,
,,Click Sign in,The dashboard opens
Search for a stay,,Enter a city in the search box,
,,Click Search,Results show for that city

The mapping screen has four step group fields: Title and Step Description, which are required, and Description and Step Expected Results. Arcus gives each step group its ID.

  1. Open the project switcher at the top of the left navigation and click Project Settings.

  2. Open Import.

  3. Open the Step Groups tab.

  4. Click Import via CSV.

  5. Click Upload File and select the .csv file. Check the file content, then click Next.

  6. Under Map Properties, check the mapped fields and change any that are missing or wrong. Step Group Preview shows a step group as it will be imported.

  7. Click Begin Import. Arcus shows “Data Import Started” and returns to the Import page.

A step group whose title already exists in the project is skipped, and so is a second step group with the same title in the file. Titles are matched without regard to case. Open the import’s log on the Step Groups tab to see the totals for Imported Step Groups, Skipped Step Groups, and Failed Step Groups. Skipped lists each skipped step group’s TITLE and REASON, such as “Step group with title ’…’ already exists in this project”.

Was this page helpful?