All Collections
Data Loading and Processing
Data Loading
Dictionary for coding in Excel format
Dictionary for coding in Excel format
Updated over a week ago

Required system role 'Coder'. The role should be granted to a user account to enable this functionality.

You can use dictionaries for coding open-ended questions. It is an extremely effective instrument to eliminate repetitive work.

Once you coded titles, you can save your work as a dictionary to reuse for coding of subsequent waves or other surveys.

The layout of a dictionary file

Dictionaries can be exported to and imported from Excel files. The layout of the file is shown below:

  • The first cell in a row of the Excel table contains a proper notation for a title

  • The second and subsequent values in a row enumerate alternative spellings or synonyms that are to be mapped into the correct one.

Layout of a coding dictionary in Excel format

Requirements for the file

  • It is assumed that your file contains a single Excel sheet. Otherwise, DataTile selects the first one for loading

  • No empty rows - DataTile parses the table till the first empty row. All rows following an empty one will be ignored

Sharing a dictionary with colleagues

Dictionary is another type of file in My Space that can be shared with collaborators.

It has the standard set of sharing permissions as follows:

  • View - allows collaborators to apply the shared dictionary to code open-ended questions in their projects

  • Share - 'Share" permission + grants collaborator the right to update contents of the dictionary

  • Edit - 'Share' permission + grants collaborator the right to update contents of the dictionary

Did this answer your question?