Permission & Access Issues

Give Microsoft Forms Reviewers View-Only Access to Responses

Muhammad TalhaMuhammad Talha Nov 14, 2026 868 views

Question details

The user needs to let someone review Microsoft Forms responses without editing the form.

Product
Microsoft Forms
Device & OS
not provided
Scenario
A form owner wants to share responses with a reviewer who should not have co-author editing access.
Observed behavior
Microsoft Forms does not provide a separate view-only permission for co-authors.
Before you start

Open the form and confirm that responses are available on the Responses tab. Check that you can save and share the exported Excel file through OneDrive or SharePoint.

Solution 1Recommended

Share the Responses as a Read-Only Excel File

Use this workaround when someone needs to review responses without becoming a form co-author.

Microsoft Forms co-authors can edit the form, so a collaboration link is not suitable for view-only review. Share the response workbook instead.

1
Open the responses

In Microsoft Forms, open your form and select the Responses tab.

2
Open the workbook

Select Open in Excel to open or download the response workbook. Save it to OneDrive or SharePoint if it is not already stored there.

3
Set view-only sharing

In OneDrive or SharePoint, select the workbook and choose Share. Open the link settings, select the intended recipients, and choose Can view or turn off editing.

4
Send and check access

Enter the reviewer's address and select Send. Use Manage access on the workbook to check that the reviewer does not also have an existing edit permission.

Check for new responses: Depending on how the workbook was created, it may be a snapshot rather than a live connection. Check whether new responses appear in the shared file, and export and share an updated workbook if needed.
Free Microsoft Office alternative

Review Exported Forms Responses in WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar interface for working with Office files. Open exported response workbooks in WPS Spreadsheet for an easy transition from Microsoft Office; sharing permissions remain managed by your file-sharing service.

Review exported Forms responses in a spreadsheetCompatible with Microsoft Excel XLSX filesFamiliar spreadsheet interface for easier migrationFree and lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Can I give a Microsoft Forms co-author view-only access?

No. Microsoft Forms does not offer a separate view-only role for co-authors. Instead, open the Responses tab, select Open in Excel, and share the workbook with view-only permissions.

How do I prevent a reviewer from editing the response workbook?

In OneDrive or SharePoint, select Share on the workbook and choose Can view or turn off editing in the link settings. Check Manage access for any existing edit permissions the reviewer may have.

Will the shared Excel file include new responses automatically?

It depends on how the workbook was created. Check the shared workbook after a new response arrives; if it is a snapshot, export and share an updated file.

Can a reviewer open the exported response file in WPS Office?

Yes. The reviewer can open a downloaded Excel workbook in WPS Spreadsheet. Access to the shared file is controlled by the service used to share it.