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.

  1. Click Copy Button image on the Standard toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.).
  2. Switch to your Microsoft Excel worksheet.
  3. 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.

  1. Click Paste Button image.
  2. To adjust the formatting, click Paste Options Button image 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.

Applies to:
Excel 2003, Word 2003