How to Insert an Excel Table Into Microsoft Word

Updated on September 20, 2017

Inserting an Excel table into Microsoft Word may be easy. But does the result look the way you want it to? The tables in the two programs can look quite different. This tutorial will show you how to import Excel data into Word so that the table look similar. The basic principle is to insert the data cells from the Excel spreadsheet into a Word table.

Step 1: Open a Microsoft Excel file

To start this tutorial, you will need an Excel table to practice with.

  • You may create a new Excel file, enter some data in it, and save it to your computer, or
  • You may already have an Excel file with a table you want to copy.

The example below is a large Excel table called "Introduction.xls." We just open that file by double clicking, and it looks as shown below. In your case, the data and table will be different, because this is just an example.

An open Excel table called "Inroduction.xls"
An open Excel table called "Inroduction.xls"

Step 2: Select All or Part of the Excel table

The next step is to select the data from the Excel file that you want to appear in the Word document. So, we need to copy all or part of that table. Select all or part of the information in the table by highlighting it.

In the example below, we selected part of the "Introduction.xls" table to insert into the Microsoft Word file.

It is a good practice to count the total number of rows and columns you have selected. This is not mandatory, but this will help you to create a nice-looking Word table of exacly the right size, with borders. If you don't count the number of rows and columns, the main difference is that the Microsoft Word table that receives the data will will be borderless.

Step 3: Copy the Data From the Excel Table

We need to copy the table. To do this, right-click on the highlighted part of the table which we selected in Step 2. Right-clicking brings you a menu of options. Choose the Copy option to copy the data table.

Part of the data in Introduction.xls has been selected.
Part of the data in Introduction.xls has been selected.

Step 4: Prepare the Word File to Receive the Table Data

So you have some data on the Clipboard, but you will not paste that just data yet. First you need to create a Word table with the correct dimensions. So, do the following steps:

  1. Open a new or existing document in Microsoft Word. For example, here we created a Word file named MyWordDocument.docx.
  2. Click the Insert tab from the Word ribbon.
  3. Locate the Tables group, select the Tables icon, and from there choose Insert Table.

With the Insert Table option open, we need to configure the table, which will we do in the next step.

Step 5: Configure the Microsoft Word Table

We have to create a table large enough--ideally, the same dimensions as the data--to receive the Microsoft Excel table data we want to paste into it. To create a table in Word, we have to define the number of rows and columns. To do that, we use the information we got in Step 2.

  1. In the Number of columns field, under the Table Size option in the Insert Table dialog box, we choose the number of columns in the table you are going to paste. fIn our example, the selected data has 3 columns, so we select 3 in the field Number of columns.
  2. In the Number of rows field just below, choose the number of rows in the table you are going to paste. In our example, the selected data has 10 rows, so we select 3 in the field Number of rows.
  3. Under AutoFit Behavior in this Insert Table dialog box, select Fixed column width, and choose the associated behavior as Auto.
  4. Click the OK button to create a table and insert it into the Microsoft Word file.

creating a table with 3 columns and 10 rows
creating a table with 3 columns and 10 rows

Step 6: Highlight the Word Table

After completing Step 5, we will see a table in our Word document. Highlight the rows and columns which best match the dimensions of the Excel table we are pasting. For example, after selecting the rows and columns, our table might look like the following:

Highlight the Word table
Highlight the Word table

Step 7: Select "Paste Special" Option

We will get ready to import the Excel table data that we copied into the Clipboard in Step 3. Just do the following:

  1. Click the Home tab from Microsoft Word ribbon, and you will see the Paste option at the left side of your Microsoft Word software.
  2. Click on the arrow pointer under Paste button, and the button will expand and show more options in a drop-down menu.
  3. Form the options in the expanded menu, select Paste Special and click on it.

Step 8: Select Format for Paste Special option

This is the most important step of this tutorial. Microsoft Word offers a lot of formats in which to paste data, including Microsoft Excel Worksheet (code) Object, Formatted Text (RTF), Unformatted Text, Bitmap, Picture (Enhanced Metafile), HTML Format, Unfomatted Unicode Text. Each option has its own features. What we need here is an option that inserts the contents of the clipboard as text without formatting. So select Unfomatted Unicode Text and click the OK button.

Select "Unformatted Unicode Text"
Select "Unformatted Unicode Text"

After pressing OK, you will see the copied data are pasted into the Word table looking exactly the same as in the original Excel table.

The finished table in Word
The finished table in Word

The resulting Word table looks just like an Excel table. Tables like this look professional in magazine articles, theses, scientific reports, and other publications. Try this method whenever you need to move data from Excel into Word.

Comments

    0 of 8192 characters used
    Post Comment

    • profile image

      Laurence Smith 

      9 months ago

      TurboFuture - you're the best!

      I spent hours on the phone with Apple & Microsoft support. They could barely understand my problem, and not able to fix - paste issue from xl to word ( all the xl cells pasted into each cell of the word table).

      Just read your fix and the last step - paste special - Unformatted Unicode Text option - the answer to pasting the xl cells correctly in word table cells. cheers, Laurence

    • profile image

      Ucrecia 

      5 years ago

      Thank you, thank you, thank you. You saved my life

    • jabelufiroz profile image

      Firoz 

      5 years ago from India

      Great hub on How to Insert an Excel Table into Microsoft Word. Voted up.

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, turbofuture.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://turbofuture.com/privacy-policy#gdpr

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)