You have a block of unstructured text in a Word document and need to turn it into a clean, organized table. Manually inserting rows and columns and copying data from plain sentences is time-consuming and error-prone. Copilot in Word can analyze your raw text and generate a properly formatted table in seconds using natural language prompts. This article explains how to use Copilot to convert raw text into tables, what prerequisites are required, and how to avoid common formatting mistakes.
Key Takeaways: Generating Tables From Raw Text With Copilot
- Copilot pane > prompt box: Type “Create a table from the following text” followed by your raw data to generate a table.
- Copilot pane > Adjust table button: Refine column headers, data alignment, or formatting after the initial table is created.
- Word > Copilot > Insert as table: Use the Insert as table option to place the generated table directly into the document body.
What Copilot Table Generation From Raw Text Does
Copilot in Word uses the Microsoft Graph and natural language processing to read unstructured text and extract structured data. When you provide a block of raw text, Copilot identifies entities, attributes, and relationships and maps them into a table with columns and rows. The feature does not require manual column definition. You simply describe what you want in plain English.
Prerequisites for this feature include an active Microsoft 365 Copilot license, a Word document open in the desktop app or Word for the web, and an internet connection. The Copilot pane must be visible. If you do not see Copilot, go to the Home tab and click the Copilot button in the ribbon.
Steps to Generate a Table From Raw Text Using Copilot
Follow these steps to convert raw text into a table in Word. The process works in both the desktop and web versions of Word.
- Open the Copilot pane
In Word, go to the Home tab and click the Copilot button in the upper-right area of the ribbon. The Copilot pane opens on the right side of the window. - Select your raw text
Highlight the unstructured text in the document that you want to convert. For example, you might have a paragraph listing product names, prices, and stock status. - Write a prompt for table generation
In the Copilot pane prompt box, type a command such as “Create a table from the selected text” or “Turn this text into a table with columns for Name, Price, and Stock.” Press Enter or click the Send button. - Review the generated table preview
Copilot displays a preview of the table in the pane. Verify that the columns and rows match your expectations. If the table is missing data or has extra columns, click the Adjust table button below the preview. - Insert the table into the document
Click the Insert as table button at the bottom of the preview. Copilot places the table at the cursor position in the document. The table uses Word’s standard table formatting with borders and default font. - Refine the table manually if needed
After insertion, use Word’s Table Design and Layout tabs to adjust column widths, apply a table style, or merge cells. Copilot does not overwrite manual changes you make.
Alternative Method: Paste Raw Text Into the Copilot Prompt
If your raw text is not already in the document, copy it from another source and paste it directly into the Copilot pane prompt box. Then type “Create a table from this text” and press Enter. Copilot processes the pasted text and generates a table preview. Insert the table using the same Insert as table button.
Common Mistakes and Limitations When Generating Tables
Copilot Creates Too Many or Too Few Columns
This happens when the raw text contains ambiguous data. For example, a sentence like “John bought apples and oranges” might create two columns instead of three. To fix this, rephrase your prompt to specify the exact column names. For instance, type “Create a table with columns for Name, Item, and Quantity.”
Table Rows Are Duplicated or Missing
Copilot sometimes misreads repeated entries or skips lines. Open the Copilot pane, select the inserted table, and type “Remove duplicate rows from this table” or “Add missing rows for these items.” Copilot updates the table in place.
Copilot Does Not Recognize the Selected Text
If Copilot returns “I cannot find the text you selected,” ensure the text is highlighted before you type the prompt. Also confirm that the document is saved to OneDrive or SharePoint. Copilot requires a cloud-stored file to access the text content.
Table Formatting Is Lost After Insertion
Copilot inserts a plain table without custom styles. Use the Table Design tab in Word to apply a predefined style such as Grid Table 1 Light or List Table. The style changes apply to the entire table.
Copilot Table Generation vs Manual Table Creation in Word
| Item | Copilot Table Generation | Manual Table Creation |
|---|---|---|
| Time to create a 10-row table | 30 seconds | 2-3 minutes |
| Requires column planning | No, Copilot infers columns from text | Yes, you must define columns before inserting |
| Handles ambiguous data | May need prompt refinement | Full control over each cell |
| Works with copied external text | Yes, paste into prompt | No, you must paste into cells |
| Supports bulk edits after creation | Limited to Copilot’s Adjust table feature | Full Word table editing tools |
Copilot table generation is faster for converting large blocks of raw text into structured data. Manual creation gives you more control over complex layouts such as merged cells, nested tables, or custom column widths. Use Copilot for initial conversion and manual tools for final polish.
You can now convert raw text into tables in Word using Copilot prompts. Start by selecting your text and typing a clear command such as “Create a table from the selected text.” If the output does not match your expectations, use the Adjust table button or rephrase your prompt with specific column names. For advanced formatting, apply a table style from the Table Design tab after insertion. This method saves significant time compared to manually inserting rows and columns.