How to Use Copilot Prompts to Generate Comparison Tables With Pros and Cons

You need to create a clear comparison table that shows the pros and cons of two or more options. Manually formatting a table and researching each point takes time and effort. Copilot can build this table for you inside Microsoft 365 apps like Word, Excel, and Outlook. This article explains how to write effective prompts that produce accurate comparison tables with pros and cons. You will learn the exact prompt structure, how to refine the output, and what to avoid.

How Copilot Generates Tables From Prompts

Copilot uses large language models to parse your natural language request and convert it into structured output. When you include keywords like “table”, “compare”, “pros”, and “cons”, Copilot recognizes the output format you want. The feature works inside Microsoft 365 apps that support Copilot, including Word, Excel, OneNote, and Outlook. No special training or coding skills are needed. You simply type a clear request, and Copilot generates a formatted table. The quality of the table depends directly on the specificity of your prompt.

The key to a good comparison table is providing enough context. Copilot does not know your industry or the exact items you want to compare unless you tell it. For example, a prompt like “Compare cloud storage plans” produces a generic table. A prompt like “Compare Microsoft OneDrive for Business and Google Drive for a team of 50 people using Office apps” produces a table tailored to your scenario. Always include the number of items, the criteria, and the audience or use case.

Steps to Write a Prompt for a Pros and Cons Comparison Table

Follow these steps inside any Microsoft 365 app where Copilot is available. The steps are the same for Word, Excel, and Outlook.

1. Open Copilot in the target app
   Click the Copilot icon in the ribbon or press Alt+Shift+Space to open the Copilot pane. In Word, the pane opens on the right side of the document. In Excel, it opens above the grid.
2. Write a context sentence
   Start with a sentence that sets the scope. Example: “I am choosing a project management tool for a marketing team of 15 people.” This gives Copilot the background it needs to generate relevant pros and cons.
3. Add the comparison command
   Type the items you want to compare and include the inline command /table or /proscons. Example: “Compare Asana, Trello, and Monday.com. Show pros and cons in a table. /table” Alternatively, write: “Create a comparison table with pros and cons for Asana, Trello, and Monday.com. /proscons”
4. Specify the columns
   If Copilot does not include the columns you want, add them to the prompt. Example: “Include columns for pricing, free tier limits, integrations, ease of use, pros, and cons.” Copilot will adjust the table structure.
5. Review and refine the output
   Read the generated table. If a row is missing or inaccurate, type a follow-up prompt. Example: “Add a row for mobile app rating.” Or: “Change the pricing column to show monthly cost per user.” Copilot updates the table without regenerating everything from scratch.
6. Insert the table into your document
   In Word, click the Insert button that appears above the generated table. In Excel, Copilot places the table directly into the selected cell range. In Outlook, the table appears in the email body.

Common Mistakes and Limitations When Using Copilot for Comparison Tables

Copilot generates a paragraph instead of a table

This happens when you do not include a table command in the prompt. Always add /table or /proscons at the end of your request. If you forget, type “Format that as a table” as a follow-up prompt.

The pros and cons are too generic or biased

Copilot pulls from public data on the internet and may not reflect your specific business context. To fix this, add constraints to your prompt. Example: “Focus on security features for a financial services firm.” Or: “Exclude pricing because we already have a contract.” You can also manually edit any row after insertion.

The table has too many or too few rows

Copilot decides the number of rows based on the prompt length. If you want exactly three comparison points, say so explicitly. Example: “Compare only on pricing, storage, and collaboration features.” If the table is too short, ask Copilot to add more rows. If it is too long, ask to remove specific rows.

Copilot does not support real-time data

Copilot cannot access live pricing or availability data from vendor websites. The table is generated from pre-existing knowledge up to its training cutoff. For the most current data, use Copilot to create the table structure and then fill in the latest numbers manually.

Copilot Prompt Examples for Comparison Tables

The following table shows three prompt templates you can copy and modify. Each template is designed for a different scenario.

Scenario	Prompt Template	Expected Output
Software selection	“Compare Zoom, Microsoft Teams, and Google Meet for a remote team of 30 people. Show pros and cons for call quality, screen sharing, recording, and pricing. /table”	A table with one row per criterion and columns for each tool plus pros and cons columns
Product purchase decision	“Compare iPhone 15 Pro and Samsung Galaxy S24 Ultra for a photographer. Include pros and cons for camera, battery, storage, and price. /proscons”	A table with one row per feature and two columns for pros and cons per device
Business process choice	“Compare hiring a full-time employee vs using a freelancer for social media management. Include pros and cons for cost, control, scalability, and expertise. /table”	A table with one row per factor and columns for employee, freelancer, pros, and cons

If Copilot Still Has Issues After the Main Fix

Copilot returns output in a language other than English

This can occur if your Microsoft 365 account language or region is set to a non-English locale. To fix this, go to File > Options > Language and set the editing language to English. Then restart the app and regenerate the prompt.

The table does not appear in the document after generation

In Word, the table appears in the Copilot pane but is not automatically inserted. You must click the Insert button. In Excel, the table overwrites the selected range. If nothing happens, select an empty range of cells first, then run the prompt again.

Copilot refuses to generate a comparison with pros and cons

Copilot may decline if the request asks for subjective opinions about sensitive topics like medical treatments or legal advice. Rephrase the prompt to focus on objective features. Example: Instead of “Compare therapy methods”, use “Compare the features of cognitive behavioral therapy and dialectical behavior therapy based on published research.”

Copilot Pro vs Copilot for Microsoft 365: Key Differences for Table Generation

Item	Copilot Pro	Copilot for Microsoft 365
Apps supported	Word, Excel, PowerPoint, OneNote, Outlook on the web	Same apps plus Teams, Viva Engage, and Power Platform connectors
Context length	Up to 4,000 tokens per prompt	Up to 8,000 tokens per prompt
Data grounding	Public internet data only	Public internet data plus your Microsoft Graph data, files, and emails
Table size limit	Up to 10 rows and 6 columns	Up to 20 rows and 10 columns
Follow-up edits	Supported	Supported with richer refinement options

If you need larger tables or tables that include data from your own documents, use Copilot for Microsoft 365. For basic comparison tables from public knowledge, Copilot Pro is sufficient.

You can now generate a comparison table with pros and cons in any Microsoft 365 app using a structured prompt. Start by writing a context sentence, then add the items to compare and the /table or /proscons command. Specify the columns you need and refine the output with follow-up prompts. For the most accurate tables, include constraints that match your business scenario. After inserting the table, manually verify any time-sensitive data such as pricing or availability.