askvity

How Do I Add Columns in Google Forms?

Published in Google Forms Columns 2 mins read

Adding columns related to your Google Form, based on the information provided, primarily involves working within the spreadsheet that collects your form responses. This method differs from adding standard questions directly within the form editor.

Accessing Your Form Responses

To add columns using the method described, you first need to access the Google Sheet linked to your form. You can typically do this by opening your Google Form, clicking on the "Responses" tab, and then clicking the green Google Sheets icon.

Adding Columns in the Response Spreadsheet

According to the reference, adding columns in the response spreadsheet can result in them appearing as hidden questions in your form. Here are the ways to add columns:

  • Method 1: Using the "Add column" Button

    • Navigate to the response spreadsheet linked to your Google Form.
    • Look at the column headers (like 'Timestamp', the names of your questions, etc.).
    • Find the "Add column" button located in the furthest right column header. Click this button to add a new column.
  • Method 2: Using the Right-Click Context Menu

    • In your response spreadsheet, right-click on a column header.
    • A menu will appear.
    • From this menu, select the "Insert left" option to add a column to the left of the one you right-clicked on.

The reference states that after performing either of these actions, if you open your Google Form editor, you will see these newly added columns represented as hidden questions located at the bottom of the list of form questions displayed on the left sidebar.

It's important to understand that adding columns directly within the response spreadsheet as described might not function in the same way as adding visible questions through the standard Google Forms editor interface, which are designed for respondents to interact with. The reference specifically highlights that these added columns manifest as "hidden questions."

Related Articles