How to Bulk Import Questions Into Microsoft Forms

To bulk import questions into Microsoft Forms, open Forms, select Quick Import at the top left of the page, and choose a Word or PDF file from your local drive. Forms converts the document into questions, then shows you a review screen with the items it wants you to check. The file has to be 10 MB or smaller, it has to come from your computer rather than OneDrive, and only multiple choice and open text questions convert.

That is the whole mechanism. It is genuinely useful and most people do not know it exists, because for years the answer to this question was a resigned no. It also has sharp edges that are easier to learn from a list than from a failed import at 10pm.

Can I import questions into Microsoft Forms?

Yes. Microsoft added Quick Import specifically for this: you hand Forms a Word document or a PDF that already contains a form or quiz, and it converts the content into form questions rather than making you retype it. Microsoft's own documentation is explicit that the source must be a Word or PDF file on your local hard drive, with a 10 MB size cap.

What Quick Import is not is a question writer. If you feed it a chapter of a textbook, it will not produce a quiz about the chapter. It converts a document that is already shaped like a quiz. The distinction sounds pedantic until you watch someone upload a fifty page policy PDF and get back a form with one long text question in it.

What exactly converts, and what gets dropped

Here is the honest breakdown, drawn from Microsoft's support documentation for converting a Word or PDF form to Forms.

The two lines worth tattooing on the back of your hand are the last-but-three and the last-but-two. No answer key comes across, and no images come across. Every other surprise people report about Quick Import traces back to one of those.

Is there a way to import questions into Microsoft Forms from Excel?

Not directly. Quick Import accepts Word and PDF, and Excel is not on the list. People ask this constantly because a spreadsheet is the obvious way to hold a hundred questions, and because Forms writes its results out to Excel, which makes the reverse feel like it ought to exist.

The workable versions are all indirect. You can paste your spreadsheet columns into a Word document, format them as numbered questions with lettered options, and Quick Import that. You can build a Power Automate flow against the Forms API if your tenant allows it and you have the patience. Or you can accept that for anything under about forty questions, copying into a Word file takes less time than either.

Formatting that imports cleanly

Microsoft asks for content arranged vertically and in line with the title, with questions and answer options clearly separated. Translated into practice:

• One item per line. Never put a question and its options on the same line.
• Number each question with a plain 1., 2., 3. at the start of the line.
• Start each answer option with a., b., c. or a simple bullet.
• Leave a blank line between questions so the boundary is unmistakable.
• Strip out tables, text boxes, figures, and anything in two columns.

A document that follows those five rules imports almost perfectly. A document that breaks them produces a form where three questions have merged into one and the options have become part of the question text, and fixing that by hand takes longer than the import saved.

This is also the argument for generating the questions rather than lifting them out of an old handout. A generated set is already plain, vertical, numbered text with no figures in it, which happens to be exactly the shape Quick Import wants. If you start from a PDF of source material, a PDF to Microsoft Forms workflow gives you a Word file that is import-ready and an answer key to work from during the next step.

Do correct answers import into Microsoft Forms?

No. Quick Import brings the question text and the answer options across, and stops there. You open the form, switch it to quiz mode, and click the correct option on each question to mark it, adding point values as you go. Forms cannot infer which option is right from a document, even when the document says so.

Budget about fifteen seconds per question for that pass. On a twenty item quiz it is five minutes with the answer key open beside you, which is why keeping the key as a separate file matters more than it seems. If your key is buried in the same document as the questions, you will spend the whole pass scrolling.

What to do after the import, in order

1. Work the review screen. Forms highlights the questions it is unsure about. Those flags are accurate more often than not.
2. Fix the collapsed questions. Anything that was matching or multi-blank is now a text box. Decide whether to rewrite it as multiple choice or leave it as a written response.
3. Switch to quiz mode and set answers. Settings, then quiz mode, then mark each correct option and assign points.
4. Set your result visibility. Decide now whether students see their score immediately, and whether they see which questions they missed.
5. Take the quiz yourself once. Two minutes. It catches the duplicated option and the question with no correct answer set, which are the two failures that generate the most email.

Where bulk import actually pays off

The gain is not on a five question exit ticket. It shows up in three places. First, long compliance and policy checks, where thirty questions have to exist and be defensible and nobody wants to type them into a browser one at a time. Second, question banks, where you generate forty or fifty items from a source document and import them as several forms to draw from later. Third, anything recurring, because next quarter's version starts from a document you can edit rather than a form you have to rebuild.

In a corporate setting the Forms quiz is usually the last mile rather than the whole system. If the record of who completed what has to survive an audit, the quiz eventually belongs inside the platform that tracks training and certification across the whole company, with Forms doing the quick knowledge checks in between. For a single classroom, Forms alone is completely adequate and always will be.

What is the file size limit for Microsoft Forms import?

10 MB, and the file must come from your local hard drive rather than a cloud location. In practice a text-only question document never approaches that, even at two hundred questions, because plain text is tiny. The limit bites when someone tries to import the original source PDF, complete with scanned page images, instead of a document containing the questions. That file is both too large and the wrong kind of content.

If your source material is a scan, the fix is upstream: turn the scan into questions first, then import the resulting text document. Trying to Quick Import a photocopied packet directly gets you nothing useful, because there are no questions in it yet.

The short version

Quick Import is real, it is free, and it saves an hour a week for anyone who runs quizzes in Microsoft 365. Give it plain numbered text with lettered options and no pictures, keep the file local and under 10 MB, and expect to set the correct answers yourself afterward. The remaining problem, and the one worth solving separately, is where the questions come from in the first place. Once you stop writing them by hand, the import is the easy part.