Embedded Files
Often you want to download spreadsheet information and re-issue the form for either another week or another class or another year. Here is ONE way you can do that.
WATCH VIDEO and Refer to STEP by STEP
STEP BY STEP
1. First, you want to download your current data. Click on File Download and choose As Excel Spreadsheet. Rename this file with the dates (i.e. Signin_9_17to21)
2. When you are sure that you have the current data, you can now go to Edit Form
Click on Responses
Click on Delete All Responses - This will delete the answers in the Form only, not the Spreadsheet.
3. Go back to the SpreadSheet and Highlight the rows you want to delete.
Right Mouse Click and Delete Rows 2 through XXX (Do NOT delete Row 1)
4. Check to make sure you are still linked to this spreadsheet by:
Go back to Edit Form
Click on Responses
Click on the "View Responses Icon"
5. Run a TEST. Answer all questions in the Live Form with the word TEST and see if you get responses in your empty form. IF NOT, you will need to LINK your form to the old Spreadsheet.
If you need help, let me know.
Page updated
Report abuse