In Excel: copy the table in Word (Ctrl+C), click a cell in Excel and paste (Ctrl+V) — each Word cell lands in its own Excel cell; for text that isn't a table, save the document as Plain Text (.txt) and import it via Data ▸ Get Data ▸ From Text/CSV.
In Word, click inside the table and select it (Layout ▸ Select ▸ Select Table), then press Ctrl+C.
In Excel, click the top-left destination cell and press Ctrl+V.
Open the paste options button and pick Match Destination Formatting so the data adopts the sheet's styles.
If one Word cell turned into several Excel rows, the Word cell contained line breaks — remove them in Word first (Ctrl+H, replace ^l with a space) and paste again.
For non-table text, save the document as Plain Text (.txt) in Word, then use Data ▸ Get Data ▸ From Text/CSV in Excel.
Clean up with =TRIM(A1) for stray spaces and Data ▸ Text to Columns for text that should split into fields.
What this does
Excel has no "open .docx" option, so converting means moving the content across yourself. A Word table pastes cleanly: rows become rows, cells become cells, and the paste options button lets you choose Keep Source Formatting (Word's look) or Match Destination Formatting (the sheet's look). Plain paragraphs paste into a single column, so structured non-table text is better saved as .txt and imported, then split with Text to Columns. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. For “convert word to excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected cells change, and only then apply the same setup to the full sheet. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That is what makes a data step that keeps your analysis trustworthy useful in real work: repeatable, auditable, and not dependent on memory or luck.
A worked example
A Word invoice table has columns Item, Qty, Price with rows Bolt M8 / 42 / 0.15 and Nut M8 / 120 / 0.08. Select the table, press Ctrl+C, click A1 in Excel, press Ctrl+V and choose Match Destination Formatting: the data lands in A1:C3 as ordinary cells you can sum with =SUM(C2:C3), giving 0.23. Reports and invoices often arrive as Word documents while the analysis happens in a spreadsheet; converting properly avoids retyping and the errors that come with it. One habit worth forming early: name the cells that hold your inputs, so the formula reads in plain language instead of a string of cell addresses. A reviewer — or you in three months — can then follow the logic without decoding what B7 and D2 were supposed to mean, which is most of what makes a sheet maintainable.
In Google Sheets
If you are in Google Sheets rather than Excel, the good news is that the formula shown here is identical and the workflow barely changes — menus sit across the top instead of in a ribbon, and a few function names differ slightly, but anything you build here moves across with little or no rework. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top, the tool proves it, and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. Treat “convert word to excel” as a small building block rather than a chore. Once the inputs sit in their own cells and the formula reads from them, the same setup answers a dozen related questions with a tweak, and Excel keeps every dependent figure current as the data changes. The tool above is there so you can rehearse and verify before committing anything to a real workbook; the steps and worked example are there so the logic sticks. Get it right once and it stops costing you time — it starts saving it, every time the question comes back around.
Common mistakes
- Pasting a table whose cells contain line breaks — each break spawns an extra Excel row.
- Expecting the pasted table to stay linked to the Word file; the paste is a static copy.
- Keeping Word's formatting when the sheet should look uniform — choose Match Destination Formatting.
- Retyping structured text instead of saving as .txt and importing via From Text/CSV.
- Carrying merged Word cells into Excel, where they break sorting and filtering.
Frequently asked questions
How do I convert a Word table to Excel?
Select the table in Word, press Ctrl+C, click a cell in Excel and press Ctrl+V. Use the paste options button to control formatting.
Why did one Word cell become several Excel rows?
The Word cell contains line breaks. Replace ^l (and ^p) with a space via Ctrl+H in Word before copying, or rejoin the rows in Excel.
Does this work in Google Sheets?
Yes. Copy the Word table and paste it straight into Sheets, or save the document as .txt/.csv and use File ▸ Import.
Other ways people ask this
People reach this page typing “how to convert word to excel”, “convert word file to excel”, “convert word doc to excel” and “how to convert a word document to excel”, among other phrasings; whichever wording you used, the fix above is the one you want.
Platform & version notes
- Some variants pin a specific edition (the web version). The method above is stable across recent Excel releases — older versions only differ in where a ribbon icon sits, not in what the steps achieve.
Does this still work in older versions?
It does. The approach has been stable across recent Excel releases; only the ribbon icons have shifted cosmetically, so the steps above still apply.
Why do people search for this in so many different ways?
Because the same task has many names. “how to convert word to excel”, “convert word file to excel”, “convert word doc to excel” all point at the one operation explained on this page, which is why they all lead here.