How to Convert Word to Excel (Tables and Data Step-by-Step)

To convert Word to Excel, copy the table or structured text from your Word document and paste it into an Excel worksheet, then use Text to Columns or cleanup tools to fix merged cells, line breaks, and number formats. For tabular data, direct copy-paste is usually fastest; for plain lists, paste into Excel and split columns with the delimiter that matches your source.

Key Takeaways

• Copy the Word table (or select structured text) and paste into cell A1 in Excel—this is the most reliable everyday method.
• Use Paste Special → Text when Excel misreads dates or leading zeros.
• Save as Plain Text (.txt) with tab delimiters when you need a repeatable export from Word.
• After conversion, check merged cells, line breaks inside cells, and number formats.
• WPS Writer and WPS Spreadsheet follow the same copy-paste workflow for .docx and .xlsx files.

Need the opposite workflow—using Excel rows to fill a Word template? Follow our mail merge from Excel to Word guide.

Quick Answer: What “Word to Excel” Really Means

Users searching how to convert word to excel usually want to move structured data—tables, price lists, schedules, or survey results—from a Word document into an editable spreadsheet. Word is built for narrative layout; Excel is built for rows, columns, and formulas.

This guide focuses on extracting data out of Word and into Excel. It does not cover inserting Excel into Word—that is a separate task.

When to Use Each Conversion Method

Method	Best for	Keeps formatting?	Effort
Copy table → paste in Excel	Word tables with clear rows/columns	Partial—borders may shift	Low
Copy text → Text to Columns	Comma- or tab-separated lists	Minimal	Low
Save Word as .txt → open in Excel	Repeatable exports, large tables	Low	Medium
Re-type or OCR	Scanned PDFs or messy layouts	N/A	High

Pick copy-paste for one-off jobs. Use plain-text export when you convert the same Word template regularly.

Method 1: Copy a Word Table into Excel

This works in Microsoft Word, WPS Writer, and most .docx editors on Windows and Mac.

1. Open your Word file and click inside the table.
2. Hover the table move handle (four-arrow icon at the top-left of the table) and click to select the entire table.
3. Press Ctrl+C (Windows) or Cmd+C (Mac).
4. Open Excel or WPS Spreadsheet and click cell A1.
5. Press Ctrl+V / Cmd+V.
6. Review column widths and merged cells—adjust before you run formulas.

Tip: If the table spans multiple pages, select only the section you need, or convert section by section to avoid row gaps.

Method 2: Convert Unstructured Text with Text to Columns

When your Word content is a list—not a formal table—paste first, then split.

1. Copy the list from Word and paste into column A of Excel.
2. Select the pasted column.
3. Open Data → Text to Columns (Excel) or the equivalent split tool in WPS Spreadsheet.
4. Choose Delimited if items are separated by commas, tabs, or spaces.
5. Pick the delimiter that matches your Word list and finish the wizard.

This is useful for contact lists, inventory lines, or any data separated by commas or tabs in Word.

Method 3: Save Word as Plain Text, Then Open in Excel

For larger exports or automation-friendly handoffs:

1. In Word, open File → Save As.
2. Choose Plain Text (.txt).
3. In the encoding dialog, select Tab-delimited if your table used tabs between columns.
4. Open the .txt file in Excel via File → Open, or import through Data → From Text/CSV.

Excel’s import wizard lets you set column data types (text vs. number) before data lands in the sheet—helpful when IDs or zip codes must stay as text.

Method 4: Convert Word to Excel with WPS Office

If you work with both formats and want one suite:

1. Open the .docx in WPS Writer.
2. Select the table or text block and copy.
3. Open WPS Spreadsheet and paste starting at A1.
4. Use Data tools to split columns or trim spaces if needed.

WPS Office opens standard .docx and .xlsx files, so you can move data between Writer and Spreadsheet without installing separate Word and Excel apps. Menu labels may vary slightly by desktop version—test in your current build.

Clean Up Data After Conversion

Converted data often looks messy. Check these items before you analyze or share the sheet:

Issue	What you see	Fix
Merged cells	Formulas skip rows	Unmerge in Excel; fill blank cells
Line breaks in cells	One row spans multiple lines	Find & Replace Ctrl+J with a space, or use CLEAN/TRIM
Numbers stored as text	Green triangle warning	Convert to number or use Text to Columns
Dates wrong	Year/month swapped	Set column format or re-import as text first
Extra spaces	VLOOKUP fails	TRIM function or Find & Replace double spaces
Missing rows	Gaps from page breaks	Re-copy per section from Word

Run a quick sort or filter after cleanup—blank rows and duplicate headers show up immediately.

What Does Not Convert Cleanly

• Nested tables in Word often flatten into extra rows—expect manual fixes.
• Text boxes and floating shapes do not export as spreadsheet cells.
• Heavy styling (custom borders, shading) may not survive; focus on data, not design.
• Scanned images of tables need OCR first—copy-paste will not work until text is selectable.

If your Word file is a scan, use OCR in your PDF or Word tool, then copy the recognized table.

FAQs

Can I convert a Word table to Excel without losing formatting?

You can keep basic row/column structure, but exact Word styling (custom borders, fonts) rarely transfers perfectly. Copy-paste preserves data layout; reapply Excel styles after conversion.

Why does my data look messy after I paste from Word?

Common causes: merged cells, hidden line breaks, mixed delimiters, or numbers formatted as text. Paste into one column first, then use Text to Columns or TRIM/CLEAN.

Can I open a .docx file directly in Excel?

Excel is not designed to open Word documents as spreadsheets. Copy the table or export to .txt/.csv instead.

How do I keep leading zeros when converting to Excel?

Paste using Paste Special → Text, or import the column as Text in the Text Import Wizard. Formatting the column as Text before paste also helps.

Can WPS open both Word and Excel files for this workflow?

Yes. WPS Writer opens .docx files and WPS Spreadsheet opens .xlsx files. Copy data between them the same way you would in Microsoft Office.

Is “convert Word to Excel” the same as embedding Excel in Word?

No. Converting Word to Excel means moving data from a document into a spreadsheet. Embedding Excel in Word means placing a sheet inside a document—the opposite direction.

Summary

How to convert Word to Excel: select the table or structured text in Word, copy it, paste into Excel at A1, then clean merged cells, line breaks, and number formats. For lists, use Text to Columns; for repeatable exports, save Word as tab-delimited text and import. WPS Writer and WPS Spreadsheet support the same workflow on .docx and .xlsx files when you need one free office suite for both steps.