Preparing and importing your data in Dedoose is one of the most important parts of having a productive project. Without data, there is nothing to interact with or analyze. This article will explain how to set up a spreadsheet with your code tree information to import it into Dedoose.
You can always manually set up your codes within Dedoose by clicking the ‘Edit Codes’ icon in the code tree panel header and then clicking the ‘Add Root Code’ icon.
But what if you have so many codes that it would just take too long or you already have the code information stored in a spreadsheet that someone exported from Dedoose or that you worked up directly in Excel?
This is an example of what the spreadsheet may look like if exported from Dedoose and the required format for importing to a Dedoose project.
Let’s break it down:
Id column – This is a sequential identification number that needs to unique identify each code.
Parent Id – This column will store the Id number for the associated Parent/Root code if the particular code is a Child/Subordinate of another. This is what creates a hierarchical structure.
Depth – This tells Dedoose at which level in a hierarchy the code lives. Note the following:
- A parent code always has depth 0
- A child code will have depth 1
- A grandchild will have depth 2 and so on and so forth.
Title – This is the name of your code.
Description – This is a short optional description of your code that will show up as a smart tip when you float your cursor over the code in Dedoose.
Weighted – This tells Dedoose if your code has an associated weighting/rating system (‘True’ where you have one defined or ‘False’). The subsequent columns describe your weighting system:
- Weight Minimum – the minimum value for the range of the scale
- Weight Maximum – the maximum value for the range of the scale
- Weight Default – this is the default value that will be initially assigned initially when the code is applied to an excerpt.