How To Use Excel To Input Data On Word

Microsoft Word is the industry-standard plan for creating Microsoft Part documents, ranging from research papers to professional reports.

Simply sometimes, you take data in another programme that you lot need to reference; it might be in Microsoft Excel, a PDF, or another Discussion certificate. Knowing how to import that data can salve you lot a lot of time.

This article volition cover various methods for importing data into Microsoft Discussion documents. Some methods are useful for reports—while others are useful for form messages and similar projects.

ane. Import a Table From Microsoft Excel

Since Microsoft Excel is the well-nigh versatile resource to import data from, nosotros'll start with that.

Formatting tables in Microsoft Give-and-take is terrible. That'due south why Microsoft Excel exists, right? Fortunately, Microsoft had the foresight to let you lot include tables straight from Excel into your Word certificate—so you can do all the formatting in Excel—where information technology'southward a lot easier. To import data from Excel to Give-and-take, follow the below-given steps:

Brainstorm past opening your Excel file and selecting the cells you want to re-create.
Now, right-click on the selected cells and select Copy in the context menu.
Open up the Microsoft Discussion document into which you want to import the content.
Now, go to Home > Paste > Paste Special.
Farther, select the Paste link pick and modify the type to Microsoft Excel Worksheet Object.
Finally, striking the OK button.
Y'all'll now see the cells you selected right in your Microsoft Word document. And considering you selected Paste Link instead of Paste, those cells volition automatically update whenever yous make changes in your Microsoft Excel spreadsheet.

Then if you're not going to demand updates—if yous're printing, or you're going to e-mail the file to someone else, and it needs to show the correct data, for example—you might want to use Paste. This is quite a handy feature if y'all want to easily transfer data from Excel to Give-and-take automatically.

ii. Import a Single Cell From Microsoft Excel

Thankfully, yous can also use the aforementioned method as higher up for individual cells.

However, in this case, instead of selecting Microsoft Excel Worksheet Object, you've got to select Unformatted Text; this is why the number comes in with the same formatting as the rest of the Microsoft Discussion document.

It is still updated in the aforementioned style, simply y'all don't have to deal with trying to get the text box in the correct identify.

Y'all tin can employ the same method to format an entire table in your Word certificate. If this isn't working, or you lot demand more complicated behavior from your single cell, you lot can effort using Visual Basic to integrate Excel information into your Give-and-take certificate.

3. Import a Graph or Chart From Microsoft Excel

Just like importing a table, it can be very convenient to import a graph or chart from Microsoft Excel into Word then that it automatically updates whenever you brand changes to the Excel spreadsheet.

This could exist peculiarly useful if y'all have to create regular reports that include graphs. Fortunately, Microsoft has made this process extremely easy: only copy and paste the graph from Microsoft Excel into Discussion.

You lot can as well click and elevate the graph from Microsoft Excel to Discussion to embed it in the file. Either manner y'all go, the chart will now automatically update whenever you make changes to the original spreadsheet.

4. Mail Merge From Microsoft Excel

Mail merge lets you lot quickly and hands generate several identical letters, each with its own layout, formatting, and text. When you transport a mail merge, Microsoft Give-and-take connects your Excel file to your document.

However, before you start the merge, make sure that your Excel file has all the showtime and last names, salutations, cypher codes, and addresses that you want to put in your document.

If yous're a newbie, you should read our article on how to mail merge in Give-and-take for a more in-depth look at the topic. Information technology tin take a while to get the hang of using postal service merge, but once you get it, it will be one of the virtually useful tools in your Office armory.

v. Importing PDF Files

For text-based PDFs, this method isn't very useful. But if in that location are any images in the file, information technology'south much easier than having to re-create and paste or finding a manner to turn the PDF into an image file, so y'all tin can insert them into your Microsoft Discussion certificate.

Follow these elementary steps to add a PDF to Give-and-take:

Open the Discussion certificate where yous want to add together the PDF file and click on the Insert > Object button.
At present, in the object window, select Create from File.
Click the Browse push and navigate to the PDF you lot want to include.
Later on locating it, select the file and click Insert.
Finally, click OK.

When you import a PDF into Microsoft Give-and-take, it comes in equally an epitome file, non a text file like it would be on its ain.

To learn how to insert a PDF into Word while retaining the capacity to edit information technology, click Insert > the arrow next to Object > Text from File. This instructs Word to make an editable PDF version of the document and put it into it.

6. Automatically Importing Text From Other Word Documents

If you need to type the same matter on a regular ground, you might be able to save time by putting it in a Microsoft Word document and simply referencing it from another document.

Let's say you have a bunch of class messages that you need to send that all need to include your name and the visitor y'all work for, but your employer changes on a regular basis.

Yous don't want to modify every alphabetic character whenever y'all get a new contract, so you tin can but store your signoff in one certificate and have all the others updated whenever you make a change.

Going through an example will help make this clear. Here's an "updateable text" certificate that we've saved:

Suppose you desire to include both of these things—a signoff and contact information—in each of the messages. To do this, you've got to create a bookmark for each one.

Follow these steps sequentially to create a bookmark and auto-import text with ease.

Create a Word certificate and enter the text you need most of the fourth dimension.
To create a bookmark, highlight the text you lot want to link to other documents, so click Insert > Bookmark on the ribbon.
Now, blazon in the name of your bookmark and click Add.
At present, save the file and make a notation of the full path to where it's saved. For example, we've saved our file on the Desktop, and then the path is C:\Users\HIMAN\Desktop\Signoff.docx.
To insert your saved text, go to some other Microsoft Give-and-take document and hitting Insert > Field. Select IncludeText from the Field Names bill of fare.
Now, in the Filename or URL text box, type the path where you've saved your previous file.
Finally, hit OK, and you'll run into the text inserted into your document.

This might seem like a lot of piece of work, simply if you have to blazon the same things on a regular ground, information technology could relieve yous a huge corporeality of time in the long run.

Information technology takes some setup fourth dimension on the front finish, but y'all'll see the convenience of this arrangement immediately.

7. Import Text From a Text File or Microsoft Word Document

If you want to get text from a text file or Give-and-take document without having to open up it—we've got your dorsum. It's extremely simple to exercise that with just one or two clicks. Follow these steps to import only text from a text file or Word certificate:

Open the Discussion file where you want to import all the text.
Now, click Insert > Object > Text from File.
Choose the file from which you desire to extract text and open up it in Give-and-take. If you're unable to view any other file type, simply modify the file type to All Files.
Finally, click Insert.

As a bonus, if yous want to add the header and footer as well, make sure to put the content from the file in a divide department. This volition make certain that the header and footer are just practical to the pages that need them.

viii. Import Text From a Web Page

If you desire to go on an updated copy of a web page in a Microsoft Give-and-take document, you can do that likewise. For this tutorial, we'll be using an online HTML to DOC converter to make this a lot simpler for newbies.

Follow these elementary steps to import text from a web page:

Visit the web page that you want to import and relieve it equally an HTML file. If you're not a geek, you lot can check our guide to larn how to save whatever spider web folio every bit an HTML file using your spider web browser.
Go to convertio.co and upload the file you but saved.
So, click the Convert button.
Download the converted file and open it.

Yous might accept to experiment a bit, but it could potentially be a very useful tool. Hopefully, this method has given you what y'all wanted. At the moment, there aren't many good tools for this because people don't do this very often.

Import Information Easily Into Microsoft Word

We've covered a multifariousness of different types of files that y'all can import into Microsoft Word here—just there are likely boosted options bachelor. These new skills can exist a little difficult to learn at first, but they'll surely pay off in the long run.

Besides that, in that location are a lot of essential writing tips yous can follow most of Microsoft Give-and-take.

8 Essential Writing Tips for Microsoft Word

Read Side by side

Nigh The Writer

Rishabh Chauhan (30 Articles Published)

Rishabh is a Tech Writer who strives to make technology easier to understand. He enjoys writing about Android and other technology-related topics. You can normally notice him tinkering with his Android device when he isn't writing XD.