Google Form responses disappeared or missing? Why they're gone and what can be recovered

What can and cannot be recovered

Google's wording on this is short and worth reading exactly.

• Responses deleted in the form: no. Google says 'If you delete any responses in a form, it can't be undone.' Its help describes no trash or restore option for them.
• Rows in a linked spreadsheet: often yes. Google says that if you store responses in a spreadsheet, 'you have a separate file in Google Drive', and earlier versions of that file can be opened through version history.
• A form or spreadsheet in Trash: yes, for a limited time. 'Files remain in Trash for 30 days, then they're deleted forever.'
• Files after Trash is emptied: 'When you click Empty trash, the files in your trash are deleted forever.' A Google Workspace admin may be able to help for 25 days.
• Files people uploaded through the form: these are stored separately. Google says 'Deleting responses from Forms does not delete attached files', and that for the form owner, uploaded files are stored in a new folder on Google Drive.
• A draft that was never submitted: only the respondent can get back to it, and only while the draft lasts.

Cause 1: You are checking a different form, a copy or the wrong account

Rule this out first, because here nothing is lost. A form made with 'More' and 'Make a copy' looks identical to the original. Google's steps for copying say nothing about responses coming along, so treat a copy as its own form and check its 'Responses' tab separately.

Also read the 'Summary' tab as a clue. Google says it 'displays on a form only when there's one or more responses', so if it is missing, the form you have open has no responses right now.

• In each form that could be the right one, click 'Share', then 'Copy responder link', and compare it with the link you sent out. If you sent a shortened link, open it and compare the address it lands on.
• Check which Google account you are in. Drive's help says to make sure you are logged in to the account where you originally accessed the file.
• Search Drive for the form's name. If its folder was deleted, Google says the file 'becomes unorganized and difficult to find'. Searching for is:unorganized in Drive lists those files.
• Very large forms can hide a view without losing anything. Google says a missing response summary 'can be because your form has more than 50,000 responses', and links a missing question or individual view to more than 10,000.

Cause 2: The responses were deleted in the form

Two actions do this: 'Responses', 'Summary', 'More', then 'Delete all responses', or 'Responses', 'Individual', then 'Delete' for one response. It does not have to be you, either. Google says of collaborators, 'Whoever you invite can edit any part of your form, including responses and where they are saved.' So ask anyone with edit access.

Google's statement about deleted responses gives no exception, so don't plan around the 'Undo' button in the form editor. Look for another copy, in this order:

• The linked spreadsheet. Open it now. Google's help does not say what deleting in the form does to existing rows, so look and don't assume. If the rows are there, right-click the file in Drive and choose 'Make a copy'.
• Any CSV someone downloaded earlier through 'More' and 'Download responses (.csv)'.
• Response receipts. If the form had 'Send responders a copy of their response' on, respondents may have their answers in their inbox and can forward them. Google warns that spam filters may block some receipts.
• Uploaded files. If the form had a file upload question, look in the form's folder in your Drive.
• The respondents themselves. If you know who filled it in, a short request to submit again is often the fastest fix.

Cause 3: The sheet was unlinked or the destination changed

This looks like lost data but usually isn't. After 'Unlink form', in Google's words, 'New responses won't be sent to the spreadsheet, but your current data remains intact.' So the old rows stay in the sheet, and the newer responses are in the form.

The destination can also be switched with 'Select existing spreadsheet', which can leave you looking at the old file while new responses are stored in another one. To repair the link:

• Open the form, then click 'Responses'. The responses collected since the sheet stopped updating should be listed here.
• To reconnect, go to 'Summary', click 'More', 'Select destination for responses', then choose 'Create a new spreadsheet' or 'Select existing spreadsheet'.
• Google's page does not say whether reconnecting fills in the responses that were missed. Compare the two afterwards. If there are gaps, click 'More' and 'Download responses (.csv)' for everything the form still holds.

Cause 4: Rows or the whole file went missing from the Sheet

If the spreadsheet or the form is missing, check Trash first. Go to drive.google.com, click 'Trash' on the left, right-click the file and choose 'Restore'. Only the owner can delete a file, so ask the owner to look in theirs.

If the file is there but rows are gone, use version history. On a computer, open the spreadsheet and click 'Last edit' at the top right, then pick an earlier version in the right panel. Sheets hides unmodified rows by default in this view, so use 'Show unmodified rows' at the bottom right before deciding something is missing.

• Safer first step: next to the version, click 'More', then 'Make a copy'. A copy leaves the live, linked sheet alone, which matters on a form still taking responses.
• To roll the file back instead, click 'Restore this version' and then 'Restore'. Google warns that this 'clears the cell-by-cell edit history for any changes made before the restore'.
• You need permission to edit the file to see its version history, and not every moment is kept. Google says revisions 'may occasionally be merged'.
• Version history only holds what the spreadsheet once contained, and it restores the file, not the form. A response that arrived after unlinking was never in the sheet.
• Trash already emptied, on a Google Workspace account: an admin can recover items 'within 25 days after a user empties their trash'. Google adds, 'After that period, Google purges those items from its systems and they can't be recovered.' The restore brings back everything removed during a chosen date range, so tell the admin when the file was deleted.
• Trash already emptied, on a personal account: Google's Drive recovery page has a file recovery request for signed-in users, but it promises no result.

Cause 5: The respondent never pressed Submit

'I filled it in' and 'I submitted it' are not always the same thing. When someone fills out a form in their Google account, Google says 'your progress is automatically saved as a draft for 30 days', and 'Draft saved' appears at the top of the form. Google's help describes no way for a form owner to see or retrieve that draft.

Ask what they saw after pressing 'Submit'. If they saw no confirmation message, or they remember a red error, the response probably never went through. Then:

• Ask them to 'reopen the form URL in the same Google Account' they used, finish it and press 'Submit'. Drafts last 30 days from the last edit.
• If they see 'This is a required question' in red, the form won't go through until that field is answered.
• If they see 'Form is no longer accepting responses', the form is closed, and they need to contact you, the owner.
• 'Saving disabled' at the top means the creator may have turned off draft autosaving, so they should fill it in again in one sitting.
• 'Unable to save your draft' does not block sending. Google says they can still submit and all their responses will be recorded, but closing the form first may lose their progress.
• Google describes autosave only for people filling in the form in their Google account, and says it doesn't work offline. Without those, expect no draft.

Prevent it next time

Most of this comes down to having a second copy before you need one, and limiting who can remove the first.

• Link a spreadsheet before you open the form: 'Responses', then 'Link to Sheets'. It gives you a separate file in Drive.
• Download a CSV at milestones, such as when a deadline closes.
• Before clearing a form, follow Google's advice: close it for new responses, download, and only then delete. Google says closing it 'helps to ensure that no responses are deleted after downloading responses'.
• Add editors sparingly, since a collaborator can delete responses or change where they are saved.
• Name key versions of the spreadsheet with 'Name this version'. Google allows up to 15 named versions per spreadsheet.
• Turn on 'Get email notifications for new responses' under 'Responses' and 'More', so a silent drop in responses is easier to notice.
• Turn on 'Send responders a copy of their response' if people need proof.
• On very large forms, watch the limit. Google says each form can receive up to 500k responses, and for existing enterprise forms over that, a Google Takeout archive will be generated after March 2027 and 'Responses are then deleted to allow more submissions.'

If you'd rather have a copy in your inbox

If you want a second copy without setting up a sheet, a OneSol form emails you each new response, so there is a copy of every response in your inbox, and respondents don't need to sign in. A free OneSol account is enough to make a form.