Error when importing external ZIP code data into Qualtrics

Question

Hi!

In order to analyze ZIP code data which respondents provided  (984 total), I had to first export the zip codes, standardize to ensure 5 digits ("0" added to less than 5 digit entries), and then use a vlookup formula to bucket them into two new buckets which we want to analyze by (NY Metro v Non-NY Metro) - see sample data below.

!

However, when I go to import the .csv file back into Qualtrics I'm unable to as it says 'No columns have been selected to important' (see below).  How can I upload this data so that I'm then able to analyze by these two new buckets?

!

Thanks in advance.

KendraR · Accepted Answer

Hi, @Beyond! I just wanted to jump in here and mention that both of these new fields will need to exist on the Qualtrics platform in order to import them. For your specific use case, I would recommend that you reach out to our Support Team so that they can walk through this process with you! &#128515;

Beyond · Answer

Hi!In order to analyze ZIP code data which respondents provided  (984 total), I had to first export the zip codes, standardize to ensure 5 digits ("0" added to less than 5 digit entries), and then use a vlookup formula to bucket them into two new buckets which we want to analyze by (NY Metro v Non-NY Metro) - see sample data below.!However, when I go to import the .csv file back into Qualtrics I'm unable to as it says 'No columns have been selected to important' (see below).  How can I upload this data so that I'm then able to analyze by these two new buckets? !Thanks in advance.

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded