How to Write Copilot Prompts That Output a Two-Column Decision Matrix

You need a clear side-by-side comparison of two options to make a business decision. A two-column decision matrix helps you weigh factors like cost, time, risk, and impact. Copilot in Microsoft 365 can generate this matrix directly in Word, Excel, or a chat pane if you write the right prompt. This article explains the exact prompt structure that forces Copilot to produce a two-column matrix every time. You will learn the required syntax, formatting commands, and common mistakes that break the output.

What a Two-Column Decision Matrix Is and Why the Prompt Matters

A two-column decision matrix compares two options across multiple criteria. Each row represents one criterion such as cost or implementation time. The left column lists the criteria, and the two right columns show the evaluation for Option A and Option B. Copilot can generate this table in seconds, but only if the prompt contains explicit formatting instructions. Without those instructions, Copilot often outputs a paragraph, a bullet list, or a table with too many columns.

The root cause of bad output is ambiguous language. If you write “Compare Option A and Option B,” Copilot may interpret that as a request for a narrative. It may also add a third column for notes or a fourth column for scores. The prompt must use the exact phrase “two-column decision matrix” and define the column headers and row criteria. This forces Copilot to match a known template structure.

Copilot in Microsoft 365 apps such as Word, Excel, and the Copilot chat pane all accept the same matrix prompt syntax. The behavior is consistent across these surfaces because the underlying language model uses the same instruction parser. However, Excel may add automatic formatting that shifts column widths. Word preserves the exact column layout you request.

Steps to Write a Prompt That Produces a Two-Column Decision Matrix

1. Open Copilot in the target app
   In Word, click the Copilot icon on the Home tab. In Excel, click Copilot on the Home tab. In the chat pane at copilot.microsoft.com, open a new conversation. The prompt syntax works identically in all three locations.
2. Start with the exact output command
   Type Create a two-column decision matrix as the first line of the prompt. Do not add any introductory sentences before this command. Copilot scans the beginning of the prompt to decide the output format. A delayed command may result in a paragraph instead of a table.
3. Define the two column headers
   Immediately after the command, write with columns labeled “Option A” and “Option B”. Use the exact labels you want to appear in the header row. If you write “two options” instead of naming them, Copilot may invent generic labels like “Option 1” and “Option 2.”
4. List the row criteria
   Write and rows for the following criteria then list each criterion on a new line using a hyphen. For example:
   – Cost
   – Implementation time
   – Risk level
   – Scalability
   – Maintenance effort
   Each hyphen creates a separate row. Copilot respects the order you specify.
5. Add a scoring instruction if needed
   If you want numeric values in the cells, add Assign a score from 1 to 5 for each criterion at the end of the prompt. Without this instruction, Copilot writes descriptive text such as “Low” or “High” instead of numbers.
6. Request a summary row
   Add Include a total score row at the bottom if you need a sum of the numeric scores. This row appears as the last row of the matrix. Copilot calculates the sum automatically only when you request numeric scores in the previous step.
7. Press Enter or click Send
   Copilot generates the matrix within a few seconds. Review the output for column count. If a third column appears, edit the prompt to add with exactly two columns before the row criteria list.

Common Mistakes That Break the Two-Column Output

Copilot outputs a bullet list instead of a table

This happens when the prompt does not contain the word “matrix.” The word “matrix” is the trigger for table generation. Replace phrases like “compare these two options” with “create a two-column decision matrix.” If the output is still a list, add in a table format after the column header instruction.

Copilot adds a third column for notes or scores

The model sometimes inserts a “Notes” column or a “Weight” column when the criteria list is long. To prevent this, add with exactly two columns and no additional columns after the row criteria. If you need a scoring column, request it explicitly as a separate row rather than a column.

The matrix contains descriptive text instead of scores

Copilot defaults to text descriptions when no scoring instruction is present. If you want numeric scores, include the phrase assign a score from 1 to 5 for each criterion in the prompt. If you want descriptive text, accept the default output. You cannot mix numeric scores and descriptive text in the same matrix without formatting the prompt as two separate requests.

Copilot ignores the row order

When the criteria list contains more than seven items, Copilot may reorder the rows alphabetically. To enforce your order, add preserve the order of the criteria exactly as listed at the end of the prompt. This instruction overrides the model’s tendency to sort.

Copilot Prompt Variations for Two-Column Matrices

Prompt Component	Text Variation	Text Variation
Output command	Create a two-column decision matrix	Generate a comparison table with two columns
Column header	with columns labeled “On-premise” and “Cloud”	with columns named “Vendor A” and “Vendor B”
Row criteria	and rows for Cost, Time, Risk, Scalability	with criteria rows for Price, Speed, Security, Support
Scoring method	assign a score from 1 to 5	use a rating of Low, Medium, High
Summary row	include a total score row	add a weighted average row at the bottom

If Copilot Still Does Not Output a Two-Column Matrix

When the matrix output still contains extra columns or no table at all, open a new Copilot conversation and use a single-sentence prompt. Write Create a two-column decision matrix with columns “Option A” and “Option B” and rows for Cost, Time, Risk, and Scalability. Do not add any introductory text. This minimal prompt removes all ambiguity. If the output is still incorrect, the Copilot service may have a temporary formatting limitation. In that case, copy the generated text into a Word table manually and use Copilot only for the content.