Is there a way to update an existing sheet in a Google spreadsheet using a Google form? I only see how to update to a new tab (sheet) on an existing spreadsheet.

1 Answer 1


When you insert or link a form to a spreadsheet, a new sheet is always created. This makes sense because the data is transmitted in a specific way: column A is Timestamp, etc. The algorithm isn't meant to work around some pre-existing data in the sheet, so it pulls out a clean sheet to work with.

But you can achieve the desired effect by copying the contents of your existing sheet to the Form Responses sheet after it's created, and then deleting the original.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.