Small business CRM survey tools: three research routes

Small business CRM survey tools come in three workable shapes for a first research round: a controlled manual document and spreadsheet, Microsoft Forms inside Microsoft 365 Business Basic, and Google Forms inside Google Workspace Business Starter. This piece sets out what each route must prove before its evidence can feed a CRM decision.

What to take away

Route the evidence into the CRM decisionthe question wording, choice codes and timestamps fixed here become the contact fields, deal stages and activity records your small-business CRM has to hold.
Pick the manual document and controlled spreadsheet for a small exploratory round that your existing record controls already cover.
Pick Microsoft Forms when the team already pays for Microsoft 365 Business Basic, where Microsoft lists Forms among the included apps.
Pick Google Forms when the team already pays for Google Workspace Business Starter, which Google says includes Forms.
Choose on licence, sample size and access needs rather than on brand, because no account, form, contract or respondent journey was tested here.
Every route must reproduce question wording, choice codes, raw responses and the metadata the analysis needs.

Choosing between the three routes

The manual route suits a first round with a small sample and one researcher holding the raw file. Hosted tools suit studies needing remote invitations, automatic timestamps and an export a second analyst can rebuild.

Draw the line on sample size, retention and access needs rather than brand preference. The small business CRM selection checklist shows how to fix the population before you pick a tool, which stops the choice being made on habit. Whoever reads the results carries them into a CRM such as Zoho CRM, HubSpot or Pipedrive, so fix the survey fields against contact records, deal stages, pipeline reporting and the integrations you will need.

Licence context for the two business editions

Both tools sit inside entry-tier suites rather than being sold separately. Microsoft 365 Business Basic and Google Workspace Business Starter are priced per seat, so the survey tool is a by-product of a licence the team may already hold.

Per-seat prices move with annual or monthly commitment, seat count and billing currency, so confirm the current figure on the Business Basic product page and on Google's own Workspace pricing page at the point of budgeting. Either edition only earns its place as a survey tool when the team already holds the licence for other work.

What each supplier page confirms

First-party record

Manual document and spreadsheet: your existing approved tools
Microsoft Forms in Business Basic: Microsoft lists Forms among the edition's apps
Google Forms in Business Starter: Google says Workspace plans include Forms

Export evidence

Manual document and spreadsheet: owner defines open format and version
Microsoft Forms in Business Basic: Microsoft describes opening responses in Excel
Google Forms in Business Starter: Google documents downloading Forms data

Still unresolved

Manual document and spreadsheet: invitation handling, access, deletion, accessibility
Microsoft Forms in Business Basic: tenant settings, regional terms, field coverage
Google Forms in Business Starter: admin configuration, retention, field coverage

These are supplier claims about editions and documented export routes, so the evidence grid records what each route leaves unresolved rather than a tested result. None of it shows how a particular tenant, permission set or contract is configured today; the tests below are what turn a claim into your own evidence.

Survey routes evidence grid

Manual document and controlled spreadsheet

Verified first-party record: buyer's existing approved tools
Export evidence: owner defines open format
Unresolved before use: invitation handling, access, deletion

Microsoft Forms in Business Basic

Verified first-party record: Microsoft lists Forms in edition
Export evidence: Microsoft describes opening in Excel
Unresolved before use: tenant settings, regional terms, raw fields

Google Forms in Business Starter

Verified first-party record: Google says plans include Forms
Export evidence: Google documents export of data
Unresolved before use: admin configuration, export completeness, retention

Acceptance tests before live fieldwork

Build a synthetic form holding every proposed question type, routing rule and withdrawal marker. Invite approved test accounts only.

Fix the sample and the question wording before any tool is compared.
List every field the analysis needs, including consent and completion state.
Check keyboard operation, focus order, error messages, zoom and alternative formats against the study access needs.
Export questions, choice codes, timestamps, consent marker and missing answers.
Have a second researcher rebuild the dataset from that export alone.
Delete the test responses and confirm retention and recovery behaviour.

W3C accessibility references cover technical criteria, yet product inclusion and a clean automated scan do not prove accessibility for a configured survey. The small business CRM planning template logs each test outcome beside the sample definition, so the evidence stays with the decision.

Acceptance test sequence

Build synthetic form with all question types
Invite approved test accounts only
Check keyboard, focus, errors, zoom, formats
Export questions, codes, timestamps, consent, missing
Second researcher reproduces dataset
Delete test responses and confirm retention

Export fields the supplier pages describe

Microsoft's Forms export guidance describes opening responses in Excel. Google's data export guidance covers downloading Forms data alongside other Workspace services.

Neither page enumerates every field. Demand question text, choice codes, timestamps, respondent identifier, completion state, consent marker and withdrawal state, then confirm each one appears in your own test export.

Example header row for the manual route

A manual file still needs fixed names. The owner sets them before fieldwork so the sheet can be merged with a hosted export later.

identifier | response_date (YYYY-MM-DD) | instrument_version | question_code | choice_code | free_text | consent_marker | withdrawn

Version and date format matter most: two analysts cannot merge files where one writes 03/09/2026 and the other 2026-09-03.

Data protection gates in England

In England the Information Commissioner's Office enforces the UK GDPR and the Data Protection Act 2018. Accuracy and storage limitation apply to survey responses as soon as identifiers, timestamps or device details are captured.

A lawful basis — consent, contract, legal obligation, vital interests, public task or legitimate interests — a retention period and a deletion route come before the first invitation. Most organisations also have to register with the ICO and pay the data protection fee, and a breach that risks people's rights must be reported to the ICO. The small business CRM data protection guide sets out the minimum fields and real purposes for CRM records, which is the quicker route to a defensible form.

Common questions

Which route should a small England business pick first?

Start with the manual route when the round is small and your existing controls pass the tests above. Move to Microsoft Forms or Google Forms when you already hold the matching tenant and need remote invitations plus a repeatable export.

What should I check first in a Microsoft Forms export?

Open a synthetic response set in Excel and count the columns before trusting any figure. Confirm the consent marker, the completion state and the timestamp format survive the export intact.

What should I check first in a Google Forms export?

Download the test responses and compare the field list with your analysis plan. Check that withdrawn or partial responses appear and can be excluded without losing the audit trail.

Is a written record needed for the manual route?

Yes. Fixed column names, a stated date format and a version number let a second researcher rebuild the file, which is the same standard the hosted tools are held to.