Google Form Responses Spreadsheet Has Blank Rows or No Data

This KB Article References: Google Drive
Created: 01/31/2014 Last Updated: 12/12/2023

If you have a Google Form that displays data in a Google Sheet, check out these tips for

Empty Rows

If your form has blank rows, it may be because these rows used to have data in them but they were deleted.

  1. To truly delete rows, highlight the rows by clicking on the "2" and dragging to "5".
  2. Right-click on the selected rows and click Delete rows
  3. The empty rows will be removed

No Data

If your responses spreadsheet appears to have no data,

  1. Scroll to the bottom of the page to see if the data appear after the blank rows
  2. Check if there is another sheet at the bottom of the page (e.g., Form Responses 1, Form Responses 2) with the data
    additional sheets at the bottom of the page
  3. If you still don't see any data, see Google Form Responses Do Not Appear in the Spreadsheet

Supported By

Customer Engagement and Support

Related Information