Skip to main content
Loading...
  • Customer Experience
    Customer Experience
  • Employee Experience
    Employee Experience
  • Brand Experience
    Brand Experience
  • Product Experience
    Product Experience
  • Core XM
    Core XM
  • Design XM
    Design XM

Importing Data as a CX Dashboard Source

What's on This Page:


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 data sets 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

  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 Settings in the editing bar.
    clicking settings 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.

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

Dashboards used to allow CSV files to be directly uploaded inside the Dashboard Data. If you used to have a CSV uploaded to your dashboard as a source, this source will not be removed. You can also still edit your data mappings and field types as needed.

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 from which you want to export the CSV source.
    Choose Dashboard from Dashboard dropdown

    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 button.
    clicking the export button and then download dashbord

    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 back to the Projects page by clicking the XM logo in the top left corner of your account.
  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.