Importing data to Qualtrics | XM Community
Skip to main content
Michael_Cooksey
Administrator
19 days ago
Question

Importing data to Qualtrics

P
Forum|alt.badge.img+2
I have an Excel file with data that I would like to import to an existing Qualtrics survey. I have coded all of the responses in the Excel file and everything is uploading fine except for the multiple choice questions where respondents could select more than one option. I need to know how to format those columns in Excel to get those responses to upload.

    9 replies

    AdamK12
    Level 5 ●●●●●
    Forum|alt.badge.img+59
    • AdamK12
    • Level 5 ●●●●●
    • 298 replies
    • March 6, 2020
    @psanders You should be ready to go -- if you already have it coded in Excel the system should import all of your columns as is. You may need to be creative when you're coding or recoding variables in StatsIQ but should be all set to import your responses and analyze them.
    Adam Korengold, NLM/SCI (he/him/his)
    P
    Forum|alt.badge.img+2
    • psanders
    • Author
    • 3 replies
    • March 6, 2020
    Everything does upload, except the data for multiple choice questions where the respondent can select multiple responses. Currently in the Excel file, each response for those questions is in a separate column, which I think should work, but doesn't seem to. I'm using the Legacy Importer.
    P
    Forum|alt.badge.img+2
    • psanders
    • Author
    • 3 replies
    • March 6, 2020
    @AdamK12 Everything does upload, except the data for multiple choice questions where the respondent can select multiple responses. Currently in the Excel file, each response for those questions is in a separate column, which I think should work, but doesn't seem to. I'm using the Legacy Importer.
    JustinD
    • JustinD
    • 32 replies
    • May 7, 2020

    Hi
    I am new to Qualtrics.
    I am trying to import csv file to use the data as possible embedded data (? I am not sure that is the right approach).
    For instance, I would like to import a table that updates Fiscal Year (having columns such as Year, Quarter, Month) that has 4 columns and 12 rows.
    Is is possible?
    Thanks in advance.
    Justin

    TomG
    Level 8 ●●●●●●●●
    Forum|alt.badge.img+27
    • TomG
    • Level 8 ●●●●●●●●
    • 5926 replies
    • May 7, 2020

    Justin_Doh,
    Your post is about a completely different subject than the original post. Please start a new thread.

    JustinD
    • JustinD
    • 32 replies
    • May 7, 2020

    Ok. Sorry. Thank you.

    S
    • ssarraf
    • 2 replies
    • December 9, 2020

    Did you ever figure this issue out? I'm struggling with the same thing. Thanks for any advice!

    JustinD
    • JustinD
    • 32 replies
    • December 17, 2020

    @ssarraf
    Yes.
    It has been working fine.
    I just have to structure a csv file in a way that each survey taker gets both frequencies and pointer to each survey questions horizontally. Then, this csv file becomes a Contact List (like a input table).
    After this structure is set up, those inputs (Frequencies and Pointer to each questions) become embedded data.
    Please see bottom image for reference.
    JD.pngHope this helps.

    K
    Forum|alt.badge.img

    Does anyone have any insight into the original question? I want to upload multi-select answers as a single Embedded Data field. Do I import multiple columns OR combine all answers into one column first? If the latter, how should I format it, with delimiters (preferably with a comma), so that Qualtrics recognizes the distinct separation of texts? Do I need spaces in between the commas for coding purposes (hair , skin , nails)? Or can it be imported as how it would normally be written (hair, skin, nails)? 

    Leave a Reply


    Terms & Conditions