Draft survey questions with Claude and turn them into a Microsoft Form with Copilot

← All use cases / Small business

ToolClaudeMicrosoft Copilot

A Microsoft 365 user wanted some feedback, so they wrote down their objectives and had Claude help create the survey questions. They then used Copilot to enter those questions into Microsoft Forms, which converted them into the right question types, ready to email out, with Copilot also on hand to help analyse the answers.

Prompt to copy
I want to run a short survey for [WHO, E.G. MY CUSTOMERS OR MY TEAM]. What I want to find out: [LIST 2-4 OBJECTIVES]. Please write [NUMBER] survey questions that cover those objectives and take under five minutes to answer. For each question say the best format (multiple choice, rating scale, or short text) and give the answer options where needed. Keep the wording neutral so it doesn't lead people towards an answer, put the easiest questions first, and end with one open question. Format it as a numbered list I can paste into Microsoft Forms.

Replace the [PLACEHOLDERS] with your own details before you send it.

How to try it

  1. Write down, in a sentence or two, what you want the survey to tell you and who will answer it.
  2. Ask Claude to draft the questions, with the format and answer options for each, and edit anything that doesn’t sound like you.
  3. Open Microsoft Forms and use Copilot to create a form from your list of questions, then check every question type and option it set up.
  4. Preview the form on your phone, ask a colleague to try it, then share the link by email.
  5. When the answers are in, ask Copilot for a summary of the main themes, then read a sample of the responses yourself.

Why this works

Most surveys go wrong at the start: too many questions, leading wording, or answers you can’t do anything with. Starting from your objectives keeps every question earning its place. Getting the questions into a form is fiddly work, and handing it to Copilot saves the copying and clicking. The poster’s tip also stands: the brand names stay the same while the models behind them keep changing, so judge the tools by the results you get.

Tips to get a better result

  • Aim for eight questions or fewer; response rates drop quickly on long forms.
  • Use rating scales for things you want to track over time, and repeat the same survey every few months.
  • Say in the first line how long the survey takes; ‘two minutes’ gets more replies than silence.
  • For making sense of the answers, our guide to analysing customer feedback with AI has prompts that work with any tool.

Common mistakes

  • Asking two things in one question, such as ‘Was our service quick and friendly?’, which leaves you unsure what the answer means.
  • Sending the form without testing it; a broken branch or a missing option puts people off.
  • Pasting customers’ names or email addresses into a chat to analyse results when you don’t need to. Remove personal details first.

Try a variation

Here’s a variation of our own to try next:

Here are the answers from my survey: [PASTE RESPONSES, WITH NAMES REMOVED]. Group the open-text answers into themes, tell me how many people mentioned each, quote two short examples per theme, and suggest three changes I could make based on what people said.

Related

Read the full guide →

More small business use cases

Spot your customers’ hidden problems in old emails with Claude

One business owner fed six months of client emails into Claude and asked it to find patterns. It surfaced three problems his clients were having that he hadn't noticed, and he built a solution for each.

Full guide →

Turn job photos and notes into invoices and proposals with ChatGPT

Plumbers at Oak Creek Plumbing & Remodeling near Milwaukee carry tablets with ChatGPT to create invoices and work proposals and to brainstorm tricky problems. They photograph something like a broken water heater, or type their observations, and get a list of recommendations; the company president says even older staff are amazed by the answers.

Full guide →
Source: CNN

Reference: Hacker News comment by skfiehcusjcn