In my survey, I am looking to ask the question "How much money would you give to these people?" with question choices being Person A and Person B. I want to import age and gender of Person A and B from a big Excel file and vary the combination of Person A and Person B for each survey respondent. Is there any way to do this? Many thanks in advance!

For sure! I totally understand that. And I agree that an Excel Spreadsheet would be a way faster way to get this done, but yeah, it's not supported yet. I'm trying to think of the best way to go about this, with the least amount of technical stuff. There are some clever ways to do this with code, but I'll rely on the platform as much as possible.What if you had an Embedded Data Field that was a Random Number between 1 and 10 (Qualtrics has that as an option for Piped Text, i.e. ` ${rand://int/1:10}`). Then, you could have a survey flow with logic in it saying, "If their number is equal to 1, then show them this block", for each number 1-10. Then, you could get some random variation in there. Like this: !I know that this is *definitely* not as flexible or dynamic as you would like, but it involves the least amount of technicality in my opinion. If you're willing to get your hands a little dirty with Javascript, let me know and I can walk you through it!

Will you have control of your respondents or will this be a survey that will be for a random sample? I'm by no means an expert on embedded data and Piped Text, but in my experience this has to be assigned to the respondent. If you have a distribution list you can use the embedded data/piped text to pull in the age and gender of Person A and Person B, but if you are purchasing respondents or having people use anonymous links then I don't think that would be possible. @Michael_Campbell_RedPepper ?

Is there a way to import data from an Excel file into a question response?

Is there a way to import data from an Excel file into a question response? | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded