Start a conversation

Import grid field data

It is now possible to import grid field data into Castor.

When a grid field is exported, each grid cell is exported as its own column, which is labeled  as Variablename_rowname_columnname. This is the way the grid data should be prepared for import as well.

An example of this can be seen here. We have a grid field with the variable name 'grid_test' containing 3 rows, 'Hip', 'Knee' and 'Ankle' and 2 columns, 'Left' and 'Right'. The configuration shows that each cell contains a 'number' field. 

Our spreadsheet, prepared for import, contains a column for each grid column and row:

Once prepared for import, we save the file as CSV and import into the study:

In this case numerical data is shown. If you are importing dates, make sure the date is formatted properly, i.e. in the format dd-mm-yyyy. Dropdowns should contain the respective option value. 

For more information on importing spreadsheet data, see the article Import study data.

Choose files or drag and drop files
Was this article helpful?
  1. Castor Support Team

  2. Posted
  3. Updated