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

Brainstorm content ideas for your small business with ChatGPT

One small-business owner says ChatGPT has helped a lot with brainstorming content ideas and strategies to grow the business.

Full guide →

Brainstorm print-on-demand slogans and spot trends with ChatGPT and Gemini

A Toronto Etsy seller whose shop made about $347,000 in a year uses ChatGPT for prompts like '10 punny, short T-shirt ideas about scuba diving', and asks Gemini, which can search Google in real time, what phrases are trending for sweatshirts.

Full guide →

Reply to vague ‘how much?’ messages from customers with ChatGPT

A micro-bakery owner used to dread 'how much for a birthday cake?' messages with no date or details. Now she pastes them into ChatGPT and asks for a warm reply that requests the date, servings, flavours and inspiration photos and mentions her starting price, then tweaks a couple of words so it sounds like her.

Full guide →

Reference: Hacker News comment by skfiehcusjcn