- Applies to: Excel for Microsoft 365, Word for Microsoft 365, Excel 2019, Word 2019, Excel 2016, Word 2016, Excel 2013, Word 2013, Excel 2010, Word 2010, Excel 2007, Word 2007.
In this post, you will learn how to import a Word table into Excel. It will walk you through the process of how to do this successfully and also covers some crucial points for you to remember which ensure that you retain all the functionality of the Excel data.
Once you have decided to relocate data from a Word table to Excel, you can overcome the drudgery of manually retyping that data. To achieve this, you simply duplicate it from Word directly. After you copy data from a Word table into an Excel worksheet, every Word table cell’s data will transfer into the worksheet. They will be appear in a separate worksheet cell.
When you’ve pasted the data, you might have to tidy it up. This is to ensure that you can make the best use of Excel’s calculation features. For instance, there could be unnecessary additional spacing in cells. Another scenario is that numbers might have been imported as text instead of numeric values that you can calculate. Alternatively, dates are incorrectly displayed. To get assistance with formatting numbers as dates, currency, percentages, etc., read Format numbers. For guidance with formatting your table’s style, see Format an Excel table.
How to import a Word table into Excel
- Firstly, open a Word document. Next, choose the specific rows and columns of the table that you prefer to copy into an Excel worksheet. Check that there aren’t any extra carriage returns within the table’s cells, otherwise this could result in excessive rows in Excel.
- Press CTRL+C to copy the range.
- In the Excel worksheet, click the upper-left corner of your target worksheet area for pasting the Word table.
Note: Ensure that the paste area is vacant prior to you pasting the data. Data inside Word table cells will overwrite any current data in worksheet cells within the paste area. If essential, inspect the table first in Word to ascertain its dimensions.
- Press CTRL+V.
- To edit the formatting, choose Paste Options beside your pasted data, and then do the following:
- To apply the formatting that is formatted to the worksheet cells, select Match Destination Formatting.
- For deploying the formatting of the Word table, pick Keep Source Formatting.
Note: Excel pastes the contents of each Word table cell into one cell. After you paste the data, you can divide the data throughout extra cells in a column (for example, to divide first and last names so that they appear in individual cells) by using the Text to Columns command. For further information, see Distribute the contents of a cell into adjacent columns.