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

Using Qualtrics as a Data Source for an Excel document

  • July 9, 2020
  • 4 replies
  • 1423 views
S

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

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.

    4 replies

    rondev
    Level 6 ●●●●●●
    Forum|alt.badge.img+22
    • rondev
    • Level 6 ●●●●●●
    • July 9, 2020

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

    Ron Dev (DM for any request. XM Technology Consultant, surveysolution.in)
      S
      • SedonaFlute
      • Author
      • July 10, 2020

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

      SurajK
      QPN Level 3 ●●●
      Forum|alt.badge.img+4
      • SurajK
      • QPN Level 3 ●●●
      • July 10, 2020

      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

      TomG
      Level 8 ●●●●●●●●
      Forum|alt.badge.img+27
      • TomG
      • Level 8 ●●●●●●●●
      • Answer
      • July 10, 2020

      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.

        Terms & ConditionsAccessibility statement