Google Form Responses Spreadsheet Has Blank Rows or No Data

This KB Article References: Google Drive
This Information is Intended for:
Last Updated: April 06, 2017

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

Additional Information


Getting Help


The Division of Information Technology provides support on all of our services. If you require assistance please submit a support ticket through the IT Service Management system.

Submit A Ticket

Supported By


DoIT Training and Development