Copy and Paste Word to Excel: Tables, Text, and Formatting

To copy content from Word to Excel, select the text or table in Word, press Ctrl+C, click the destination cell in Excel, and press Ctrl+V. A Word table usually becomes cells in Excel; for ordinary text, tabs commonly separate columns and paragraph breaks separate rows.

What happens when Word content is pasted into Excel

Word and Excel use different structures. Word is designed for documents and pages; Excel arranges information in a grid of rows and columns. When you copy a Word table, Excel generally maps each table cell to a worksheet cell, preserving the row-and-column structure. For example, a three-column table with five rows normally occupies three Excel columns and five rows.

Text outside a Word table can paste differently. Paragraphs may appear one below another in a single Excel column. If the copied text includes tab characters, those tabs can divide the content into neighboring columns. The result depends on how the text was arranged in Word, as well as any formatting or special characters it contains.

Word formatting does not always have a one-to-one equivalent in a spreadsheet. Fonts, bold text, shading, borders, and alignment may carry over, but page layout features such as columns, headers, footers, and text boxes do not become spreadsheet structures. Review the pasted range rather than assuming the worksheet will look exactly like the document.

Prepare the Word content before copying

A little cleanup in Word can prevent problems in Excel. If the information is meant to be analyzed or sorted, make sure it is organized as a simple table: one record per row, one kind of detail per column, and a clear header row. Avoid using multiple spaces to imitate columns; spaces do not reliably tell Excel where one field ends and another begins.

Remove blank rows and columns that are only there to improve the page layout.
Check that each table row has the intended number of cells, especially if the table includes merged cells.
Keep headings in a single header row where possible, rather than using several stacked heading rows.
Check values that must retain their exact characters, such as product codes beginning with zero, account numbers, or postal codes.
If you only need part of a table, select that part rather than copying the whole page.

Excel may interpret pasted content as dates, numbers, or other data types. For instance, a code such as 00127 may display as 127 if Excel treats it as a number. A value such as 3/4 may be interpreted as a date depending on regional settings. If exact text matters, plan to set the destination cells to Text before pasting, or use an import method that lets you specify the data type.

Copy a Word table into Excel step by step

In Word, select the table by dragging across its cells, or use the table selection controls to select the full table. Avoid selecting surrounding paragraphs unless you want them copied too.
Press Ctrl+C on Windows. On a Mac, press Command+C.
Switch to Excel and select the upper-left destination cell for the pasted table. Excel fills cells to the right and below that starting point, so make sure the area is clear.
Press Ctrl+V on Windows, or Command+V on a Mac.
Inspect the pasted rows and columns. Check headers, blank cells, merged cells, dates, codes, and values that should remain text.

In Excel for Microsoft 365 on Windows, the Paste Options button may appear near the pasted range. Its available choices depend on what Word placed on the clipboard. Choose a formatting option that suits the worksheet, or keep the default if the result is already usable. If pasting over existing information, remember that the paste can replace cells in the destination area; use an empty area or make a backup first.

When the table is larger than the visible worksheet area, Excel can still paste it into cells, but it may extend beyond the current screen. Use the row and column headings to verify its dimensions. A pasted table is a range of cells; it is not automatically an Excel Table with filter buttons. To make it an Excel Table, select the range and use Insert > Table, then confirm whether the range has headers.

Choose whether to keep or remove formatting

Keeping Word formatting can be useful when visual emphasis matters. For example, a bold header row or shaded warning cell may remain visually distinct. However, copied fonts, fills, and borders can clash with an existing workbook style or make a simple dataset harder to read.

After pasting, use the Paste Options button if it appears and select the suitable option, such as retaining source formatting or matching the destination style. The exact options can vary with the content and Excel version. You can also use Home > Paste to view paste choices. If the formatting is already in the worksheet and you want to remove it, select the pasted cells and use Home > Clear > Clear Formats; this removes formatting but leaves the cell contents.

For a clean data range, consider pasting without source formatting when that choice is offered. Then apply Excel formatting deliberately: use a consistent number format, bold the header row, and add borders only where they help readers distinguish the data. Formatting changes appearance, not the underlying meaning of a value, so check number and date interpretation separately.

Paste plain text or separate text into columns

If a Word table pastes with unwanted styling, try copying it again and using Excel’s Paste Special options. In Excel for Microsoft 365 on Windows, go to Home > Paste > Paste Special after copying; the dialog’s available formats depend on the clipboard content. If a text-only choice such as Text or Unicode Text is offered, select it to paste the content without the Word table’s visual formatting. The exact label is not guaranteed for every copied item.

Plain text is also helpful when Word content has been arranged with tabs. When tabs separate fields and paragraph breaks separate records, Excel can often place the values into columns and rows. If all the text lands in one column, select the pasted cells and use Data > Text to Columns. Choose Delimited, select the delimiter actually used in the text (often Tab), review the preview, and finish the wizard. Do not select a comma merely because the text looks like a list; commas inside names or descriptions could split fields incorrectly.

For instance, text arranged as “Name [tab] Department” on the first line and “Ravi [tab] Sales” on the next can form two columns and two rows. The bracketed word here represents a tab character, not text to type. If the source uses spaces rather than tabs, Text to Columns may not split it reliably when the number of spaces varies.

Fix common copy-and-paste problems

Everything appears in one cell. The source may be a paragraph rather than a true table, or its fields may not be separated by tabs. Use Data > Text to Columns when there is a consistent delimiter, or restructure the content in Word before copying.
Columns do not line up. Merged cells, uneven table rows, or nested tables can make the layout ambiguous. Simplify the Word table by removing unnecessary merges and nesting, then copy it again.
Leading zeros disappear. Excel may have interpreted the entry as a number. Set destination cells to Text before pasting when possible, or correct the data type using a suitable import workflow. Applying a display format afterward may show zeros but does not always restore characters that were already lost.
Dates or numbers change. Excel may automatically interpret text according to its regional settings. Check the cell’s displayed value and format. For data that must remain literal, use text formatting or import it with the appropriate data type.
The paste looks wrong or includes extra content. Copy only the intended cells in Word, then use an empty destination area and paste again. A copied page can contain text outside the table, while copying a table selection is more precise.
Cells are overwritten. Undo immediately with Ctrl+Z on Windows or Command+Z on a Mac if the paste was the last action and undo is available. If other edits have followed, undo may affect those actions too. Save a copy before replacing an important range.

When the result is still inconsistent, use a small test first: copy a few representative rows into an empty worksheet. This reveals how Excel handles the specific table, delimiters, and values before you paste a large dataset or overwrite existing work.

When to use another transfer method

Copy and paste is usually the quickest choice for a one-time transfer of a modest table. It is less suitable when the source is long, needs regular updates, contains complex formatting, or must be imported with precise data types. The best method depends on whether you value speed, repeatability, or control over the result.

Use ordinary copy and paste for a straightforward Word table that needs to become editable worksheet cells.
Use Paste Special when you want to remove formatting or choose another clipboard format that Excel makes available.
Use Text to Columns when text has a consistent delimiter but has arrived in a single column.
Use a text or CSV file when the content is large or you want to review import settings. A CSV file does not preserve Word formatting, and its delimiter and character encoding can matter.
Use manual cleanup when the Word layout is built from merged cells, nested tables, or visual spacing rather than consistent data fields.

There is no need to convert a Word document to an Excel workbook just to transfer a simple table. Conversely, pasting is not a reliable way to preserve a document’s page design as a spreadsheet. If presentation is the goal, keep the original in Word or export it as a PDF; if calculations and sorting are the goal, prioritize a clean rectangular data range in Excel.

Windows, Mac, and Excel for the web

The basic selection-and-paste process is similar across desktop versions: copy from Word, select a starting cell in Excel, and paste. The main keyboard difference is Ctrl+C and Ctrl+V on Windows versus Command+C and Command+V on Mac. Menu names and paste choices can vary slightly by operating system and app version.

In Excel for the web, paste content into a selected cell as you would in the desktop app, but some clipboard and paste-format options may be more limited or behave differently. If a table does not transfer cleanly, try the desktop Excel app or paste plain text and split it with Text to Columns if that command is available in your version. When switching between apps, confirm that the browser or operating system permits clipboard access.

Frequently Asked Questions

Can I copy a Word table directly into Excel?
Yes. Select the table in Word, copy it, and paste into the upper-left destination cell in Excel. Excel generally places the table’s rows and columns into worksheet cells, but check merged cells and data types afterward.

Why does my Word table paste into one Excel column?
The copied content may not contain tab-separated fields or may not be a true table. If the text has a consistent delimiter, select the pasted range and use Data > Text to Columns to separate it. Otherwise, adjust the source table or text structure in Word.

How do I paste from Word into Excel without formatting?
Use Home > Paste > Paste Special in Excel and choose a text-only option if one is available for the copied content. Paste choices depend on the clipboard data. You can also remove formatting afterward with Home > Clear > Clear Formats.

How do I keep leading zeros when pasting?
Set the destination cells to Text before pasting, then verify the result. If Excel has already converted a code such as 00127 to 127, changing the format afterward may not recover the missing zeros; copy again from the source or re-enter the correct text.

Can I copy a Word table into Excel on a Mac?
Yes. Select and copy the table with Command+C, then select a destination cell and paste with Command+V. Review the pasted structure and formatting, since available paste options can differ from those in Excel for Windows.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.