Copy a Word table into Excel

Copying a table from Word into Excel is pretty straightforward. Here’s how you can do it:

1. Open your Word document and select the entire table you want to copy.
   • Click the small handle at the top-left corner of the table, or click and drag to highlight the whole table.
2. Copy the table (Ctrl + C or right-click → Copy).
3. Open Excel and select the cell where you want the top-left corner of the table to go.
4. Paste the table (Ctrl + V or right-click → Paste).

Excel will usually preserve the table structure, placing each Word table cell into its own Excel cell.

If the formatting looks off, or everything goes into a single column, try this:

• After copying in Word, in Excel, right-click where you want to paste → choose Paste Special → then select Text or Unicode Text.