Show All

Copy a Word table into Excel

1. In Microsoft Word, select the rows and columns of the table you want to copy.

   If you want to select the entire table, click the table, point to Select on the Table menu, and then click Table.

2. Click Copy on the Standard toolbar.
3. Switch to your Microsoft Excel worksheet.
4. Click in the upper-left corner of the worksheet area where you want to paste the table.

   Cells from the copied table replace any existing cells in the area.

5. Click Paste .
6. To adjust the formatting, click Paste Options next to the data, and then click Match Destination Formatting to use any formatting that was previously applied to the Excel cells, or Keep Source Formatting to match the formatting of the Word table as closely as possible.

Note  Excel pastes the contents of each cell in the Word table to a separate Excel cell. If you want to split the data in the cells further, for example to divide first and last names so they're in separate cells, use the Text to Columns command on the Data menu.