08 — Copilot in Forms

Your AI Usage Guideline has been presented to the team. Now you want to know two things: do they understand it, and is it actually useful? Copilot in Forms lets you build both a knowledge quiz and a feedback survey from your guideline document in minutes.

Prompts to Try: Open the copy-paste prompt exercises for this topic.


Continuing from Topic 07

You have the approved AI Usage Guide as a Word document and a PDF export. In this topic you will feed that document into Copilot in Forms to generate two things:

  1. A knowledge quiz to check whether staff have understood the key rules
  2. A feedback survey to find out whether the guideline is practical and clear

The responses you collect will be exported to Excel and analysed in Topic 09. You do not need to wait for real responses — the workshop sample dataset is pre-populated and ready to use.

Before you start: Make sure your AI Usage Guide is saved to your OneDrive. Copilot in Forms pulls files directly from your Microsoft 365 account. If you only have it on your desktop, upload it to OneDrive first.


What Copilot Can Do in Forms


Getting Started: The Forms Home Screen

Access Microsoft Forms at forms.cloud.microsoft.

Create new form

The Forms home screen. Click New Form to create a feedback survey or New Quiz to create a scored knowledge check. Quick import lets you import questions from an existing file, and Explore templates offers ready-made starting points.

For this workshop you will use New Quiz for the knowledge check and a separate New Form for the feedback survey.


Step 1: Attach Your AI Usage Guide

When the form or quiz editor opens, the Draft with Copilot box appears at the top. Click the paperclip to attach your document, then describe what you want (see prompts.md) and click the send arrow.

Attaching the guideline in Copilot Forms

Callout 1: the paperclip icon to attach a file from your Microsoft 365 account. Callout 2: your AI Usage Guide document in the file list (type after the / to search). Select it as the source for Copilot to generate questions from.


Step 2: Review the Generated Form

Copilot first shows the draft questions in a preview (“Remove the questions you don’t want”), with the correct answers ticked and answer explanations included. At the bottom of the preview, you can keep the draft, regenerate it, delete it, or refine it.

Keep it or refine

Callout 1: Keep and continue with Copilot. Callout 2: regenerate. Callout 3: delete the draft. Callout 4: add more details for Copilot to fine-tune the draft.

When you click Keep and continue with Copilot, the questions are added to your form and a Copilot panel opens on the right. Copilot automatically reviews the form and lists suggestions to improve it.

Generated form with suggestions

The kept quiz on the left, and Copilot’s review suggestions in the panel on the right.


Step 3: Review and Apply Suggestions

Review and finish suggestions

Copilot’s suggestions for the form. In this example it recommends requiring every question, shuffling questions, adding a completion message, and adding a scenario-based question. Click Apply suggestions 1–4 to apply them all, or type in the Copilot box to apply only the ones you want. Set up distribution helps you plan the launch.


Step 4: Collect Responses

Once you are satisfied with the form, click Collect responses in the top bar.

Collect responses button

The Collect responses button in the top bar of the form editor.

This opens the distribution panel where you can configure how responses are collected.

Options for collecting responses

The Send and collect responses panel:


Step 5: View Responses

After responses come in, click View responses in the top bar.

View responses

Click View responses (top bar) to see the Responses Overview — a live summary of all responses as they come in, with Back to questions to return to the editor.


Step 6: Export to Excel for Topic 09

This step is important. The Excel file you export here is what you will use for analysis in Topic 09.

Open results in Excel

At the top right of the Responses Overview, your responses are already linked to an Excel workbook (callout 1) — click it to open the results in Excel for the web. Use the drop-down arrow for Open in Excel Desktop (callout 2), Download a copy, or Disconnect and sync to a new workbook.

Where to find the Excel file after exporting:

Microsoft Forms keeps the linked workbook in your OneDrive. The file is named after your form title, and the folder it lives in is shown under the file name on the Excel card. Clicking the card opens it immediately in Excel for the web.

To find it later:

  1. Go to onedrive.live.com or open OneDrive from the Microsoft 365 app launcher
  2. Search for your form title, or open the folder shown on the Excel card
  3. Look for a file with your form title ending in .xlsx

Download: AI_Guideline_Survey_Responses.xlsx if you do not have real responses yet. It contains 100 simulated responses across 8 departments and is ready to use in Topic 09.


Tips for Copilot in Forms