Using Qualtrics as a Data Source for an Excel document | XM Community
Skip to main content

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

If you are looking at some automated method of exporting data then you can use export automation option in data and analysis

Thanks Ron,
I am actually looking to pull response data from Qualtrics into Excel.

Using 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

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.

Leave a Reply


Terms & Conditions