How to Copy Word Table to Excel & Google Sheets

This tutorial demonstrates how to copy word table to Excel and Google Sheets.

 

 

Copy Table From Word to Excel

It is simple to copy a table of data from a Word document to Excel and means that you do not have to retype the data!

1. In the Word document, select the whole table by clicking in the top-right corner of the table on the small black cross.

 

 

2. Then, in the Word Ribbon, go to Home > Clipboard > Copy or press CTRL + C on the keyboard.

 

 

3. Switch to Excel and click where you wish your table to be copied to.
4. Then, in the Excel Ribbon, go to Home > Clipboard > Paste or press CTRL + V on the keyboard. This automatically pastes the table with any formatting included and without splitting the cells.

 

 

5. To copy just the data in the table, choose to Match Destination Formatting.

 

 

Copy Table From Word to Google Sheets

1. Once again, in the Word document, select your whole table.

2. In the Word Ribbon, go to Home > Clipboard > Copy or press CTRL + C on the keyboard.
3. Switch to your Google sheet, and then, in the Menu, go to Edit > Paste.

 

 

4. If you only want to paste the values, you can choose to Paste values only in the bottom-right corner of the table. You can also paste just the format.

 

 

5. If you have pasted a column that contains a date, it pastes it as a value. You need to format that column in Google Sheets for date.
6. In the Menu, go to Format > Number > Date.