Is it possible to use the Qualtrics API or some other method to have Excel connect to the Qualtrics database to extract response data? I am trying not to use the Export/Import feature to get data into Excel. I would like for an Excel macro to query the Qualtrics response data and pull data into Excel.
Thanks in advance.
Chuck
Solved
Using Qualtrics as a Data Source for an Excel document
Best answer by TomG
SedonaFlute ,
Because retrieving responses is a 3-step process using the Qualtrics API, it would be difficult to do it directly from Excel. You can write a web based script that uses the Qualtrics API to get the responses, then from Excel write a VB script to call your web based script.
+22If you are looking at some automated method of exporting data then you can use export automation option in data and analysis
+4Using Qualtrics API, this can be achieved I guess, please go through the link below, if this is what you are looking for,
https://api.qualtrics.com/api-reference/reference/legacyResponseImportsExports.json/paths/~1responseexports/post
+27SedonaFlute ,
Because retrieving responses is a 3-step process using the Qualtrics API, it would be difficult to do it directly from Excel. You can write a web based script that uses the Qualtrics API to get the responses, then from Excel write a VB script to call your web based script.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.