How to retrieve results from a google form that was ended / been deleted

Jessica White 0 Reputation points
2026-11-16T12:46:18.3566667+00:00

I downloaded the results from a recent survey before either ending or pausing the survey, and when I checked the excel spreadsheet it only has date and time of survey completion. When I open the form now it doesn't let me view the questions or answers.

Microsoft 365 and Office | Microsoft Forms | For education
0 comments No comments

2 answers

Sort by: Most helpful
  1. Heimerdinger 1,805 Reputation points Independent Advisor
    2026-11-16T13:54:13.35+00:00

    Hi Jessica White,

    Thank you for explaining the issue. To help narrow this down, could you please confirm:

    • Are you signed in with the same Microsoft account that originally created the form?
    • Can you still see the affected form on your Microsoft Forms homepage?
    • When you open the form, what exactly do you see? If possible, please share a screenshot with any personal information removed.
    • Does this happen only with this particular form, or are other forms affected as well?
    • Could you also try creating a new test form with one or two questions, submit a test response, and then export the responses to Excel? Please let me know whether the questions and answers appear correctly in the new Excel file.

    This test should help determine whether the issue is specific to the original form or also affects newly created forms.

    Thank you again for your time and understanding.  I really appreciate your patience, and I’m here to help. Looking forward to your response.

    Was this answer helpful?

    0 comments No comments

  2. AI answer

    2026-11-16T12:47:28.4533333+00:00

    Because the form still appears in All forms but neither its questions nor responses open, preserve the existing form and workbook, check the Forms recycle bin from the same owner account, and escalate the inaccessible form to your Microsoft 365 administrator rather than deleting or recreating it.

    1. Check whether there is a recoverable deleted copy

    1. Sign in to Microsoft Forms using the same work or school account that created the survey.
    2. Open Deleted forms.
    3. If the survey appears there, select More options (…) → Restore.
    4. Return to All forms, open the restored form, and select View responses.

    Forms keeps deleted forms in Deleted forms indefinitely unless they are explicitly deleted from there. Deleting one from that tab permanently removes the form and all its responses.^1^

    Do not delete the still-visible tile as a troubleshooting step.

    2. Once the form opens, retrieve a fresh response file

    From the form:

    1. Select View responses.
    2. Check Responses Overview and Check individual results first. This establishes whether Forms still holds the answers independently of the spreadsheet.
    3. Select Open results in Excel → Download a copy to create a fresh snapshot.

    A normal Forms export places each question in a column and each submitted response in a row. The first columns contain metadata such as the response ID and completion times; question-answer columns follow them. A workbook containing only timestamps is therefore not a complete normal response export.^2^

    If the form was created through OneDrive for work or school, SharePoint, Excel for the web, Teams, or the Forms web part—and More options → Sync all responses to a new workbook is available—use that command. It creates a new workbook containing the most recent responses. This option applies to Office 365 Education and Microsoft 365 Apps for business accounts with a live Forms–Excel connection.^3^

    If that option is absent, use Download a copy after access is restored; do not assume the earlier workbook can reconstruct the missing fields.

    3. If the form remains inaccessible

    Ask your school’s Microsoft 365 administrator to open a Microsoft support request and provide:

    • The form title and its URL/Form ID.
    • The owner’s account—not respondents’ personal information.
    • A screenshot and the exact error shown when opening the tile.
    • The approximate date access stopped.
    • Confirmation that the tile remains in All forms.
    • Confirmation that the exported workbook contains only completion dates/times.

    The administrator should also verify that Microsoft Forms remains enabled and licensed for the owner. Administrators can disable Forms for an individual user, which prevents that person from using Forms.^4^

    If the form was automatically blocked by phishing protection, a global or security administrator can review blocked forms in the Microsoft 365 admin center’s Message Center and choose whether to unblock one.^5^

    Important recovery limits

    • If someone deleted individual questions, those questions and their collected response data were permanently deleted; restoring the form itself will not reconstruct them.^6^
    • If the form was deleted from Deleted forms, Microsoft documents that the form and all responses are permanently deleted.^1^
    • If the answers are absent from Forms and were never included in an Excel export or another backup, there is no documented self-service recovery method. The administrator’s support request is the remaining escalation path.

    References

    1. Delete a form or recover a deleted form | Microsoft Support
    2. Check and share your form results | Microsoft Support
    3. How to get missing data in Forms
    4. Administrator settings for Microsoft Forms
    5. Admin information
    6. [OneDrive for work or school](https://support.microsoft.com/forms/create-a-form-with-microsoft-forms)
    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.