Importing indicators into a qualitative page

5 min read · Updated 2026-10-30

In a qualitative page, participants use a scale to answer your question for a set of items in a table. This article shows how to add these items to your page, one by one or from a .csv file.

Overview

The items can be indicators, criteria, strategies, policies or whatever you want your participants to rate. In Welphi, we use the term indicators for these items.

The list of indicators can include just a few items or a large number. In any case, you can insert your indicators in two ways:

  • Manually – one by one, with the "ADD INDICATOR" button.
  • Automatically – from a .csv file, with the "IMPORT INDICATORS" button.

When setting up a qualitative page, you will see both buttons at the bottom of the screen.

IMPORT INDICATORS and ADD INDICATOR buttons
Add/import items buttons

Insert indicators manually

To insert indicators manually (i.e., one by one), click the "ADD INDICATOR" button for each item to be added. This opens the "Indicator settings" window.

The Indicator settings window

In this window you set:

  • Name – you can format it, and add links or images to it.
  • Description – the indicator's description.
  • "Required Answer" – whether an answer is required.
  • Custom indicator fields – if you have previously created custom indicator fields, you will also be able to fill in that information for the indicator.
The Indicator settings window
Indicator settings window

The indicators list

By filling in the appropriate information and repeating these steps for 10 items, you will end up with a list like the one below.

Items list after adding 10 items
Items list after adding 10 items

Upload indicators from a .csv file

When you have a large list of elements to insert into Welphi, you can use the upload feature through the "IMPORT INDICATORS" button. All you need to do is to organize all your indicators in a CSV file format.

1. Prepare your Excel file

To create your .csv file, you will probably start with an Excel file and then export your data into a .csv file. To properly format your Excel file (and later save it as .csv), follow these simple steps:

  1. Make sure that the first row of the Excel file contains the column headers. You need to have at least two columns in your file, labeled as: "name" and "description".
  2. Insert your indicators' names in the first column.
  3. Insert your indicators' descriptions in the second column.

    Note: Even if you don't have descriptions for your indicators, you still need to have this column and its header, leaving all cells empty.

  4. If you also want to import additional fields of information, just use the third column and onwards (one column per field). Don't forget to also add the column header for each field.

Excel file example
Excel file example

Template files

To make it easier to create your .csv files, you can download one of our template Excel files:

2. Save it as .csv

Once you have your Excel file ready, you just need to save it, selecting "CSV UTF-8 (Comma-delimited) (.csv)" as the file format.

"Save as..." file format
“Save as…” file format

3. Check the delimiter

Please keep in mind that despite the format name, Excel will decide whether to use a comma or any other delimiter based upon your computer language.

Because of this, always check the file delimiter used:

  1. Open the newly created .csv file with a text editor.
  2. Check which character is being used to split the information in the first row.
example of .CSV file opened with a text editor
example of .CSV file opened with a text editor

4. Import the file

Now that you have created your file and made sure which delimiter is being used, you can start uploading your .csv file.

  1. Click the "IMPORT INDICATORS" button at the bottom of the page to open the dialogue box.

    Import items dialog
    Import items dialog
  2. Click the "Choose file" button and locate your CSV file on your desktop.

  3. Once you have selected your file, type the delimiter character being used in your .csv file into the "Csv Delimiter" box.
  4. Decide whether you want to delete the indicators already on your page ("DELETE ALL EXISTING INDICATORS").
  5. Click "IMPORT".
Import items dialog (filled)
Import items dialog (filled)

That's it! All your indicators were inserted and filled with the information on the file.

Note: you are still allowed to make edits to all your indicators or custom fields without the need to upload a new version of your CSV file.

Existing custom fields

Important: Although you can set Welphi to delete any indicators already existing in your page when uploading new ones, you can't do the same with the "custom fields" already existing in your page, even if you are about to upload a file with the same custom fields. Therefore, please make sure you delete any "custom fields" already existing in the page.

After adding your indicators

Regardless of the way you choose to insert the indicators and their data, you can now see:

  • a list of all the indicators on the right-hand side of the screen;
  • the list of "custom fields" on the left-hand side panel, under "Indicator custom fields".

To learn more about setting up the page, see Setting up a qualitative (fixed scale) page.