How to Move Form Responses from One Spreadsheet to Another Spreadsheet

0:00 You're going to find out how to move a form from one sheet to another. So we have this old form responses. We have a form here. You can see in the tab, it has a purple icon of the form. And if we go up to tools, manage form, go to live form, We can see that this is a form that actually exists. We want to, though, move this to an existing sheet, another sheet, all of the responses. All the responses are coming here. We want to go to a new form responses and move them here. I'm going to show you all the steps on how to do that. First, we're going to go to the sheet, and we're going to have to click on the down arrow next to the name and click on unlink form. We're going to unlink form, and it tells you here that new responses to this form will no longer be sent to the spreadsheet , but Existing data will not be deleted, so you can keep your old data . We're going to unlink it. Now, there is this old form that exists still, and we need to move Create New Worksheet When Google Form Submitted How to Send Google Forms Entries Automatically with Apps Script Different Kinds of Automation How to Re Order Google Form Responses

0:49 it to the new form responses. So one way we can do this is to go to responses in our form, we're editing our form, and there's this three dots next to View in Sheets. We need to select a destination for responses. Here we do have the option to create a new spreadsheet if we wish, but we're going to actually select an existing spreadsheet because we're just moving these form responses from one sheet to another. We're going to select an existing spreadsheet . And here we can now choose which spreadsheet we want to move those responses to. So we're going to select new form responses, click insert, and now if we go to our new form responses, we can see that there is a Form and this is linked here. So if we fill out this form, it'll go to the new form responses spreadsheet. So that's how you can move form responses from one spreadsheet to another. Create New Worksheet When Google Form Submitted How to Send Google Forms Entries Automatically with Apps Script Create New Worksheet When Google Form Submitted How To Link a New Google Form to a New Spreadsheet

1:36 We can always do that again. We can just unlink form and keep doing that to a new sheet. However, the responses will not be sent to old sheets. It will only be sent to whichever sheet is accepting the responses at the moment. Create New Worksheet When Google Form Submitted How to Unlink a Google Form From a Google Sheet