Some studies use long lists of options, such as countries or medications, often in
dropdown fields. Instead of adding these options one by one, you can import the whole
option group from a CSV file.
Before you start
Prepare your CSV file:
- Save the file in .csv format, with no header row.
- Put the option names in the first column and the option values in the second column.
- An option group can contain up to 15,000 options.
- If your option names or values contain special characters (for example é, ü or 中文), save the file as CSV UTF-8.
Example: column A contains the option names and column B the option values.
Import an option group
Note: Import option group is disabled for live and linked studies.
- Go to Study design → Option groups.
- Click the three dots (⋮) next to Add, at the top right.
- Click Import option group.
- In the Import option group window, fill in the details:
- Name (required): the name of the option group, for example Language or Countries. Option group names must be unique within your study.
- Description (optional): for example, why you created the option group or where it's used.
- Layout (required): Vertical shows the options below each other, and Horizontal shows them next to each other. This only applies to checkbox and radio button fields.
- Import file (required): click Choose file and select your CSV file.
- Click Import.
When the import is complete, you will see the message Successfully imported option group, and the new option group appears in the list.
Troubleshooting
- Special characters look wrong after the import: save the file as CSV UTF-8 and import it again.
- The import fails because of the name: each option group name must be unique within your study. Choose a different name.
- The import also fails when:
- A name or value contains HTML characters such as & < >
- When a row does not have exactly two filled columns.
Comma, semicolon and tab separators are detected automatically.