How to copy a table from MS Word to Excel? Copy a table from word to excel

 

Table of Contents

1. How to copy a table from word to excel in English
2. · Remove Extra Paragraph Break
3. · Copy a table from word to excel without formatting
4. · Link MS Word table to Excel
5. 
   

How to copy a table from word to excel in English

Are you also wondering how to copy a table from MS Word to Excel correctly? (Copy a table from word to excel)
As you can see in the image below, we often create a table in MS Word and insert some data in it and we have to convert the same table into Excel.

                                    copy a table from word to excel in English

But when we convert any data from Word to Excel i.e. copy the table from MS Word and paste it in Excel, then the table gets pasted in Excel but it is not pasted correctly.

Some data is not pasted in one cell but gets pasted in different cells or some cells get merged in Excel. Due to which we have to work on that data again in Excel.

We have to unmerge the cells. Formatting also has to be set or removed separately and the text that we need in the same cell has to be entered again manually.

But now there is no need to worry because in this article you have been told the solution to this problem.
Now you will not need to work in Excel again after pasting the table from MS Word to Excel. For this you will have to follow some steps which are explained in detail below.
Remove Extra Paragraph Break
The biggest problem is that after pasting the table from MS Word to Excel, the cells get merged and all the data does not come in one cell, it goes to different cells and some cells are also merged.

Let us first understand the reason for this happening. Whenever we copy and paste any data from MS Word to Excel, the cells of our Excel get merged because of the extra paragraph breaks in our table.
Before copying and pasting any data from Word to Excel, we have to remove all the extra paragraph breaks located in the table of Word. So that after pasting the table from Word to Excel, no cell gets merged or data goes into a different cell.
Follow the steps below to remove extra paragraph breaks from your Word tables.

• Select your table in MS Word
• After that, open the Find & Replace
• window with the help of CTRL + H shortcut keys.
• Now type ^p in the From field.
• And give a space in the Replace field (press the spacebar key once from the keyboard).
• Now finally you have to click on Replace all.
• After which all the extra paragraph breaks from your table will be replaced with spaces.
• Now you have your table copied.
• Paste it in your Excel and your work is done.Read more: 

 Read More:How to Delete a Page in Word in English– Remove Blank or Extra Page

Copy a table from word to excel without formatting

• Suppose your Word tables have a lot of formatting and you want to paste only the data without any formatting.
• So you have to copy the table from Word.
• And then while pasting in Excel, you have to go to Paste Special and select Match Destination Formatting.
•                                                                     
  
                                 Match Destination Formatting                      
Read this article to learn all the options of Paste Special in Excel: 14 Paste Special in Excel Tips in English
Link MS Word table to Excel 
First of all, clean your table and remove extra paragraph breaks from it

       1) Like we mentioned above
       2 )Copy your table from his Word.
       3)Then select the cell in Excel where you want the data and press the shortcut keys CTRL +             ALT + V to paste it special.
       4)Now in the window of Paste Special, select Paste Link and then Hyperlink option and click           on Ok.

                                                   link a table from ms word to excel
The work is done, now whenever you update any data in the MS Word table, it will automatically be updated in Excel also.

Conclusion: What you learned
I hope that you have got some important information from this article and you have learned something new today.
To read similar articles related to MS Word and MS Excel, click on the given link.

.