Adding variables via CSV | XM Community
Skip to main content

Adding variables via CSV

  • November 15, 2022
  • 4 replies
  • 378 views

MikeBot
Level 2 ●●
Forum|alt.badge.img+8

Hi all, I have a survey which has a respondent ID (RESPID) for each case, and all associated data for each respondent.
Am I able to import a new variable (for each existing respondent) via CSV file, and match to the survey using RESPID?
I.e. my CSV file to import has 2 columns:

  • RESPID (one for each respondent in the survey)

  • NEWVAR

All I want is NEWVAR added as a new variable after I merge the data - data should be matched using RESPID.
Thanks, Mike.

4 replies

Deepak
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+46
  • 1555 replies
  • November 15, 2022

MikeBot
You can do this via API. (https://api.qualtrics.com/daed82306b1ea-update-response).
If you direct import your variables the data would not merge and would create additional responses.
Hope it helps!


MikeBot
Level 2 ●●
Forum|alt.badge.img+8
  • Author
  • Level 2 ●●
  • 15 replies
  • November 15, 2022

Hi Deepak ,
Thanks for your response! Unfortunately that seems a little out of my skill set at present, haha!
I actually have no idea what an API is...
How do I use it?

thanks, Mike.


Deepak
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+46
  • 1555 replies
  • November 15, 2022

MikeBot
Unfortunately if you're not aware of it you wouldn't be able to do it. On other hand the other way is you can export all responses delete them include a additional variable as needed and import the responses.
Qualtrics does have support pages on API to learn more.
Hope it helps!


MikeBot
Level 2 ●●
Forum|alt.badge.img+8
  • Author
  • Level 2 ●●
  • 15 replies
  • November 15, 2022

Deepak - thank you mate, much appreciated!