Skip to main content
Loading...
Skip to article
  • Qualtrics Platform
    Qualtrics Platform
  • Customer Journey Optimizer
    Customer Journey Optimizer
  • XM Discover
    XM Discover
  • Qualtrics Social Connect
    Qualtrics Social Connect

Load Responses to Survey Task


Was this helpful?


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The feedback you submit here is used only to help improve this page.

That’s great! Thank you for your feedback!

Thank you for your feedback!


About the Load Responses to Survey Task

The Load Responses to Survey task allows you to load data from other data sources into a Qualtrics survey. To use this task, you must first load data into Qualtrics using a data extractor task.

Creating a Load Responses to Survey Task

To use this feature, you’ll first create a new scheduled workflow with a data extractor task. Then you’ll add the Load Responses to Survey task and configure it. Finally, you’ll complete your workflow by mapping each field in your data source.

  1. Create an ETL workflow.
  2. Select Data source (ETL extractor). In this step, you’ll extract data that you can load to another destination. See using Building ETL Workflows for more information.
    Adding an extractor to an ETL task

    Attention: You must set up an extractor task that produces a CSV or TSV file to use the Load responses to survey task.
  3. Click Add a data destination.
    In the ETL workflow, there's a place to add data transformations, then a place to choose what happens next; click Add a data destination
  4. Select the Load responses into survey task.
    new window where you can select tasks, load responses to survey is highlighted
  5. Click the dropdown to choose a data source to import to the survey. This will be the data source you configured in your extractor task.
    Window where task is configured, data source and destination project selected
  6. Select a destination survey project. This is the survey your data will be loaded into.
    Attention: We advise using a standard survey project as your destination. We do not recommend using other project types, such as Employee Experience projects. If you’d like to load data to an imported data project, see the Load into a Data Project task.
  7. Click Next.
  8. Select the default time zone.
    setting date formats and mapping fields
  9. Select a date format.
  10. If you have header rows in your data source, enter the row your data starts at.
    Example: If you are using an Extract Responses From a Survey task, your data will start at row 4.
  11. Map your source data to your survey fields. Click the Source field dropdown to select a field from your source dataset.
    Attention: The JAWS screen reader may produce incorrect text while navigating this table due to an issue with JAWS.
  12. Click the Destination survey field dropdown to select the corresponding field in your survey dataset.
    Qtip: Fields will be mapped automatically if there is a name match in your source data and destination data.
  13. Click Add Field to add additional fields.
    Qtip: If you want to delete a field, select the 3 horizontal dots and click Delete row.
  14. To map values for an individual field, select the 3 horizontal dots to the right of the field and select Map values.
    dropdown next to a field then Map Values highlighted from menu
  15. Enter your source field name in the left text box, and your data project field value in the right text box. The data project field value is the value that will be present in your destination survey data.
    mapping fields

    Qtip: You can also upload field mappings. For more details, see Mapping Field Values.
  16. Check Map all unmatched values to a default value if you want any unmapped values to be mapped to the same default value.
  17. If you selected Map all unmatched values to a default value, type a name for your default value in the text box.
  18. Select Add Row to map additional values.
  19. When your values are mapped, click Done.
  20. Once all your values are mapped for each field, click Save.
    Qtip: All required fields must have a source field mapped to them before you can click Save.
  21. Make sure your workflow is enabled.
    Qtip: You can also turn the workflow on from the Workflows page.
    enabling a workflow from the workflows page