To convert a Word table to Excel, select the table in Word, press Ctrl+C, click an empty cell in Excel, and press Ctrl+V. Each Word table cell lands in its own Excel cell, and on a Mac you use Command+C and Command+V instead.
These steps cover desktop Word and Excel for Microsoft 365, 2024, 2021 and 2019 on Windows and Mac, and they follow Microsoft’s Copy a Word table into Excel instructions. Copy and paste also works between the web versions of Word and Excel, but the import method later in this guide needs desktop Excel.
Which Method Should You Use?
| What you have in Word | Best method |
|---|---|
| A normal table | Copy and paste (the main steps below) |
| A table with several lines of text in some cells | Remove the extra line breaks first, then copy and paste |
| Text separated by tabs or commas | Paste it, then use Text to Columns, or convert it to a table in Word first |
| A very long table, or IDs and ZIP codes with leading zeros | Save as plain text and import it with From Text/CSV |
Word can’t save a file as an Excel workbook, so every method moves the data through the clipboard or a plain text file. For a short table that only needs row totals, Word can multiply the numbers with a table formula without leaving the document.
Before You Copy: Check the Table in Word
A few minutes of cleanup in Word saves more time in Excel. On the Home tab, click Show/Hide ¶ to display paragraph marks, then look for these problems:
- Extra paragraphs inside a cell. Microsoft warns that carriage returns in cells can create extra rows in Excel. A cell with two paragraphs becomes two rows.
- Merged cells. A merged cell in Word becomes a merged cell in Excel, which blocks sorting and filtering. If you don’t need it, select it in Word and use Split Cells on the Table Layout tab (Layout in older versions).
- Blank spacer rows and pictures. Delete empty rows you added only for looks. Pictures may paste as floating images instead of cell values.
How to Copy a Word Table Into Excel
- In Word, click anywhere in the table. Click the small four-arrow handle at its top-left corner to select the whole table, or drag across only the rows and columns you need.
- Press Ctrl+C (Command+C on a Mac), or right-click the selection and choose Copy.
- In Excel, click the cell where the top-left corner of the table should go. Check that enough empty cells sit to the right of it and below it, because pasted data replaces anything already in those cells.
- Press Ctrl+V (Command+V on a Mac). The table appears with each Word cell in its own Excel cell.

- Click the Paste Options button that appears next to the pasted data and choose Match Destination Formatting to use the worksheet’s own fonts and colors, or Keep Source Formatting to keep the Word table’s look.
- Double-click the border between column letters to widen any column that looks cut off.
To confirm the paste worked, click a few cells and check the formula bar. Each cell should hold one value, and numbers should line up on the right side of their cells. Numbers that hug the left edge were probably pasted as text, which the cleanup section fixes. If the Word table keeps shifting while you tidy it before copying, stop the Word table from resizing first.
If you want sorting, filtering and banded rows, select the data and choose Insert > Table, then confirm that the first row holds your headers.
If the table is a mailing list, you can later merge the Excel data back into Word letters with one letter per row.
Fix Cells That Split Into Several Rows
When a Word cell holds more than one paragraph, Excel puts each paragraph in a new row and the table falls out of line. Join those paragraphs in Word before copying:
- Select the table in Word.
- Press Ctrl+H to open Find and Replace.
- In Find what, type ^p (a paragraph mark). Type ^l instead for line breaks made with Shift+Enter.
- In Replace with, type a space or a separator such as a semicolon.
- Click Replace All. If Word asks whether to search the rest of the document, click No so text outside the table stays untouched.
Copy the table again and paste it into an empty part of the sheet. Work on a copy of the document if you need to keep the original layout.
Copy Ordinary Word Text Into Excel
For text outside a table, select it in Word, copy it, click an empty cell in Excel, and paste. Each paragraph lands in its own row, and text separated by tabs spreads across columns automatically.
If everything lands in one column because the text uses commas or another separator, split it with Text to Columns:
- Select the column that holds the pasted text. Make sure the columns to its right are empty, because the split fills them.
- Click Data > Text to Columns.
- Choose Delimited and click Next.
- Check the separator your text uses, such as Comma or Tab, and watch the preview divide into columns. Click Next.
- Set any column that holds IDs or ZIP codes to Text so Excel keeps leading zeros, then click Finish.
Another route is to turn the text into a real table in Word first. Select the lines, click Insert > Table > Convert Text to Table, choose the separator under Separate text at, and click OK. Microsoft’s guide to converting text to a table recommends tabs when your text already contains commas, such as “Smith, John.” Then copy the new table into Excel with the main steps.
If Paste brings over fonts and colors you don’t want, use Home > Paste > Paste Special and choose Text (or Unicode Text if the table contains accented letters or symbols). If the pasted table is going into a page layout, see how to import an Excel spreadsheet into InDesign.
Clean Up the Data So Formulas Work
Pasted data often needs tidying before Excel can calculate with it. These are the usual fixes:
- Numbers stored as text: select the cells, click the warning icon that appears beside them, and choose Convert to Number. Microsoft’s guide to numbers stored as text covers other ways to fix them.
- Extra spaces: in a spare column, enter =TRIM(A2) (using your first data cell), fill it down, then copy the results and paste them back with Paste Special > Values.
- Dates displayed wrong: check that Excel reads them as dates, then apply a date format. Dates written in a day/month order can be misread on a US-format computer.
- Two values in one cell: use Data > Text to Columns, for example to separate first and last names.
- Line breaks left inside cells: press Ctrl+H in Excel, click in Find what and press Ctrl+J, type a space in Replace with, and click Replace All.

Once the numbers are real numbers, you can sum the column in Excel and trust the total.
When the numbers and dates are clean, you can summarize the table with a pivot table instead of writing formulas.
Import a Large Table as a Text File
For a long table, or one where leading zeros and data types must stay exact, save the Word table as plain text and import it. Excel then lets you check the columns before anything lands on the sheet.
- Copy the table into a new blank Word document, so the text file holds only the table.
- Select the table there and click Convert to Text on the Table Layout tab. Choose Tabs under Separate text with and click OK.
- Click File > Save As, set the file type to Plain Text (*.txt), and save. Keep the default encoding, or choose Unicode (UTF-8) if the table has special characters.
- In Excel on Windows, click Data > From Text/CSV, select the file, and click Import.
- In the preview, set Delimiter to Tab and check that the columns line up.
- Click Load to place the data on a new sheet, or Transform Data to set column types first, such as Text for ZIP codes.
Microsoft’s text and CSV import guide explains the other load options. In Excel for Mac, use File > Import, choose Text file, and follow the import wizard. Your original Word document is never changed, because you worked on a copy.
When Data Overwrites Existing Cells
- Data overwrote existing cells: press Ctrl+Z right away and paste into an empty area.
- Everything pasted into one cell or one column: the text uses separators Excel didn’t split on. Use Text to Columns, or convert the text to a table in Word first.
- Extra blank rows or shifted cells: the Word cells contain extra paragraphs or merged cells. Fix them in Word and copy again.
- Formulas show 0 or errors: some numbers are text. Convert them to numbers, then recheck the formula.
- Leading zeros disappeared: Excel treated the values as numbers. Use the text import method and set that column to Text before loading.
Word to Excel Questions
Can I open a Word document directly in Excel?
No. Excel can’t open a .docx file as a worksheet. Copy the table across, or save the Word file as plain text and import it.
Do I need a converter tool?
Usually not. Copy and paste handles most tables, and online converters upload your document to someone else’s server, which is a poor fit for personal or company data. If your table is in a PDF rather than Word, you can convert the PDF to Excel with Acrobat.
How do I copy several Word tables at once?
Copy them one at a time. Paste each table onto its own sheet, or leave a blank row between tables so you can sort and filter each one separately.
Can I go the other way?
Yes. Copy cells in Excel and paste them into Word to create a Word table.
Next, if some cells still hold two values, split a cell in Excel with Text to Columns, Flash Fill or a formula.

Matthew Burleigh is the founder, head writer, and editor of Solve Your Tech, which he launched in 2012. He has written technology tutorials since 2008 and worked in IT since 2003, including small-business support, IT management, and consulting. He holds Bachelor’s and Master’s degrees in Computer Science from Arizona State University.
Matthew writes practical guides for Windows, iPhone and iPad, Microsoft Office, Outlook, Google apps, and Android. Solve Your Tech’s guides are checked step by step against the device or app maker’s own documentation and tested on his own devices whenever he has the hardware or software, with clear steps, sources, and update dates.
Read more about Matthew and how Solve Your Tech writes and updates its guides, or report a correction.