Copy Paste Excel Table as Plain Text in Microsoft Word
If all you want is to copy and paste a table from Excel to Word, you can do that with a simple copy-paste.
It allows you to get the static table in MS Word, where you can then format it (and change it if you want).
The downside of this method is that if there are any formulas in the data, that won’t work. And since this is a static table, any changes you make in Excel will not get reflected in the table you copied to Word.
But in most cases, this is precisely what you want.
Let’s see how to do this.
Suppose you have a dataset, as shown below, and you want to copy this data from Excel and insert it into Word.
Below are the steps to do this:
- Select the data in MS Excel that you want to copy to Word
- Right-click and then click on Copy (or use the keyboards shortcut Command + C in Windows or Command + C in Mac)
- Open the MS Word document where you want to insert this data
- Position the cursor where you want this data in the Word document
- Go to the Home tab in MS Word and click on Paste (or use the keyboard shortcut Control + V)
The above actions would copy the data from Excel and paste it as a static table in the Word document.
Once you have the table in MS Word, you can format and work with it just like any other table that you insert in Word.
A couple of things to note when using this method:
- If there are any formulas in the table in Excel, I won’t be copied. I have the formulas in the Total row in my example, but when copied to Word, these are static values. If you make any changes to any data, you will have to adjust the formula values as well manually.
- If you don’t want to copy the formatting from Excel and would rather want to use the formatting of the Word document, you can use the option Use Destination Style option. It shows up when you click on the Paste Options icon after past the table in Word.
Embed Excel Table into Word (as a Linked Object)
We copied the data from MS Excel and inserted it as a static table into Word in the above method.
Another option that you can use is to copy and paste the table into a Word document and keep the two tables connected.
If you make any changes in the Excel table that you copied, you will see that these are mirrored in real-time in the table in Word.
It is quite useful when there is a possibility that you may have to update the data in Excel, and it would also need to be updated in Word. By including the linked table, you only need to make changes in Excel data, and these would automatically get reflected in the table you copied to Word.
Let me show you how this works.
Imagine you have a table shown below, and you want to copy it from Excel to MS Word and keep this linked.
Below are the steps to do this:
- Select the data in Excel that you want to copy to Word
- Right-click and then click on Copy (or use the keyboard shortcut Control + C)
- Open the Word document where you want to insert this data.
- Place the cursor where you want this data in the Word document.
- Go to the Home tab in MS Word and click on the Paste drop-down (click on the small inverted arrow below the Paste Special icon)
- In the Paste Special dialog box, select the ‘Paste link’ option.
- Select Microsoft Excel Worksheet Object from the listed options
The overhead steps would insert the copied table in Word, where it’s still linked to the original table in Excel.
Now, if you go and create any changes in the table in Excel, you will see that the same is reflected in the table in Word (in real-time).
Here are some something you need to know about this method:
- Since the two files are linked to each other, you will have to keep these together. If you’re sending the Word file to someone, you will also have to send them the Excel file, or the link will be broken, and the data in Word will not update.
- Whenever the Word file opens, it will check for any updates in the Excel table. It works even if the Excel file is closed.
Copy Excel Table as a Satic Image
If you’re preparing a report and all you want is a really easy way to show some table (without changing the data), you can insert that data as an image.
Doing this is easy, and images are also easier to manage in Word (such as placement and resizing).
With copying and images, you also have an option to link the image to the table in Excel. If you make any changes in the Excel table, it will be reflected in the table image in Word.
Inserting Copied Table as a Static Image in Word
Suppose you have a table as shown below in Excel:
Below are the actions to copy this table and insert it as an image in MS Word:
- Select the data in Excel that you want to copy to Word
- Right-click and then click on Copy (or use the keyboard shortcut Control + C)
- Open the Word document where you want to insert this data.
- Place the cursor where you want this data in the Word document.
- Go to the Home tab in Word and click on the Paste drop-down (click on the small inverted arrow below the Paste Special icon)
- In the options that show up, click on Paste Special.
- In the Paste Special dialog box, make sure the ‘Paste’ option is selected
- Select ‘Picture’ from the listed options
The above actions would insert an image of the table in the Word document.
Like any other image, you can resize and format it.
Inserting Copied Table as a Linked Image in Word
If you like the flexibility of handling images in Word and still want the table to be connected to the original Excel file, you can do that.
Suppose you have a table as shown below in Excel:
Below are the actions to copy this table and insert it as a linked image in MS Word:
- Select the table in Excel
- Right-click and then click on Copy (or use the keyboard shortcut Control + C).
- Open the Word document where you want to insert this data.
- Place the cursor where you want this data in the Word document.
- Go to the Home tab in Word and click on Paste Special.
- In the Paste Special dialog box, select the ‘Paste Link’ option
- Select ‘Picture’ from the listed options
- Click OK
Again, the above steps would give you an image that you can easily resize and format.
Since this is linked to the original table in Excel, if you make any changes in the original table, these would also be reflected in the image.
Also, remember that since this image is linked to the original data, if you plan to share this Word document with someone else, you should also share the Excel File (in case you want the link to remain as is)
If the excel file is not available or the name is changed, the image would be just like any other regular image.
So these are some of the ways you can use to copy a table for Excel and insert it into Word. I prefer copying and pasting Excel tables as images in most cases, as these are easier to manage. In some cases, I also prefer the embed method, which allows me to open the Excel file from within Word itself.
I hope you found this tutorial useful!
I’ve been browsing online more than three hours today, yet I never found any interesting article like yours.
It’s pretty worth enough for me. Personally, if all web owners and bloggers made
good content as you did, the net will be much more useful than ever before.
It’s hard to come by well-informed people on this subject,
however, you seem like you know what you’re talking about!
Thanks
I am perpetually thought about this, thanks for putting up. Clayton Frautschi
I am sure this piece of writing has touched all the internet users, its really really pleasant paragraph on building up new blog. Clifton Rhees
Simply wanna comment that you have a very decent web site , I the design and style it really stands out. Rudolph Furr
The items are made properly and final a extended time. Eli Macafee
Appreciating the commitment you put into your blog and detailed information you present. Jerrod Beachman
The sketch is tasteful, your authored material stylish. Erin Filippi
Very interesting details you have observed, regards for posting. Noel Sharabi
Usually posts some quite exciting stuff like this. If you are new to this site. Shirley Schleuder
What a material of un-ambiguity and preserveness of valuable knowledge on the topic of unexpected emotions. Arlie Toomsen
My family every time say that I am wasting my time here at net, except I know I am getting experience all the time by reading thes good posts. Thomas Freemyer
I am truly happy to glance at this weblog posts which consists of lots of useful facts, thanks forr providing these information. Ricky Vegter
Pretty! This has been a really wonderful article. Thank you for providing this info. Blair Deroy
This is a practice that is not only helpful to search engine indexers; your readers will appreciate it, too. Keenan Stiehl
MOE BERG- FOR HIS LIFE RISKING EFFORTS FOR THE FREEDOM OF THE UNITED STATES. Dominick Urquidi
Some truly good articles on this internet site , appreciate it for contribution. Jim Heyde
Using a green clay mask will help to naturally shrink your pores. Ernest Semasko
Way cool! Some extremely valid points! I appreciate you writing this write-up along with the rest of the site is really good. Irving Applebaum
If some one needs expert view about blogging then i propose him/her to pay a quick visit this web site, Keep up the nice work. Luis Fontelroy
I think that is among the such a lot significant information for me. Maximo Aldrige
Hello my family member! I wish to say that this article is amazing, great written and come with approximately all important infos. Jamar Kronberg
Yay google is my world beater aided me to find this outstanding site!. Ryan Wunderly
This post is truly a nice one it assists new internet visitors, who are wishing for blogging. Malcolm Ratz
Good post! We will be linking to this great article on our site. Keep up the good writing. Kyle Shastri
A big thank you for your post. Really looking forward to read more. Really Great. Emery Speirs
I beloved up to you will obtain performed proper here. Harley Goodhile
I really like your writing style, wonderful information, thanks for putting up : D. Billie Christiano
There is obviouslyclearlyevidentlyvisiblyapparentlynoticeablyperceptibly a lotbundlebunch to knowidentifyrealize about this. Grover Prim
Oh my goodness! Amazing article dude! Thanks, However I am having troubles with your RSS. Donte Castellana
I have recently started a web site, the info you provide on this website has helped me greatly. Thanks for all of your time & work. Mauro Kalafatis
You completed various good points there. I did a search on the matter and found a good number of folks will have the same opinion with your blog. Jc Levatino
I go to see everyday some sites and sites to read content, except this weblog presents quality based articles. Daryl Ayers
Thanks a lot for the blog post. Really looking forward to read more. Great. Galen Warchal
Some truly superb content on this site, thankyou for contribution. Robby Barthol
Yes! Finally something about free steam wallet codes. Jefferson Weldin
I think this is a real great post. Much thanks again. Fantastic. Norris Thiemann
Merely wanna input that you have a very nice web site, I love the style it really stands out. Jerrod Freudenburg
Very good article. I am going through many of these issues as well.. Thaddeus Raines