How to Convert a Word Table to Excel (Without Copy-Paste Mess)
The quickest way is to drop the .docx file into a Word-to-Excel table converter: each Word table becomes its own worksheet with one value per cell. For a single small table, copy it in Word and use Paste → “Match Destination Formatting” in Excel.
Method 1: Convert the whole document (best for many tables)
- Save your document as .docx (in Google Docs: File → Download → Microsoft Word).
- Open the Word Tables to Excel tool and drop the file in.
- Check the preview of each table the tool found.
- Choose “one sheet per table” and download the .xlsx file.
Because the file is read structurally, every cell lands in its own Excel cell. Plain numbers such as 1,250.50 become numeric cells you can sum, while codes with leading zeros such as 00123 stay as text so they are not changed.
Method 2: Copy and paste (fine for one small table)
- In Word, click inside the table, then click the move handle (⊕) at its top-left corner to select it.
- Press Ctrl+C (Cmd+C on Mac).
- In Excel, click the destination cell and use Paste → Match Destination Formatting.
Copy-paste works, but cells containing line breaks are often split across several Excel rows, and merged cells can shift columns. Check the result carefully.
Common problems and fixes
| Problem | Why it happens | Fix |
|---|---|---|
| Text is in one column | It was aligned with tabs or spaces, not a real Word table | In Word, select the text → Insert → Table → Convert Text to Table |
| Numbers are left-aligned text | Hidden spaces or a currency symbol | Use Excel’s Data → Text to Columns, or remove symbols first |
| Rows split in two | Line breaks inside a cell during copy-paste | Use the converter, which keeps each cell together |
| Leading zeros disappear | Excel converted “007” to 7 | The converter keeps such values as text |
Going the other way? Excel to Word Table turns a worksheet range like A1:F20 into a native, editable Word table.
Questions and answers
Can I convert a Word table to Excel without losing formatting?
Values, rows and columns are kept exactly. Cell colours, fonts and borders are not copied, because Excel formatting works differently – apply a table style in Excel afterwards.
What about merged cells?
Horizontally merged cells are placed in the first cell of the span, and the remaining cells are left empty, so columns stay aligned.