Prepping Your Structured Data for Upload

Before uploading structured data, you’ll need two properly formatted CSV files:

1. Data Map – defines your questions and variables and should be formatted as follows:

Single Select: Question variable name: Question text

Open End: Question variable name: Question text

Q2: What is your favorite fruit?

Open text response

Multi-Select: Question variable name: Question text || Response Option

Q2: Please select your top three favorite fruits from the list below. \|\| Apple
Values: 0-1
	0	Unchecked
	1	Checked

Single Select Grid: Question variable name: Question text || Row

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: Question variable name: 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
Values: 0-1
	0	Unchecked
	1	Checked

2. Dataset – contains the actual respondent-level data and should be formatted as follows:

The first row of dataset should contain the question headers (e.g., D1:, Q1:, Q5R2:, etc.)
Subsequent rows in the dataset should contain respondent answers either numerically or text-based. Each row denotes a new participant.

Have questions or need a template? Contact your Panoplai rep or support@panoplai.com