Creating a survey programmatically (or from a spreadsheet)? | XM Community
Skip to main content
Question

Creating a survey programmatically (or from a spreadsheet)?

  • July 8, 2023
  • 3 replies
  • 1539 views

Forum|alt.badge.img+2
  • Level 1 ●
  • 1 reply

Is there any straightforward way to create a survey programmatically (e.g. using python) or via a spreadsheet-based question-import format?  (Note that I’m talking about questions, not data/responses.)  To take a very silly but concrete example, imagine I had 200 countries enumerated in a spreadsheet and I wanted to create a 200-question survey where for each country, the question is: “Have you ever visited <country> (yes/no)”?  How can that be done without creating 200 questions in a survey manually? (This is rather analogous to creating HITS on Mechanical Turk from a CSV file, https://blog.mturk.com/using-csv-files-to-create-multiple-hits-in-the-requester-ui-22a25ec563dc.) I’ve explored writing a program to create a QSF file that can be imported, but it’s a pretty unfriendly format. 

Apologies if I’ve missed something obvious, but I’ve done some searching around and not found a solution. Thanks for any thoughts!

3 replies

Deepak
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+46
  • 1555 replies
  • July 9, 2023

@PSR 

If you can loop API call based on 200 countries in python. You can use this API (api.qualtrics.com/5d41105e8d3b7-create-question)

Hope it helps!


Appzk
QPN Level 5 ●●●●●
Forum|alt.badge.img+34
  • QPN Level 5 ●●●●●
  • 276 replies
  • July 9, 2023

Qualtrics can create survey imported via word doc if it is in desired format. 


Forum|alt.badge.img+2
  • Author
  • Level 1 ●
  • 1 reply
  • July 9, 2023

Thanks to @Deepak and @Appzk for the quick replies!  Looks like for me, at least, the simplest solution to try will be to write some python code to create a text or Word document and then just import it. In case others find themselves here with the same question, the relevant link for Appzk’s suggestion is https://www.qualtrics.com/support/survey-platform/survey-module/survey-tools/import-and-export-surveys/.