Prepping Your Structured Data for Upload

When preparing to upload structured data into Panoplai, the first step is deciding whether to upload:

• Both a datafile and a datamap, or

• Just a datafile

Here’s how to choose the right option:

• Upload Both a Datamap and a Datafile: Choose this option if your dataset contains numeric data, such as survey responses coded as numbers (e.g., 1 = Yes, 2 = No). The datamap helps Panoplai interpret these numeric codes by linking them to their original question text and answer labels.
• Upload Just a Datafile: Choose this option if your dataset contains only text data, such as open-ended responses or already-labeled variables. In this case, a datamap isn’t necessary because the values are self-explanatory.

---

Once you've decided on your upload method, you'll need to format your datamap OR text-based datafile as follows per question type:

Single Select:

Column Header in Text Datafile: "Question variable: Question text" (Q1: What is your age?) 

Data Map Example:

Single Select Grid:

Column Header in Text Datafile: "Question variable & row: Question text || Response Option" (Q4r1: How satisfied are you with the fruit selection at your local grocery stores? || Apple)

Data Map Example:

Q4r1: How satisfied are you with the fruit selection at your local grocery stores? || Apple
Values: 1-5
	1	Extremely satisfied
	2	Somewhat satisfied
	3	Neither satisfied nor unsatisfied
	4	Somewhat unsatisfied
	5	Extremely unsatisfied

 

 

 

 

 

 

 

 

 

 

Multi-Select Grid: 

Column Header in Text Datafile: "Question variable & row: Question text || Row || Response Option" (Q4r1: You mentioned that you purchase the following fruits at least once a week. When do you consume each fruit? Select all that apply. || Apple || Breakfast)

Data Map Example:

Q4r1: You mentioned that you purchase the following fruits at least once a week. When do you consume each fruit? Select all that apply. || Apple || Breakfast
Values: 0-1
	0	Unchecked
	1	Checked

 

 

•  

 

 

---

Panoplai's system may read some questions separately and you'll have the opportunity to consolidate these when moderating the data. To avoid heavy-lifting in the moderation stage, please follow these tips and tricks when preparing your datamap:

1. Grid questions can be consolidated in the datamap as follows:
   
   

   Q4: How satisfied are you with the fruit selection at your local grocery stores?
   Values: 1-5
   	Q4r1	Apple
   	Q4r2	Orange
   	Q4r3	Kiwi
   	Q4r4	Mango
   	Q4r5	Banana
   	1	Extremely satisfied
   	2	Somewhat satisfied
   	3	Neither satisfied nor unsatisfied
   	4	Somewhat unsatisfied
   	5	Extremely unsatisfied

2. Recoding data may be necessary. Panoplai reads blanks as empty. Make sure your datafile has codes where data is present or your base sizes will vary across questions.
3. Any modifications made to data labels when consolidating in the datamap must also be reflected in the numeric-based datafile. 
4. If any question text or labels are missing, you can add that in using the survey builder after uploading.