09 Jun

How to Create an Online Survey With Google Forms

Surveys are a cost-effective, flexible and reliable way to collect information about both customers and employees. Market research traditionally relied on these powerful tools, but carried them out using face-to-face interviews. This method is substantially more expensive than the online equivalent.

You can create online surveys from either your Google Drive or from any existing spreadsheet within Google Sheets.

Create a Survey Using Google Drive

  1. Visit Google Drive at drive.google.com
  2. If you are using the new version of Google Drive, click on the “New” button in the top left. Next, move your cursor to the “More” button and click on “Google Forms” in the subsequent drop-down menu. If you are using the old version of Google Drive, select the “Create” button on the top left, and then click on “Form”.
  3. To add questions to your survey, click on “Add Item” in the main area of the form.
  4. If you’d like those who complete your survey to see a progress bar indicating how much of your form they’ve completed, check the box labeled “Show progress bar at the bottom of form pages”.
  5. To customize the appearance of your survey, select “Change theme” from the secondary menu.

Create a Survey With Google Sheets

  1. Visit Google Drive at sheets.google.com
  2. If you are using Google Sheets, you can either create a survey based on an existing spreadsheet or a new spreadsheet. In either case, open the document, navigate to the top toolbar, and then select “Insert”. From there, click on “Form” in the drop-down menu.
  3. To add questions to your new survey, click on “Add Item” in the main area of the form.
  4. If you’d like those who complete your form to see a progress bar indicating how much of your form they’ve completed, check the box labeled “Show progress bar at the bottom of form pages”.
  5. To customize the appearance of your survey, select “Change theme” from the secondary menu.

Viewing Responses

To view the results of your survey, revisit the document using the application used to create it (e.g. Google Drive or Google Sheets). Once loaded, select “View responses” from the secondary menu, which will direct you to a Google Sheets spreadsheet containing your submissions. Your survey data is housed in a Google Sheets spreadsheet regardless of the application you originally used to create your survey.

You can choose to download the responses to your survey. To do so, select “File”, and then hover over the “More” option. Click on “Download As” in the drop-down menu, and then select “Comma Separated Values”. Your computer will then download a file containing the responses. You can open this file in Microsoft Excel or a similar spreadsheet program.

Leave a reply