You want to check your responses spreadsheet but an error message saying that your spreadsheet is missing appears. This article explains why your spreadsheet is missing from your Google Form and how to solve this issue.
Why does your spreadsheet is missing?
1. You have deleted the file in your Google Drive and Google Form can’t retrieve it
You want to open your responses spreadsheet in your Google Form to check your responses but you are receiving this error message:
That means Google Form can't retrieve your responses spreadsheet from your Google Form.
However, if you are simply receiving the below errir message from your responses spreadsheet, that means your file has been removed from your Google Drive but not from your trash folder. You can easily take it out of trash. Click 'Take out of trash' to retrieve your responses spreasheet:
However, if you don't have access to your responses spreadsheet, you could retrieve all the responses and the file URLs when you will have access again.
2. You have transferred ownership of Form Publisher settings
The ownership of your Google Form has been transferred. You configured Form Publisher and once your form has been submitted you want to check your responses spreadsheet with your new account.
However, permission access message appears:
How to solve this issue?
1. Create a new spreadsheet from your Google Form
To retrieve your responses spreadsheet which has been completely deleted from your Google Drive, we recommend creating a new one.
To do so, click on the option tab from your Google Form:
Click 'Unlink form':
A window pops up, click ‘Unlink’:
Then, click 'Select response destination':
You can either create a new spreadsheet or select an existing one. In our example, we decided to create a new spreadsheet. Click 'Create':
To check that your responses spreadsheet has been created, click on the spreadsheet icon from your Google Form:
Your new responses spreadsheet appears:
2. Transfer responses spreadsheet
To use the Google Form correctly, make sure your Google Form and your responses spreadsheet have been transferred correctly to the same owner.
If you want to transfer ownership, make sure to share:
- Your Google Form as collaborator
- Your template (Google Doc, Sheet or Slide)
- Your responses spreadsheet
The previous owner will have to disable Form Publisher:
The new owner will have to activate Form Publisher. To do so, click ‘Status & quotas’:
Click ‘Form Publisher Status’ to activate Form Publisher: