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

Importing Data as a CX Dashboard Source


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 Importing Data as a CX Dashboard Source

Sometimes, you may want to create dashboards for datasets you built in Excel, or pull data from another software for reporting in Qualtrics. You can do this using an imported data project.

There are several benefits to using an imported data project as a source for your dashboard:

  • You don’t have to recreate a survey before you upload data into Qualtrics.
    Qtip: In fact, imported data projects are great for helping visualize operational data from outside Qualtrics in your dashboards.
  • Once you have an imported data project created, you can use it as a source in any of your dashboards.
  • Lots of files types are supported, including .xlsx, .csv, .tsv, .sav (SPSS), and .xls.
  • Unlike dashboards backed by a CSV file, the data can be periodically updated.

Uploading Data to a Dashboard

Qtip: Be thoughtful about the data you add to your dashboard. If there are sensitive fields you don’t want shown to users, consider excluding them completely from the dashboard data or adding them to a separate dashboard with limited access.
  1. Prepare the data you’d like to import to the dashboard.
  2. Create an imported data project and upload the file to it.
  3. In your dashboard, click the settings gear.
    clicking settings gear on a dashboard
  4. Navigate to the Dashboard Data tab.
    mapping the imported data project by going to dashboard data, clicking add source, and selecting the project in external datasources
  5. Click Add Source.
  6. Hover over External Datasources and select the imported data project you created.
  7. Click Save to save your new source into your dashboard.
    data is mapped, save button appears at the bottom

Once the imported data project is added as a source, the field types can be adjusted and its data can be added to widgets just like any other data source in your dashboard.

Converting Dashboard CSV Sources to Imported Data Project Sources

The ability to directly upload CSV files inside the Dashboard Settings will be removed on May 3, 2023. This feature is not currently available in new Qualtrics data centers launched after March 30, 2022. If you used to have a CSV uploaded to your dashboard as a source, this source will not be removed. You can still edit your data mappings and field types as needed, but cannot re-import the CSV file.

After May 3, 2023, you cannot update the CSV or import a new CSV source directly to the dashboard. We encourage you to use imported data projects (as described in the section above) instead. In the steps below, we’ll cover how to switch from a CSV source to an imported data project.

Warning: If you remove a legacy CSV source from your dashboard, this source will be permanently deleted. Once deleted, this data is irretrievable, so be sure to follow carefully the instructions below to ensure you do not lose access to your file.

Retrieving the Legacy CSV Data

Qtip: If you already have a copy of this data saved somewhere easily accessible, such as a drive or your computer, you can skip these instructions.
  1. Navigate to the dashboard you want to export data from.
    Image of the dropdown of dashboards at the top of every dashboard

    Qtip: If you have multiple sources mapped, add a filter that sets the Data Source to the CSV. Make sure no other filters are applied.
    Data source filter
  2. Click on the export icon.
    clicking the export button and then download dashboard

    Qtip: If you don’t see this option, make sure you have Can Export Dashboard enabled as a user permission or role.
  3. Select Download dashboard.
  4. Select the file type CSV.
    Export options window says file type csv, limit results 500, remove line breaks not selected, include filter results is selected
  5. Make sure the Limit Results field contains a number equal to or greater than the total number of responses in the source. You cannot leave this field blank.
    Qtip: If you needed to add a Data Source filter, make sure to select Include Filter Selection.
  6. Click on the Export button.

Uploading the CSV to a Dashboard

  1. Navigate to the Catalog.
    Global navigation is opened and "Catalog" is selected
  2. Create an imported data project with the CSV you exported.
  3. Follow the steps earlier on the page to add the imported data project as a dashboard source.