Order columns in a spreadsheet from a google docs form

google-sheets google-forms
RTB picture RTB · Jun 26, 2012 · Viewed 28.3k times · Source

you can't move columns in the table from side to side since doing so would disrupt the structure from the table. This is what google support and/or help pages say.

My problem is that if I create a form in google docs. And I accidentally create a question that I should have created earlier and then I move the question up the form. The column doesn't move in the spreadsheet.

So my form spreadsheet looks messed up now. Is there a way to fix this without typing all my questions(89) again. I don't have any results in the sheet yet. So I'm looking for a regenerate sheet option or something like that.

Answer

smoortema picture smoortema · May 30, 2014

The simplest option is to unlink the form from the spreadsheet it is linked to and then relink it to the same spreadsheet. It will create a new sheet in that spreadsheet, but this time it will be in the good order.

You can then copy the old answers from the old sheet into your new sheet and rearrange them manually.

Related questions

Is it possible to 'prefill' a google form using data from a google spreadsheet?

I'm looking for a way to 'pre fill' a google form with specific data from a google spreadsheet. The form will have the same 'standard' questions for everyone, but the data in the first two question will be 'prefilled' with …

Read More
Retrieve the e-mail address of a Google Form respondent without asking for their e-mail address in the form

The scenario goes: Via email, a Google Form is sent to a respondent. Via this sent email, the respondent answers the form and sends their response. This form has no email address field. I need to retrieve the respondents e-mail …

Read More
Hidden field in a Google Form

I am adding a unique ID to each submission of the form. Right now, I made that ID the first field, and pre-filled it with the ID, along with a help text asking the user not to modify this field. …

Read More