If your business already runs on Microsoft 365, Forms is sitting there paid for. It will build a workable order form in about fifteen minutes, it has a QR code built in, and results open straight into Excel. For a school fundraiser, a staff lunch order, or a wholesale account list, that is often the whole answer.
There is one thing to check before anything else, because it decides whether the rest of this guide is worth your time.
The build, step by step
Forms lives at forms.cloud.microsoft now — the older forms.office.com and forms.microsoft.com addresses redirect there, though plenty of Microsoft's own documentation still names the old ones.
- 1
Start a new form
From the Forms home page, click New Form. Give it a title customers will recognise and use the description underneath for your terms: what is available, the ordering deadline, the pickup date and address, and how payment works.
- 2
Add the customer detail questions
Click + Add new and choose Text. One question for the full name, one for the phone number, both switched to Required. Leave Long answer off for these — it is a toggle in the question, and a single-line box is the right shape for a name.
- 3
Add one question per product
There is no product field in Forms, so a product is a Text question whose title carries the name and the price: "Sourdough loaf — $8". The customer types a quantity. Do not use a Choice question with your products as options — you will learn who wants what and never how many.
- 4
Restrict the quantity to a number
On each product question, open the … menu (labelled More settings for question) and choose Restrictions. Set it to Number and pick the comparison that matches your rule — a between-style restriction with 0 and your per-order maximum is the usual choice. This caps one order, not your total stock. That distinction matters more than anything else on this page.
- 5
Add the pickup slot
A Choice question listing your collection windows, set to Required. If the list runs long, the … menu has a Drop-down toggle that turns the radio buttons into a compact dropdown.
- 6
Add the notes field
A Text question with Long answer switched on, for allergies or special instructions. If you sell food, make it Required and word the title so "none" is clearly an acceptable answer.
- 7
Open it to the public
Click Collect responses. On a work or school account the default is your organisation only, which will silently block every customer — change it to the option that lets anyone respond. This is the single most common reason a Microsoft Forms order form appears to work and collects nothing.
- 8
Copy the link and download the QR code
In the same Collect responses panel: Copy link, with a Shorten URL checkbox (work and school accounts only — personal accounts and mobile do not get it). Beside it, the QR code option downloads a .png. Print it at an inch and a half or larger for a counter or market stall.
- 9
Set the deadline and the notifications
Open Settings. Set a Start date and End date to open and close ordering — unlike Google Forms, you get both rather than one. Turn on Get email notification of each response so orders do not sit unseen, and use Customize thank you message to give people the pickup date, the address, and what happens next.
- 10
Open the results in Excel
The View responses tab has Open results in Excel. On a work or school account this creates a workbook in OneDrive or SharePoint with a live connection back to the form — it refreshes when you open it, not continuously. On a personal account you get a static copy with no ongoing link to the form.
To run the same drop again next week, find the form in your list view and use More options > Copy. It duplicates the questions and settings without the responses, and appends "(1)" to the name.
Getting a total
Forms cannot multiply, so this happens in the Excel workbook. Add a sheet with your product names and unit prices in the same order as the questions, then put a SUMPRODUCT across each response row against the price column — the Excel order form guide walks through the exact formula and its traps. A SUM under each quantity column gives you the per-product totals that become your production list.
On a work or school account the live-linked workbook makes this less painful than the Google Forms equivalent, because the connection survives. It still means the customer never sees a total, and you are still the one doing the arithmetic.
Where a Microsoft Forms order form breaks
No prices, no totals, and Math is not what it sounds like
There is no price field, no calculation field, and no running total. If you find the Math option in the question menu and hope you have found the answer, you have not: Math is a quiz feature. It gives you an equation keyboard, suggests correct answers, and generates similar practice questions. It cannot multiply a quantity field by a price.
No stock limits, at all
This is the hard stop for most sellers. Restrictions cap what one person can order. Nothing caps what everybody can order between them. There is no per-choice quantity limit, no sold-out state, and no way to disable one item while the rest of the form keeps selling. Your only levers are switching Accept responses off, or letting the end date arrive — both of which close the whole form.
Branching cannot do quantities, and it only moves forward
Forms has branching, and it is genuinely useful for "pickup or delivery" style splits. But it routes on which answer someone picked, not on how many they typed, and Microsoft documents a firm constraint: you can only branch to a later question, never back to an earlier one. Any logic more complex than a fork is out of reach.
No order numbers
A response has a timestamp and a row in a spreadsheet. There is no reference on the customer's confirmation, which means "I definitely ordered two" is settled by you searching a workbook by name.
File upload will not work on a public form
Worth knowing if you sell anything custom: the File upload question requires the form to be restricted to your organisation. On a form open to the public — which every consumer order form is — it is simply unavailable. If you need artwork or a reference photo with an order, ask people to email it, or use something else.
"One response per person" is weaker than it reads
The setting exists on work and school accounts, but Microsoft notes it is only enforced within a continuous set of 50,000 responses. For a small business that is academic. It is worth knowing the guarantee is not absolute before you build a rule around it.
Microsoft Forms versus Google Forms, for orders
They are close cousins, and the honest summary is that neither is an ordering tool. Where they differ:
| Microsoft Forms | Google Forms | |
|---|---|---|
| Response cap | 5,000,000 on work/school; 200 free personal, 1,000 paid personal | No published cap on any account |
| QR code | Built in, downloads as a .png | None — use your browser's |
| Scheduling | Start date and end date | Close on a date or after N responses — one, not both |
| Spreadsheet | Live-linked Excel on work/school; static copy otherwise | Always a live-linked Google Sheet |
| Per-item stock caps | None | None natively; add-ons exist |
| Totals, order numbers, payments | None | None |
Pick Microsoft Forms if you are on a work or school account and want the QR code and the date window. Pick Google Forms if you are on a free personal account, where the 200-response cap makes Microsoft's version unusable for a real drop.
When to move on
The signals are the same as with any survey tool pressed into service as a shop. You have oversold something because nothing counted stock. You are doing arithmetic in a workbook on a Friday night. A customer asked what their order comes to and you had to work it out. Or you hit a response cap mid-round.
What to look for is not a longer feature list — it is four specific things: a price beside every product, a cap that counts across all orders, an order number on every confirmation, and a page that reads like a shop. The Jotform alternatives roundup compares the paid options on exactly those terms.
