8 Surprising Ways You Can Import Data Into Microsoft Word

Microsoft Phrase is the industry-standard program for creating Microsoft Workplace paperwork, starting from analysis papers to skilled studies.

However typically, you’ve got information in one other program that you have to reference; it is perhaps in Microsoft Excel, a PDF, or one other Phrase doc. Figuring out the right way to import that information can prevent a whole lot of time.

This text will cowl varied strategies for importing information into Microsoft Phrase paperwork. Some strategies are helpful for studies—whereas others are helpful for type letters and comparable initiatives.


1. Import a Desk From Microsoft Excel

Since Microsoft Excel is essentially the most versatile useful resource to import information from, we’ll begin with that.

Formatting tables in Microsoft Phrase is horrible. That is why Microsoft Excel exists, proper? Fortuitously, Microsoft had the foresight to allow you to embody tables straight from Excel into your Phrase doc—so you are able to do all of the formatting in Excel—the place it is loads simpler. To import information from Excel to Phrase, comply with the below-given steps:

  1. Start by opening your Excel file and choosing the cells you wish to copy.
  2. Now, right-click on the chosen cells and choose Copy within the context menu.
    Context Menu In Excel

  3. Open the Microsoft Phrase doc into which you wish to import the content material.
  4. Now, go to Residence > Paste > Paste Particular.
    Paste Options In Word

  5. Additional, choose the Paste hyperlink choice and alter the kind to Microsoft Excel Worksheet Object.
    Paste Special Option In Word

  6. Lastly, hit the OK button.
  7. You may now see the cells you chose proper in your Microsoft Phrase doc. And since you chosen Paste Hyperlink as a substitute of Paste, these cells will mechanically replace everytime you make modifications in your Microsoft Excel spreadsheet.
    Imported Data In Word

MAKEUSEOF VIDEO OF THE DAY

So should you’re not going to wish updates—should you’re printing, or you are going to e-mail the file to another person, and it wants to point out the right information, for instance—you may wish to use Paste. That is fairly a helpful function if you wish to simply switch information from Excel to Phrase mechanically.

Associated: The Finest Microsoft Phrase & Excel Abilities You Ought to Know

2. Import a Single Cell From Microsoft Excel

Fortunately, it’s also possible to use the identical methodology as above for particular person cells.

Nonetheless, on this case, as a substitute of choosing Microsoft Excel Worksheet Object, you have to choose Unformatted Textual content; this is the reason the quantity is available in with the identical formatting as the remainder of the Microsoft Phrase doc.

It’s nonetheless up to date in the identical means, however you do not have to cope with attempting to get the textual content field in the correct place.


Paste Special Options

You should use the identical methodology to format a whole desk in your Phrase doc. If this is not working, otherwise you want extra sophisticated habits out of your single cell, you possibly can strive utilizing Visible Fundamental to combine Excel information into your Phrase doc.

3. Import a Graph or Chart From Microsoft Excel

Similar to importing a desk, it may be very handy to import a graph or chart from Microsoft Excel into Phrase in order that it mechanically updates everytime you make modifications to the Excel spreadsheet.

This could possibly be particularly helpful if you must create common studies that embody graphs. Fortuitously, Microsoft has made this course of extraordinarily simple: simply copy and paste the graph from Microsoft Excel into Phrase.

You can too click on and drag the graph from Microsoft Excel to Phrase to embed it within the file. Both means you go, the chart will now mechanically replace everytime you make modifications to the unique spreadsheet.

4. Mail Merge From Microsoft Excel

Mail merge permits you to rapidly and simply generate a number of similar letters, every with its personal structure, formatting, and textual content. While you ship a mail merge, Microsoft Phrase connects your Excel file to your doc.

Nonetheless, earlier than you begin the merge, make it possible for your Excel file has all the primary and final names, salutations, zip codes, and addresses that you simply wish to put in your doc.

Should you’re a beginner, it’s best to learn our article on the right way to mail merge in Phrase for a extra in-depth have a look at the subject. It could take some time to get the grasp of utilizing mail merge, however when you get it, it will likely be probably the most helpful instruments in your Workplace arsenal.

5. Importing PDF Recordsdata

For text-based PDFs, this methodology is not very helpful. But when there are any pictures within the file, it is a lot simpler than having to repeat and paste or discovering a strategy to flip the PDF into a picture file, so you possibly can insert them into your Microsoft Phrase doc.

Comply with these easy steps so as to add a PDF to Phrase:

  1. Open the Phrase doc the place you wish to add the PDF file and click on on the Insert > Object button.
  2. Now, within the object window, choose Create from File.
  3. Click on the Browse button and navigate to the PDF you wish to embody.
    Object Window In Word

  4. After finding it, choose the file and click on Insert.
  5. Lastly, click on OK.

While you import a PDF into Microsoft Phrase, it is available in as a picture file, not a textual content file like it could be by itself.

To discover ways to insert a PDF into Phrase whereas retaining the capability to edit it, click on Insert > the arrow subsequent to Object > Textual content from File. This instructs Phrase to make an editable PDF model of the doc and put it into it.

6. Robotically Importing Textual content From Different Phrase Paperwork

If you have to sort the identical factor frequently, you may be capable of save time by placing it in a Microsoft Phrase doc and easily referencing it from one other doc.

To illustrate you’ve got a bunch of type letters that you have to ship that every one want to incorporate your title and the corporate you’re employed for, however your employer modifications frequently.

You do not wish to change each letter everytime you get a brand new contract, so you possibly can simply retailer your signoff in a single doc and have all of the others up to date everytime you make a change.

Going by an instance will assist make this clear. Here is an “updateable textual content” doc that we have saved:


Updateable Text In Word

Suppose you wish to embody each of these items—a signoff and call data—in every of the letters. To do that, you have to create a bookmark for each.

Comply with these steps sequentially to create a bookmark and auto-import textual content with ease.

  1. Create a Phrase doc and enter the textual content you want more often than not.
  2. To create a bookmark, spotlight the textual content you wish to hyperlink to different paperwork, then click on Insert > Bookmark on the ribbon.
    Bookmarking In Word

  3. Now, sort within the title of your bookmark and click on Add.
    Bookmark Window In Word

  4. Now, save the file and make an observation of the total path to the place it is saved. For instance, we have saved our file on the Desktop, and so the trail is C:UsersHIMANDesktopSignoff.docx.
  5. To insert your saved textual content, go to a different Microsoft Phrase doc and hit Insert > Subject. Choose IncludeText from the Subject Names menu.
  6. Now, within the Filename or URL textual content field, sort the trail the place you’ve got saved your earlier file.
    Field Insert In Word

  7. Lastly, hit OK, and you may see the textual content inserted into your doc.


This may seem to be a whole lot of work, but when you must sort the identical issues frequently, it might prevent an enormous period of time in the long term.

It takes some setup time on the entrance finish, however you will see the comfort of this method instantly.

7. Import Textual content From a Textual content File or Microsoft Phrase Doc

If you wish to get textual content from a textual content file or Phrase doc with out having to open it—we have got your again. It is very simple to try this with just one or two clicks. Comply with these steps to import solely textual content from a textual content file or Phrase doc:

  1. Open the Phrase file the place you wish to import all of the textual content.
  2. Now, click on Insert > Object > Textual content from File.
  3. Select the file from which you wish to extract textual content and open it in Phrase. Should you’re unable to view some other file sort, merely change the file sort to All Recordsdata.
  4. Lastly, click on Insert.

As a bonus, if you wish to add the header and footer as nicely, be sure to place the content material from the file in a separate part. This can make it possible for the header and footer are solely utilized to the pages that want them.

8. Import Textual content From a Net Web page

If you wish to maintain an up to date copy of an online web page in a Microsoft Phrase doc, you are able to do that too. For this tutorial, we’ll be utilizing a web based HTML to DOC converter to make this loads less complicated for newbies.

Comply with these easy steps to import textual content from an online web page:

  1. Go to the net web page that you simply wish to import and reserve it as an HTML file. Should you’re not a geek, you possibly can verify our information to discover ways to save any net web page as an HTML file utilizing your net browser.
    Web Page In HTML

  2. Go to convertio.co and add the file you simply saved.
  3. Then, click on the Convert button.
    Convertio Convert Option

  4. Obtain the transformed file and open it.

You might need to experiment a bit, however it might doubtlessly be a really useful gizmo. Hopefully, this methodology has given you what you needed. In the intervening time, there aren’t many good instruments for this as a result of folks do not do that fairly often.

Import Knowledge Simply Into Microsoft Phrase

We have coated a wide range of various kinds of information which you can import into Microsoft Phrase right here—however there are seemingly extra choices accessible. These new expertise generally is a little troublesome to be taught at first, however they’re going to absolutely repay in the long term.

In addition to that, there are a whole lot of important writing ideas you possibly can comply with most of Microsoft Phrase.


Microsoft Office Word Laptop
8 Important Writing Suggestions for Microsoft Phrase

Discover ways to use Microsoft Phrase successfully in an effort to grow to be knowledgeable author. Listed below are a couple of ideas for you!

Learn Subsequent


About The Creator

Leave a Comment