Overview
This page describes how to create an Excel workbook with subject data so it can be imported into a project.
Required Role(s)
- Project Management (required to import data)
Steps
- The first row of the worksheet(s) must contain the variable codes
- Subject data is listed on rows 2 and greater
- When importing categorical variables (radio buttons or pick list type variables) use the pick list values, not the pick list name
- Import Universal or Project Variables for subjects
- The worksheet name must be Subject
- Required column headings (variable codes)
Tip See the list of System Variables that can be imported
- ReferenceID*
- SiteCode*