A note on how to use Google Form to construct a questionnaire and export data to Excel

A note on how to use Google Form to construct a questionnaire 

Study this video and try Google Form to create your questionnaire:

Sample screens

My question 1 to perplexity.ai: "What are the strengths and weaknesses of using Google Form to do a questionnaire survey?"

The reply: "Google Forms offers several strengths and weaknesses for conducting questionnaire surveys:

Strengths:

• Ease of use: The interface is intuitive and simple, allowing users with basic tech skills to create surveys quickly without coding knowledge. It uses a drag-and-drop design plus WYSIWYG features.​

• Cost-effective: It is free to use with a Google account, making it accessible for individuals, small businesses, startups, and educational use.​

• Customization: It allows some customization in colors, question types, and conditional logic, suitable for many survey needs though not highly advanced.​

• Integration: Seamless integration with Google Sheets and other Google Workspace apps provides easy data management and real-time response analysis.​

• Accessibility: Respondents can access and fill forms from any internet-connected device, useful for wide distribution.​

• Unlimited forms and responses: No limits on creating forms or number of submissions, suitable for large-scale data collection.​

Weaknesses:

• Limited design and branding options: The visual customization is quite basic, which can lead to a generic or amateurish appearance.​

• Lacks advanced survey features: Compared to specialized survey tools, it has fewer sophisticated options like advanced logic branching, professional templates, and analytics.​

• Requires internet connection: No offline data collection capability, so respondents must be online to complete the survey.​

• Data management: While responses can be exported to Sheets, handling and analyzing large or complex datasets can be difficult for non-experts.​

• Privacy concerns: Data is stored on Google’s servers, which may raise privacy or compliance issues for sensitive data.​

• Requires Google account for survey creation and collaboration, which may be a barrier for some users.​

In summary, Google Forms is a highly accessible, free, and easy-to-use tool well suited for simple and cost-effective questionnaire surveys. However, it lacks advanced customization, offline capabilities, and some professional survey features, which limits its use for complex or large-scale research requiring stronger branding and data analysis."

My question 2: "Highlight the main steps to export the Google Form-created questionnaire response data to Excel." (also study the video for a demo).

The reply: "Here are the main steps to export Google Form response data to Excel:

1. Open your Google Form in edit mode.

2. Click on the "Responses" tab at the top of the form editor.

3. In the Responses tab, click the green Sheets icon to open the linked Google Sheet that contains all the response data. If a sheet is not created yet, it will prompt you to create one.

4. Once the Google Sheet opens with the responses, go to the "File" menu in Google Sheets.

5. Select "Download" from the dropdown menu.

6. Choose the "Microsoft Excel (.xlsx)" format to download all the response data as an Excel file.

7. Save the downloaded .xlsx file to your computer where you can open and analyze it in Excel.

This process allows you to easily export your questionnaire data gathered via Google Forms for use in Excel with all responses neatly organized in rows and columns."