Google Forms is an app for creating forms and surveys, and is part of Google Apps for Work. The product focuses on ease of use; the interface is similar to a document editor, with drop down lists of options and drag and drop question re-ordering. Users can embed images and video into surveys. Users can also program the question flow with custom logic. Google sends users basic summaries of the survey results automatically, or users can export the raw survey results data and analyze it via…
N/A
Microsoft Excel
Score 8.9 out of 10
N/A
Microsoft Excel is a spreadsheet application available as part of Microsoft 365 (Office 365), or standalone, in cloud-based and on-premise editions.
While other products have been useful for being easily sharable or free, Microsoft Excel handles more data with easier to use functions, pivot tables, graphing, and formulas than all that I have used. Google Sheets is a close second but has not been able to handle the large …
Google Forms works really well when you need to quickly gather information and store it in a standardized format. It also works well if your organization is already using other Google products.
If you don't use other Google products, another service may be a better fit for you. Additionally, if you need your forms to be highly customized for marketing purposes, for example, you might have an easier time with other tools.
That being said, Google Forms is well supported and is highly flexible and would likely work well for many companies.
I don't really know another program as powerful as Excel. I've used Google Doc programs but do not feel they come close. So far, anytime I've needed a table of some sort for data, whether it's budget oriented or information off a survey, the best system has been Excel. We do web audits on occasion and we create an Excel worksheet featuring every URL of the pages we're auditing, notes, data about the content, information about files attached to the page and other information to help us determine what pages need updating, deleting or otherwise. We also use Excel primarily to export our Google Analytics to in order for us to create reports for clients that need to see specific information about their traffic.
Live results: When a user completes the form the results are added instantly.
Easy to create: Google Forms has a simple interface that allows for a wide range of question types. Google will even try to guess the question type based on the question (but this can be overridden).
Answers export to Google Sheets: It is easy to have each response to your form add a row to a Google Sheet, allowing for further analysis or processing.
Ability to automatically collect email addresses within a domain: If you have a form that has been shared with users in your domain, you can set it to automatically collect the users' email addresses without them needing to type it in. Makes checking whether all students have completed the form easy.
It is very good at embedded formulas and tying cells to one another
It allows me to compare deals terms on a side-by-side basis and talk my clients through it easily.
It is very helpful as well in terms of allowing me to filter/sort results in many different ways depending on what specific information I am most interested in prioritizing.
Sometimes finding the output -- a Google Sheet with all responses-- is a little difficult. It's also sometimes confusing to figure out how to get back into the Google Form Survey itself.
As always, sharing among an institutional Google account and your personal Google account can be frustrating. You have to make a copy and can't share across the two different accounts very easily.
Excel offers collaboration features that allow multiple users to work on the same spreadsheet, but managing changes made by different users can be challenging. Excel could improve its features by offering more granular control, better tracking of changes, and more robust conflict resolution tools.
Itcan be a barrier to productivity when importing and exporting data from other applications or file formats. To improve its features, it should offer better support for standard file formats and more robust error handling and reporting tools.
Excel can be challenging for finance students and working professionals, but it can be improved by offering more robust tutorials, better documentation, and more user communities and support forums.
I will definitely renew my use of Google Forms because I really like the ease of use and the number of tools that Google forms provide. I also love that I can administer a test in real-time and get results in a timely manner
Excel remains the industry standard for spreadsheets and has maintained simple and straight-forward formula writing methods. Although there is a learning curve to do more complex calculations, there are countless help sites and videos on the Internet for almost any need.
Google Forms is a very intuitive and easy to use tool, it is not necessary to have a complex knowledge to create advanced forms, it is enough with the functions and aids that the tool offers for the creation of these, even children and students can do it, also the way to export the data is really simple, simply an incredible tool.
I'm giving it a 7 because it is my go to. But the fact other prefer Google Sheets when working with a team does get irritating. I've used the online version of Microsoft Excel that other teams can get into and it still seems behind Google Sheets. It's a little clanky and slow? If that's even a term.
In the years I've used GoogleForms I've never ran into any issues with the reliability or availability. Google is a gigantic company with essentially limitless resources which makes it very easy to trust that I will continue to be able to enjoy the same reliability I've come to know and expect from GoogleForms
One of the things that comes as a benefit of the lack to create complex logic branching and truly custom design is that there isn't lot of room to bog down the software. GoogleForms has always loaded just as fast as my internet service and device would allow it. I'm not sure about front end integrations or integrations into the form itself, as I've never explored it, but on the backend, I've never had any issues with integrations channeling from GoogleForms from the GoogleForms's end of things.
Google has a support team but it isn't the most helpful with Forms. I find most of my answers by searching online and watching tutorial videos. I would recommend utilizing online resources before contacting their live support team for help. Just make sure that they are recent videos or directions. Google is constantly updating their interfaces so it is easy for things to get out of date
We have also used FormAssembly, which is far more advanced with security, analytics, and functionality, but is also more expensive and takes a greater resource investment to train others to use. While FormAssembly can provide a lot more features, and is definitely the better choice for more complex surveys, forms, and applications, Google Forms is a very approachable and easy to use platform. We would recommend Google Forms for smaller businesses with simpler processes, and everyday use for any organization.
Out of Microsoft Excel, Microsoft Power BI, IBM SPSS, and Google Sheets, Microsoft Excel is by far the most common tool used for anything data-related across organizations. Accordingly, our organization has also implemented Microsoft Excel as a first-step tool. We recently adopted Microsoft Power BI (the free version), and use it occasionally (mostly for creating dashboards), but it is less commonly understood by stakeholders across our organization and by our clients. Accordingly, Microsoft Excel is more user-friendly and because of its popularity, we can easily look up how to do things in the program online. Google Sheets is a comparable alternative to Microsoft Excel, but because it's cloud-based and we have sensitive data that needs to be protected, we chose against using this software. Finally, a few users (including myself) have access to and utilize IBM's SPSS. For my role, it's a helpful tool to do more rigorous analyses. However, because of its cost and limited functionality as a simple spreadsheet, we only use it for more complex analyses.
GoogleForms lacks the ability for complex logic branching and the ability to truly design it in a custom manner. It's pretty obvious when you land on a GoogleForm that it is in fact a GoogleForm. This rating solely reflects the lack of flexibility which in turn makes it something that wouldn't usually be scaled. That being said, if needing to scale a simple solution, GoogleForms would be up for the job.
Each user can use it to whatever level of expertise they have. It remains the same so users can contribute to another's work regardless of whether they have more or less expertise
