Can Qualtrics auto populate answers from an excel sheet? | Experience Community
Skip to main content
Solved

Can Qualtrics auto populate answers from an excel sheet?

  • April 29, 2021
  • 1 reply
  • 875 views
A

I have an excel list of specific job codes with other data attached. For instance position 1234; Department ID: 07; Program Name: Accounting. I want to create a survey, if you enter the position code (1234) it would auto populate the rest of the position information into the survey. Seems like this excel must be hosted on Qualtrics so it can be referenced when someone inputs a position number. I believe this excel can be uploaded into qualtrics, but is it possible to auto populate information from the row (based on the position code) into the survey? if so, how? Thank you!

Best answer by AmaraW

Hi aquinoc2! It sounds like a Drill Down Question may be what you're looking for - you can upload an excel sheet to map the different options, and depending on the setup of your excel document, it will fill in the corresponding information you would need. If you have any follow up questions, please be sure to reach out to our Support team, as they are best equipped to help!

1 reply

AmaraW
Former XM Community Team Member
Forum|alt.badge.img+48
  • AmaraW
  • Former XM Community Team Member
  • Answer
  • May 21, 2021

Hi aquinoc2! It sounds like a Drill Down Question may be what you're looking for - you can upload an excel sheet to map the different options, and depending on the setup of your excel document, it will fill in the corresponding information you would need. If you have any follow up questions, please be sure to reach out to our Support team, as they are best equipped to help!

Terms & ConditionsAccessibility statement