How to Add Word Doc to Excel

There are two ways to “add word doc to excel”: the quick way you copy and the durable way you understand. This page gives you both. The exact Excel answer is above; below, we build the small mental model that makes the fix stick, so the next variation of the same problem solves itself.

Exact answer

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.

Annotated stepsExcel
1

In Word, click inside the table and select it (Layout ▸ Select ▸ Select Table), then press Ctrl+C.

2

In Excel, click the top-left destination cell and press Ctrl+V.

3

Open the paste options button and pick Match Destination Formatting so the data adopts the sheet's styles.

4

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.

5

For non-table text, save the document as Plain Text (.txt) in Word, then use Data ▸ Get Data ▸ From Text/CSV in Excel.

6

Clean up with =TRIM(A1) for stray spaces and Data ▸ Text to Columns for text that should split into fields.

Ctrl+CthenCtrl+Shift+V+Cthen+Ctrl+VPaste values · WindowsMac

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. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. Treat “add word doc to excel” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected cells shows up while it is still harmless. 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 turns a layout choice that keeps the sheet readable and sortable into a method you can reuse, explain, and defend when the workbook leaves your screen.

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. If there is any chance you will reuse this, drop it into a small template tab right now: a labelled input area on the left and the formula beside it, checked once against the tool above. Next time the same question comes up, the answer is a single paste away instead of a rebuild from memory.

In Google Sheets

Google Sheets handles this almost identically to Excel. The formula syntax above is the same, and the menu lives under a slightly different label rather than a ribbon tab. Use the platform toggle at the top of the page to switch every keyboard shortcut between Windows and Mac, and expect at most cosmetic differences in naming. Keep this page bookmarked for the next time the same question comes up. Better still, rebuild the example once in your own sheet — doing it yourself, with the tool above to check against, is what turns a copied formula into a technique you own. Here is the takeaway for “add word doc to excel”: copy the answer if you are busy, but if you have a spare few minutes, rebuild the example in Excel yourself with the tool above open beside it. That single pass — type it, run it, watch the result move when you change an input — is what turns a formula you found into a technique you trust. Keep your inputs labelled and referenced, never hard-coded, and the same sheet stays correct and auditable as it grows. Done that way, you will not need to look this up again, and you will be the person others ask.

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

On the way here you may have searched this as “how to add a word doc to excel” and “how to add word doc in excel” — it is all the same task, and this page is the single, complete answer to it.

Why do people search for this in so many different ways?

Because the same task has many names. “how to add a word doc to excel”, “how to add word doc in excel” all point at the one operation explained on this page, which is why they all lead here.