
Tools and providers
Business software: checks before choosing a form tool
Business software teams choosing a form tool for internal operations data: the respondent access, export and privacy checks to run before the first invitation.
What to take away
- Google Forms and Microsoft Forms both handle routine operations data collection, so the choice turns on respondent access, collaboration, export and account governance.
- Confirm that respondents can open a form without an account and that one-response controls do not force sign-in.
- Decide the analysis format before launch, then check which fields export and how multiple selections appear.
- Collect only necessary data and set an owner, access group and deletion date before inviting participants.
- Keep a dated decision note linked to precise supplier documentation, and pilot the questionnaire outside the project team.
What this guide covers
This guide draws on the published help pages for Google Forms and Microsoft Forms and covers question design, form sharing and response export. It is about the two suite-bundled tools rather than third-party survey products, and each section sets out a check to run and the result to record before you invite participants. Prices, service levels and advanced research panels sit outside it.
Google Forms vs Microsoft Forms
Google Forms
- Core use
- Surveys, quizzes, forms
- Question types
- Editable form content
- Analysis route
- Charts, Google Sheets
- Access caveat
- Sharing settings need review
Microsoft Forms
- Core use
- Surveys, quizzes, polls
- Question types
- Choice, text, rating, date
- Analysis route
- Built-in results, Excel export
- Access caveat
- Varies by account or plan
Google's Forms help page says users can create surveys, send them for completion and analyse responses, including through Google Sheets. Microsoft's form creation guide lists its question types and explains the account routes into Forms.
Google Forms
- Core use
- Surveys, quizzes and forms
- Question examples
- Editable form content and response collection
- Analysis route
- Charts and Google Sheets
- Access caveat
- Sharing and response settings need review
Microsoft Forms
- Core use
- Surveys, quizzes and polls
- Question examples
- Choice, text, rating, date, ranking and Likert options
- Analysis route
- Built-in results and Excel export
- Access caveat
- Availability varies by Microsoft account or plan
For a wider view of the market, our overview of business productivity software is worth reading before you commit to a form tool bundled inside a larger suite.
Respondent access and form settings
Test whether intended respondents can open the form without an account and whether one-response controls impose sign-in. A branded survey that excludes contractors, sole traders or partner staff will distort the sample.
In Google Forms, a form shared by link can be completed without a Google account, but the one-response limit requires respondents to sign in to Google. In Microsoft Forms, a form shared so that anyone with the link can respond does not require sign-in, while a form limited to your organisation does. Both settings sit in the form's settings rather than in the questionnaire itself.
Respondent access check
Can intended respondents open without an account?
Proceed with sharing settings
Adjust sign-in or one-response controls
Check collaborator permissions separately from respondent settings. Google's response-management page notes that removing access to a form and its linked spreadsheet can require separate action. That is a concrete governance point for shared operations accounts.
Availability differs by plan: if the organisation runs Microsoft 365 or Google Workspace, sharing options follow that licence rather than the vendor's feature list.
Matching the export to the analysis
Decide the analysis format before launch. Where staff need row-level data, confirm which fields export, how multiple selections appear and whether timestamps or identifiers are included. Keep a blank questionnaire and a data dictionary beside the export.
Neither tool designs a representative sample, and question wording, recruitment, non-response and duplicate participation still need a method. Work through our guide to audience research before you write the first question.
Privacy, retention and the lawful basis
Collect only what the process needs. Set an owner, access group and deletion date before inviting participants. If a form asks for personal information, obtain a qualified review of the lawful basis, privacy information and processor arrangements.
The Data Protection Act 2018 sets the statutory framework behind UK GDPR compliance, and the ICO's guide to the UK GDPR covers lawful basis and processing duties. Both apply when form responses contain identifiable data.
Cloud form tools sit inside hosted suites, so apply the NCSC's cloud security guidance when assessing providers.
Keeping the choice auditable
Keep a dated decision note with the question types, account owner, respondent access, export need and retention setting. Link to the precise supplier documentation used rather than a general product homepage.
If a required behaviour is unclear, run a controlled pilot in the approved environment and label the result as an internal observation. Our guide to attribution methods helps you test whether a form change altered the process, rather than assuming it did.
Before you act
- Test respondent access without an account.
- Check collaborator permissions separately from respondent settings.
- Decide the analysis format before launch.
- Set owner, access group and deletion date.
- Pilot the questionnaire outside the project team.
- Keep a dated decision note with the required details.
Common questions
Short answers to the questions that come up most often when teams pick a form tool for internal operations data.
What should I check about respondent access before choosing a form tool?
Test whether intended respondents can open the form without an account and whether one-response controls impose sign-in. Check collaborator permissions separately from respondent settings.
How do I decide which export format to use for analysis?
Decide the analysis format before launching. If staff need row-level data, confirm which fields export, how multiple selections appear and whether timestamps or identifiers are carried.
What privacy steps should I take before inviting participants?
Collect only what the process needs, and set an owner, access group and deletion date first.



