Import Data
The Import Data page lets you bulk-upload submissions into a form schema from an .xls, .xlsx, or .csv file. A three-step wizard — Upload file, Map fields, Result — guides you through uploading the file, mapping its columns to the form's fields, and reviewing the outcome.

Access the Import Page
- Navigate to the Forms list and select a form schema.
- From the form's data view, click Import forms in the toolbar.
Step 1 — Upload File
The first step shows a drag‑and‑drop zone or a file picker.
- Accepted formats:
.xls,.xlsx,.csv - Maximum file size: 20 MB
To upload:
- (Optional) Leave Reuse existing metrics with the same name checked (the default) so that any metric in the file whose name matches a metric already in the system is linked to that existing metric instead of creating a duplicate. Uncheck it to always create new metrics.
- Drag a file onto the dashed area or click Choose a file to browse.
- Once the file has been read, the wizard moves to Map fields by itself.
Formatting the import file
See the description in the section below
Easy File formats
Dino accepts the same file obtained during the export. So, the easiest way to obtain a file properly formatted for import, is to first export some form data from the same schema and then delete the raws containing the exported data, keeping only the column headers. In any case, ensure your column headers are clear – they will be used as suggestions during mapping.
Metrics identified by ID
If a metric column in your file provides the metric's ID (UUID), that row is linked to the existing metric with that ID and no new metric is created. The ID takes precedence over the metric name, so this happens regardless of the Reuse existing metrics with the same name option (which only applies to matching by name).
Step 2 — Map Fields
After uploading, you see a table listing all columns from your file. Each row has three columns:
- File column – the original header from your file.
- Field – a dropdown where you select the corresponding form field.
- Status – shows whether the column is mapped, ignored, or has an error.
Mapping Actions
- Select a form field – open the dropdown for a column and choose the correct field. You can search within the dropdown.
- Ignore a column – select the — Ignore this column — option in the dropdown, or click the Ignore button in the status column. Ignored columns are grayed out.
- Restore an ignored column – click the Restore button in the status column.
Automatic matching
When the file is read, Dino maps every column whose header is exactly the name of a form field, or the name of a repeating field followed by __N (see Repeating slides). The other columns are left for you to map.
Click Re-match all to reset every column and let Dino match them again, this time also pairing columns with fields whose names or labels are similar. Review the result and adjust the mappings as needed.
Matching works best with headers that are the field names, as in an exported file.
Repetition
If a selected form field is a repeating field (e.g., multiple phone numbers), a Repetition input appears below the dropdown. Enter the repetition index (0, 1, 2, …) to assign this file column to one occurrence of the repeating group.
Toolbar Summary
At the top of the mapping area, you can see three chips:
- Total columns – number of file columns.
- Mapped – columns that have been assigned to a form field.
- Ignored – columns you chose to ignore.
Use the Search columns… input to filter the table by file column name.
Click Back to return to the upload step: the file and the mappings are discarded, and you choose the file again.
When all desired columns are mapped and no errors exist, the Apply import button becomes enabled. Click it to start the import. While processing, a spinner appears.
Duplicate mapping
If you map the same form field to more than one file column, a validation error is shown (Field mapped to more than one column) and the Apply import button remains disabled until corrected.
Step 3 — Result
The last step reports what happened:
- A banner tells you whether the import was successful, partial (some rows were rejected) or ended with an error (nothing was imported).
- Counters show Rows imported, Rows rejected, Rows in file and Metrics created.
- The issue lists show the affected file rows and the reason. Use Search by row or error to filter long lists.
Click Close to return to the form's data list, where the new submissions appear. After an error, Back takes you back to the mapping step to fix the problems.
File format
We describe the procedure to import some bulk data using a Google Sheet generated Excel file. The same procedure holds for CSV files or if working directly with Excel.
We suppose that you want to import data in a form called Projects that has 2 slides, one of which is a repeating slide:

The form Projects was created using the following XLSForm. The “survey” sheet is
| type | name | label |
|---|---|---|
| begin group | start | Start |
| select_one countries | country | Country |
| select_multiple countries | country_other | Other Countries |
| text | title | Project Title |
| date | project_date_start | Start date |
| select_one donors | selected_donor | Donor |
| integer | budget | Budget |
| boolean | isleader | Leading applicant |
| end group | ||
| begin repeat | indicators | Indicators |
| text | indic | Indicator description |
| integer | value_indic | Value reached |
| end repeat |
and the “choices” is
| list_name | name | label |
|---|---|---|
| donors | ue | UE |
| donors | govita | ITALIAN GOVERNMENT |
| donors | un | UN |
| donors | pub | ALTRI DONATORI PUBBLICI |
| donors | la | ENTI LOCALI |
| donors | priv | DONATORI PRIVATI |
| donors | other | Others |
| countries | AFG | Afghanistan |
| countries | ALB | Albania |
| countries | DZA | Algeria |
| countries | ASM | American Samoa |
Follow these steps:
- Create an empty file with only one sheet (file and sheet names do not matter).
- In the first row you need to put the names of the form fields and of the DINO-specific form fields. In this example, form fields can be:
- country
- country_other
- title
- project_date_start
- selected_donor
- budget
- isleader
- indic (*)
- value_indic (*)
be careful that fields which are within repeating slides need to be treated differently (that’s why we put an asterisk). Please refer to the specific section below.
DINO-specific fields can be:
- created_at. The form creation date. Specify this, only if you want your forms to have a creation date different from the import date;
- user_data_ref_id. The ID of the user that will be associated to the form. It is applied only when an administrator imports; for other users the value is ignored and the forms are assigned to the user who is importing them;
- area_id. The ID of the metric AREA to be associated with the form;
- [area_name]
- case_id. The ID of the metric CASE to be associated with the form;
- [case_name]
- project_id. The ID of the metric PROJECT to be associated with the form;
- [project_name]
- [project_code]
- location_id. The ID of the metric LOCATION to be associated with the form;
- [location_name]
- organization_id. The ID of the metric ORGANISATION to be associated with the form;
- [organization_name]
- form_status_name. The name of one of the form schema's statuses. Rows without it get the schema's first status. If any value does not match an existing status name, the file is not imported (Invalid form status);
-
dinoinvalid. Marks the form as invalid. Use
true,1,yes,yorx; any other value or an empty cell leaves the form valid. -
every row will correspond to a different new form. So, if we create a file with one header +, let’s say, 5 rows of data, if the upload is successful, we will create 5 new forms in DINO.
- It is not necessary to have a column for every field of the form; it is not necessary to fill all rows of a given column, but If one field is empty for all rows, it can be left out,
- Date fields must be formatted YYYY-MM-DD as text (be careful).
- Single choice fields must contain one of the accepted options as specified in the “choices” (see the form builder or the XLSForm file).
- Multiple choice fields must be formatted according to the following pattern: [opt1, opt2] (i.e. a list of options in square brackets).
For example, a valid file could be the following:
| country | country_other | title | project_date_start | budget | isleader | area_id |
|---|---|---|---|---|---|---|
| ALB | [AFG,DZA] | Human rights in education | 2022-01-28 | 120000 | true | 81387ff7-5c7d-44e7-9dc6-76b8d09265ac |
| ASM | A new approach to social justice | 2022-02-14 | 20000 | 81387ff7-5c7d-44e7-9dc6-76b8d09265ac |
In this case we are importing 2 forms, for both of them we are selecting only the metric AREA. Moreover, notice that we do not provide all form fields for all forms, but for the fields where we provide a value, we strictly follow the indications described above.
Dealing with metrics during import
During the import of some form data, as far as metrics are concerned, you might want to:
- create new metrics during the import
- reuse metrics already created
The rules to follow to correctly manage metrics are the following:
| METRIC | CREATE FROM UI | CREATE FROM IMPORT | CREATE + ASSIGN FROM IMPORT | USE FROM IMPORT | CREATE + ASSIGN FROM IMPORT (parent) | USE AS PARENT |
|---|---|---|---|---|---|---|
| Case | name | name | name | id, or name (with the reuse option), or both | name, in another row of the same file | id or name |
| Organization | name | name | name | id, or name (with the reuse option), or both | name, in another row of the same file | id or name |
| Location | name | name | name | id, or name (with the reuse option), or both | name, in another row of the same file | id or name |
| Area | name | name | name | id, or name (with the reuse option), or both | name, in another row of the same file | id or name |
| Project | name, code | name, code | name, code | id, or name (with the reuse option), or both | name and code, in another row of the same file | id or name |
When a row has both the id and the name of a metric, the id wins and the name is ignored. A new metric is created only when the name is given and the id is empty.
Parents are set with the <metric>_parent_id and <metric>_parent_name columns (for example location_parent_name), and only apply to metrics created by the import. The parent must be of the same metric type, and either already exist or be created by another row of the same file, in any order. A parent that matches nothing is not created: that metric is reported as metric with invalid parent.
Repeating slides
If you have field in repeating slides, they need to be named differently. Every field in the repeating slide need to be called \<field_name>__X where X is the repetition number, from 0 (corresponding to one repetition) to N-1 where N is the total number of slide repetitions in that form.
For example, suppose you have only 1 repetition of the repeating slide and you want to add both fields “Indicator description” and “Value reached”. You would need to add these two columns to your import file:
| indic__0 | value_indic__0 |
|---|---|
| Number of children | 100 |
So for example we could have:
| country | budget | indic__0 | value_indic__0 | indic__1 | value_indic__1 | isleader |
|---|---|---|---|---|---|---|
| ALB | 120000 | Children | 100 | true | ||
| ASM | 20000 | |||||
| AFG | 15000 | Parents | 45 | Schools | 34 | true |
Errors
- Unknown IDs – if a column refers to a user or a metric by an ID that does not exist in Dino, the whole file is not imported (File not imported!), and the result lists the Invalid user ids or Invalid metric ids. Check the IDs in your file before importing.
- Unknown form status – a
form_status_namethat matches no status of the schema stops the import too (Invalid form status). - Metrics that cannot be linked – a row that names a metric Dino cannot create or find is rejected, and the result shows the reason; the other rows are imported.