Populating response data from an Excel file | XM Community
Skip to main content
Solved

Populating response data from an Excel file

  • August 31, 2018
  • 5 replies
  • 25 views

I would like the users of a survey to populate survey response data from an Excel file. Is this possible? If not, can a field within a survey be populated using javascript or jQuery? I know a file can be uploaded to a survey, but I want the data within the uploaded file to automatically populate the response data. Please provide an example on how this can be done. Thanks!

Best answer by PeeyushBansal

I don't think a user can do this at real time, you have to do it as a bulk upload

5 replies

PeeyushBansal
Level 6 ●●●●●●
Forum|alt.badge.img+43
  • Level 6 ●●●●●●
  • August 31, 2018
You can do this by uploading csv in legacy or you can use API web service or postman to upload file.

  • Author
  • August 31, 2018
This does not allow the user of the survey to directly upload the survey responses.

  • Author
  • August 31, 2018
The uploaded file will still need to be imported into the survey responses. Is there a way that the user can perform this process?

PeeyushBansal
Level 6 ●●●●●●
Forum|alt.badge.img+43
  • Level 6 ●●●●●●
  • Answer
  • August 31, 2018
I don't think a user can do this at real time, you have to do it as a bulk upload

AnthonyR
Level 4 ●●●●
Forum|alt.badge.img+7
  • Level 4 ●●●●
  • August 31, 2018
@kpyles Unfortunately respondents can't upload data using a csv by default. Though you couldf have them upload a csv for a different study and use the api to make calls to upload this data. That is probably the best you can do. And it would require quite a bit of setup at that.