Hi Margaret!
You've hit on a common frustration point! Currently, the Qualtrics Microsoft Excel Task is designed specifically for OneDrive for Business. While SharePoint and OneDrive live in the same tenant, the task doesn't officially support workbooks hosted directly on SharePoint sites.
As you've noted, there isn't a "plug-and-play" API solution to push data directly to a SharePoint-hosted Excel file. If your institution requires this, you're essentially looking at a custom middleware project. The general roadmap for that looks like this:
-
Use Qualtrics API (v3) to extract the response data.
-
Use a service like Microsoft Power Automate or a custom script.
-
Leverage the Microsoft Graph API to write that data into the specific SharePoint workbook.
A common workaround used by many in the community is to use a Web Service task in your Qualtrics workflow to send data to a Power Automate "HTTP Request" trigger. From there, Power Automate has native connectors to update Excel files on SharePoint, which bypasses the OneDrive-only limitation of the built-in Qualtrics task.
One thing to keep in mind: if you do go the custom route, watch out for file version history! Some users have reported that frequent auto-updates to cloud-hosted Excel files can cause the file history to balloon in size quite quickly.
For the most up-to-date technical specifics or to see if there have been any under-the-radar updates for your specific license, it's worth a quick ping to the Customer Success Hub. They can verify if any new SharePoint-specific connectors are in the early access pipeline for your brand: https://support-portal.qualtrics.com/ 📊
