Importing from Google Sheets

The web-based interface of SpiraTeam® is ideal for creating and managing all aspects of your projects. However when migrating requirements, release, tasks, incidents, and test cases with test steps for an existing project from another system, it is useful to be able to retrieve and load in a batch of artifacts, rather than having to manually enter them one at a time.

To simplify this task we've created a Google sheets add-on for SpiraTeam® that can import requirements, releases, tasks, and test cases with test steps from a generated spreadsheet into SpiraTeam®.

*This guide assumes you have a Google account with access to Google Drive and persistent access to the internet. It also assumes your instance of SpiraTeam (or SpiraTest, or SpiraPlan) is accessible over the internet so that Google Sheets can send data to it.

Installing the SpiraTeam® Google Sheets Integration Add-on

Like most Google services installation is very simple and straightforward as long as you have a Google account.

  1. Open a new spreadsheet, navigate to the add-on menu, and click the "Get add-ons" option.

  1. From there the Add-on store will launch, simply search for "SpiraTeam" and you will find the SpiraTeam Import Tool Add-on.
  1. Click install and authorize the add-on to work with documents related to your account.

Connecting to SpiraTeam®

Before connecting to SpiraTeam® with the add-on make sure that you're working on the first tab in the spreadsheet.

  1. Launch the add-on from the add-on menu with the "Start" option. The add-on will launch into a window docked to the side of your current spreadsheet.

  1. When the add-on fully loads you will be able to enter your SpiraTeam® log in credentials.

  2. Spira URL : Please enter the web address that you use to access SpiraTeam® in your browser. This is usually of the form http://<hostname>/SpiraTeam. Make sure that you remove any suffixes from the address (e.g. Default.aspx).

  1. Once you have entered the necessary information, please click [ Log In ] to authenticate with the server. If the login information is invalid, you will see an error message appear, otherwise you will be connected and the list of projects and artifacts will be populated.

Choosing the project and artifact

Once you have successfully connected to SpiraTeam, you should now choose the appropriate Project and Artifact in the system to which you will be importing into SpiraTeam. As you make your selections more buttons will be enabled.

After the project and artifact have been selected both buttons below these dropdowns should now be clickable. One let's you start entering data to send to SpiraPlan, the other gets data from SpiraPlan.

Preparing your Template

The SpiraTeam Google Sheets Integration add-on dynamically generates a template for each artifact with the click of a button. After a valid project and artifact have been selected the [ Prepare Template ] button will be enabled. Click this button to generate the required template on the currently selected sheet.

Warning: make sure no data on this sheet is needed as the entire sheet will be wiped

Filling in The Template

The above template is for requirements. Fields which have list of values to select from have dropdowns to make choosing the right values easy.

For an artifact to be created successfully in SpiraPlan it has to have certain fields filled in. These required fields are highlighted in bold black text. For example, the above screenshot is for requirements, where both the Name and Type field are required.

Different artifacts have different factors to take account of when entering the data:

Below is a partially filled in test case with test steps template -- it is visually easy to see which rows are steps to which case.

Import Into SpiraPlan

Before importing new artifacts, make sure that you're on the correct tab and the dropdowns in the sidebar show the correct project and artifact type.

After the correct/required fields have been entered, click the [ Send to SpiraPlan] button to send your data to SpiraPlan®. You will see a popup showing overall progress.

When the artifact has been successfully created an ID number will be placed in the ID column. This is the ID straight from SpiraPlan.

If there are any errors for a particular row (eg if required fields have not all been filled in, or if there was some other problem with the data or on the SpiraPlan server) that row will be highlighted with a comment in column A explain the problem.

For hierarchical artifacts (ones with parents and children), the import process will stop as soon as any error is found, to ensure SpiraPlan does not create an incorrect hierarchy

Get data From SpiraPlan

To get all the data for the specified project and artifact from SpiraPlan, instead of going through the steps outlined in Preparing your Template to Import Into SpiraPlan above, click the [ Get From SpiraPlan ] button. This will first load up the template on the current sheet then automatically retrieve all data from SpiraPlan and add it to the sheet.