compare

Microsoft Forms vs Google Forms: how the two compare for a working team

September 22, 2026 ・ Halict Editorial

Most people arrive at this comparison from one of two directions. Either the organisation runs on Microsoft 365 and somebody is asking whether there is a Google Forms equivalent already included in the licence, or a team that has been using Google Forms for years is being moved onto Microsoft and wants to know what breaks.

Both are reasonable questions with short answers, and the short answers are not about features. Neither tool is meaningfully better at building a form. What separates them is who is allowed to answer, where the responses end up, and what each one refuses to do for people outside your organisation. Those three decide it, and they are the three that pricing pages and feature grids tend to bury.

The comparison is usually settled before it starts

Both tools are free with an account you almost certainly already have. Google Forms comes with any Google account. Microsoft Forms comes with a work or school Microsoft 365 account, and in a reduced form with a free personal Microsoft account.

That means the realistic decision for most teams is not which is better. It is whether to use the one bundled with the identity system the organisation already runs on, or to introduce a second one. Introducing a second one has a cost that shows up later: responses in a place the rest of the company cannot reach, a form owned by an account that leaves with an employee, an export nobody can find.

So the default answer is to use whichever matches your existing accounts, and to spend the evaluation effort on the specific places where that default fails. There are three, and all three are about the people filling in the form rather than the people building it.

Documented limits, side by side

Microsoft publishes its limits. Google largely does not, which is itself worth knowing when you are planning something at scale.

Microsoft Forms Google Forms
Forms per user Up to 400, including the recycle bin Not published
Responses per form Up to 5,000,000 on standard accounts Not published
Responses, free personal account Up to 200 Not applicable
Responses, paid personal account Up to 1,000 Not applicable
Questions per form Up to 200 Not published
Characters per question Up to 4,000 Not published
Characters per response Up to 4,000, 200,000 in total per response Not published
Form title Up to 90 characters Not published
Practical ceiling on stored responses The per form response limit The linked spreadsheet, at 10 million cells

Two of those rows matter more than the rest.

The free personal account limit of 200 responses is the one that catches individuals. Somebody builds a form with a personal Microsoft account, sends it to a mailing list, and it stops at 200. A paid personal account raises that to 1,000. Work and school accounts get the full allowance, so this is a problem for individuals rather than organisations, but it is an abrupt one.

The 10 million cell ceiling on Google Forms is not really a Forms limit at all. It is the Google Sheets limit, inherited when responses are linked to a spreadsheet. A form with twenty columns reaches it somewhere around 500,000 responses. For ordinary intake it never binds, and it is worth knowing only because it is the one hard number Google publishes anywhere near this.

There is also a subtlety on the Microsoft side worth flagging for anyone running something large. The one response per person rule is only enforced within a continuous set of 50,000 responses, and is not guaranteed across a larger data set.

Who is allowed to answer

This is where the two genuinely diverge, and it is the section to read if you are collecting from outside the organisation.

Microsoft Forms offers three audiences: anyone can respond, only people in the organisation can respond, or specific people in the organisation can respond. The second and third require the respondent to sign in with a work or school account. The first is open, and it is the setting most public forms need.

Google Forms is open by default, and closes down through publishing controls and responder access rather than through an audience setting. A published form with general access set to anyone with the link behaves the way a public form should. Where Google requires a sign-in is at the level of individual settings rather than the whole form.

The two settings that impose a Google sign-in are worth naming precisely, because both are commonly switched on without noticing the consequence. Limit users to one response requires respondents to sign in to a Google Account, by Google's own documentation. And file upload questions carry the same requirement: to answer one, the respondent must sign in to a Google Account.

Microsoft is stricter on uploads. A file upload question is only available when the form is restricted to people inside the organisation, either all of them or a named list. There is no configuration that accepts an uploaded file from an anonymous respondent.

The practical shape of that: if you need documents from people outside the organisation, Microsoft Forms is out and Google Forms will cost you everyone who does not have, or does not want to use, a Google account. This single constraint sends more teams to a third party form tool than any other, and it is why job application intake and grant submissions so rarely run on either.

Where the responses land

Google Forms writes to a Google Sheet, and that spreadsheet is the working surface for most teams: filter it, add a column, share it with whoever needs it. Microsoft Forms keeps responses in the form and exports to an Excel workbook, which is also how you free up headroom if a form approaches its response limit, since exporting and then clearing responses lets collection continue.

Functionally these are close enough that the difference is not worth a long paragraph. What is worth saying is what happens next, because it is identical in both and it is where the hours go.

A spreadsheet of responses has no state. There is no field that says who is dealing with this one, no record of whether a reply was sent, no history of what changed. Teams invent those: a status column, a colour, an owner initial, a separate thread in chat. They work. They work until somebody forgets to update the column, or two people sort the sheet at once, or the person who understood the colour scheme is away.

That is not a criticism of either tool. Neither was built to run a queue. It is a reason to be clear about which half of the job you are buying. If the responses only need to be counted, charted and read, both tools finish the job. If each response opens a small case that stays open until somebody answers it, both tools hand you the case and stop.

Collaboration and who owns the form

Google Forms shares through Drive permissions. Adding an editor is the same gesture as sharing a document, which is familiar and fast. The form belongs to the account that created it, and a form created in a personal account by an employee leaves with them, which is a real operational risk worth checking.

Microsoft Forms has an equivalent collaboration link, and forms can belong to a group rather than an individual, which removes the ownership problem in organisations that use it. That is the stronger arrangement for anything the organisation depends on.

Both give collaborators full edit rights rather than a read only view of responses. If you want somebody to see the answers without being able to change the questions, neither tool has a clean answer, and that gap is another common reason teams look elsewhere. Tools that distinguish between an administrator, an ordinary member and a view only role handle this natively, and it is worth checking against the feature list of anything you compare.

What neither one does

Worth stating plainly, because it is the part that decides whether either tool is enough.

Neither assigns an owner to a response. Neither tracks a status through to completion. Neither records that a reply was sent, or keeps a history of what changed and when. Neither sends a reply from inside the response list, which means replies go from personal mailboxes and nobody else can see that they went. Neither builds a contact record, so the same person answering three forms is three unrelated rows.

For a satisfaction survey, none of that is missing. For an application process, a support queue, an event registration with a waiting list, or an enquiry form that people expect an answer to, all of it is. The usual sequence is that a team runs on Google Forms or Microsoft Forms perfectly happily for a year, then adds a status column, then adds a second sheet, then adds a chat channel to coordinate the two, and at some point notices that the coordination costs more than the collection.

Form tools that keep the stage, the owner and the reply attached to the response are solving that second half rather than competing on question types. Whether you need one depends entirely on whether your responses are data or cases, and looking at how different intakes are structured is a quicker way to answer that than a feature comparison.

Choosing between them in five minutes

Answer three questions in order and the decision usually makes itself.

Do people outside the organisation need to upload a file? If yes, Microsoft Forms cannot do it at all, and Google Forms will require each of them to sign in to a Google Account. Either accept that or look at a third tool.

Which identity system does the organisation already run on? Use the matching tool unless the first question rules it out. A form that belongs to the same directory as everything else survives staff changes and audits; one that does not becomes an orphan.

Do the responses need to be worked on, or only read? If a person has to act on each one and tell somebody the outcome, budget for what you will put around whichever tool you pick, or pick something that includes it.

Everything else, the question types, the theming, the branching logic, is close enough between the two that it should not decide anything.

What to change first

Run the upload test before you commit: send the form to a phone that is not signed in to anything and try to submit it. If that works, the bundled tool is fine and there is nothing to change. If it does not, or if the replies are already going out from personal mailboxes, look at Halict and the other tools that keep the response and the reply in one place.

Q1. Is Microsoft Forms the equivalent of Google Forms?

For building and sending a form, yes. Both are included with an account most people already have, both handle the common question types and branching, and both export results to a spreadsheet. The differences that matter are about who is allowed to answer and how file uploads are restricted, not about the form builder itself.

Q2. Can people without a Microsoft account fill in a Microsoft Form?

Yes, if the form is set so that anyone can respond. The restriction appears when you turn on organisation only access, which requires a work or school account, and when you add a file upload question, which is only available on forms restricted to the organisation.

Q3. How many responses can a Microsoft Form receive?

Up to 5,000,000 on standard work and school accounts. Free personal Microsoft accounts are limited to 200 responses per form and paid personal accounts to 1,000. Each form also allows up to 200 questions, and a single user can create up to 400 forms including those in the recycle bin.

Q4. Why does Google Forms ask respondents to sign in?

Two settings cause it. Limiting users to one response requires a Google Account so the form can tell people apart, and file upload questions require one so the uploaded file can be attributed and stored. Turn both off and the form is answerable by anyone with the link.

Q5. Which one is better for collecting job applications?

Neither is a natural fit, because both restrict file uploads. Microsoft Forms cannot accept an upload from outside the organisation at all, and Google Forms requires each applicant to sign in to a Google Account. Teams collecting documents from the public usually end up on a dedicated form tool for that reason alone.

All guides

Microsoft Forms vs Google Forms: how the two compare for a working team | Halict