Importing missing data - can this be done with a subset of responses?

Question

I've recently closed a survey where almost half of the respondents did not manually provide their Country from a drop-down box.I've looked up their countries on a response-by-response basis and have a CSV file that maps ResponseID to the relevant respondent's Country.I now want to import the missing data back into Qualtrics, but I'm concerned about data integrity. Can I use the Import Data feature and map the ResponseID and Country fields so that only the ones without the Country information are affected, or will I need to run a full export of all the survey data, add the country information into that CSV, and then import it all?

MatthewM · Accepted Answer

https://community.qualtrics.com/XMcommunity/discussion/comment/40310#Comment_40310Agree with the above. Only thing I would add is that, if you can select the respondents that are in the same country, you could possibly save some time by following the Edit Multiple Responses instructions in that same link.

RachelG · Answer

I hope someone else has a better answer, but the only way I have found to do this is editing responses individually. There is a decent explanation here: https://www.qualtrics.com/support/survey-platform/data-and-analysis-module/data/response-editing/ One thing to pay particular attention to is that if you try to upload the responses back into the survey it will create duplicate responses with new response ID', so as far as I know neither option you explained will get you what you want. I would love the ability to be able to edit responses by importing data. Maybe you should submit that as a  product idea. I would vote for it.

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded