Division of Information Technology

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

• Empty Rows
• Missing or No Data

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
   
3. If you still don't see any data, see Google Form Responses Do Not Appear in the Spreadsheet