How to Share Microsoft Forms Results with External Collaborators
Question details
The user needs to share Microsoft Forms responses with specific external collaborators without compromising the security of sensitive information.
- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- Sharing form results that contain sensitive school or medical information with an authorized person outside the organization.
- Observed behavior
- Microsoft Forms lacks a direct built-in feature to share response collaboration securely with specific external users.
Verify your organization's external sharing and data-protection policies to ensure you are authorized to share sensitive school or medical data with external parties.
Export Responses to Excel and Share Securely
The most reliable workaround is to download your form results into an Excel spreadsheet and manually share that file with the authorized external user.
Since Microsoft Forms restricts live response sharing to internal members, exporting the static data allows you to control exactly who sees the information and how it is transmitted.
Open your specific form in Microsoft Forms and click on the 'Responses' tab located at the top of the screen.
Click the 'Open in Excel' button to download a copy of all current form responses directly to your device.
Open the downloaded Excel file to verify the data. Once confirmed, share the file with the external collaborator via a secure, encrypted email or your organization's approved file-sharing platform.
Automate Responses to a SharePoint List
Use Power Automate to sync new form responses to a SharePoint list that allows controlled external guest access.
Manage and Share Exported Form Data Securely with WPS Office
While Microsoft Forms requires exporting data to bypass external sharing limits, you can easily view, manage, and protect these downloaded Excel files using WPS Office. WPS Office is a lightweight, free alternative to Microsoft Office that offers full compatibility and built-in document encryption.
- 1. Open the Exported File: Launch WPS Spreadsheet and open the .xlsx file you downloaded from Microsoft Forms.
- 2. Encrypt the Document: Navigate to the 'Menu' or 'Review' tab, select 'Document Encryption', and set a secure password.
- 3. Share with Confidence: Save the encrypted file and share it with your external collaborator safely.
Frequently Asked Questions
Can I share a live Microsoft Forms response link with external users?
No, Microsoft Forms does not currently support sharing live response collaboration links directly with specific individuals outside your organization. You must use workarounds like exporting to Excel or routing data through SharePoint.
How can I protect the exported Excel file containing sensitive form data?
You can add password protection to the Excel file before sharing. In your spreadsheet software like WPS Office or Excel, use the document encryption feature to require a password to open the file.
Does Power Automate require premium licenses to export form data to SharePoint?
Basic integration between Microsoft Forms and standard SharePoint lists generally falls under standard Microsoft 365 licensing, but you should verify your specific organizational license limits and sharing policies.
What should I do if my organization disables SharePoint external sharing?
If external sharing is disabled at the tenant level by your IT admin, you cannot use the SharePoint workaround. You will need to rely on exporting the data to a local Excel file and securely sending it via authorized encrypted email.
