By copying the data straight from Word, you can transfer data from a Word table to Excel without having to retype it. Each Word table cell’s contents are copied into a separate Excel worksheet cell when data is copied from a Word table into an Excel worksheet.
Important: In order to utilize Excel’s calculation features, you might need to clean up the data after pasting it. For instance, dates may not display correctly, numbers may have been pasted as text instead of as calculable numeric values, or cells may have unneeded extra spacing.
Convert a Microsoft Word table to a Microsoft Excel file
- Choose which table rows and columns in a Word document you wish to transfer to an Excel worksheet. Verify that the table’s cells do not contain any extra carriage returns, as this could result in extra rows in Excel.
- Use CTRL+C to copy the selection.
- Choose the area in the upper-left corner of the Excel worksheet where you wish to insert the Word table. Note: Before pasting the data, make sure the paste area is empty. Any existing data in worksheet cells in the paste area will be replaced by data in Word table cells. Verify the table’s dimensions in Word first, if required.
- Use CRL+V.
- Click Paste Options next to the data you pasted, and then take the following actions to change the formatting:
- Click Match Destination Formatting to utilize the formatting that has been applied to the worksheet cells.
- Click “Keep Source Formatting” to utilize the Word table’s formatting.
The contents of every Word table cell are pasted into a single cell in Excel. Once the data has been pasted, you can use the Text to Columns command to distribute it among other cells in a column (for instance, dividing first and last names so that they appear in different cells).