There are several ways to import data from an Excel worksheet into a Word document. Which method you use will depend on how you plan to use the data after it is imported into your Word document.

METHOD 1)
The simplest way to import Excel data into a Word document is to copy the data from the Excel worksheet then paste it into the Word document.
1. In your Excel worksheet, highlight the data/spreadsheet you want to transfer to Word click the "copy" icon (or Ctrl C) this will copy the data onto the clipboard.
2. Go to the Word document, place the cursor where you want to import the Excel data, click the "paste" icon (or Ctrl V). This will paste the data from the clipboard into the Word document.

Use this method if the Excel data is complete, and you have no desire to make any amendments to the data after it is imported into Word. It is possible to make changes to the data i.e. you can change figures. However, you will not be able to perform any Excel functions if you use this procedure. For example, if the figures in a column are totaled, and you change a number in the column you will not be able to use the sum function as you would in Excel to compute the new total.

METHOD 2)
Another method you can use to import data from Excel to Word is the paste special command.
1. Select the data/spreadsheet that you want to transfer from Excel to Word click the "copy" icon (or Ctrl C).
2. Move to the Word document, place the cursor where you want to import the Excel data.
3. Go to the "edit" dropdown box (on the command bar) and click. Move down to "paste special", select "Microsoft office Excel Worksheet object". This will import the Excel data into your word document.

Use this method if you will need to make changes to the Excel data, as well as use the Excel function. To amend the data, first click once anywhere on the imported data to select. Then double click inside the box that appeared around the data. The data will then look the same as a worksheet in Excel. You can now perform any functions that you would perform in Excel. Any changes you make to the data after importing it into Word will not affect the original spreadsheet in your Excel worksheet.

METHOD 3)
A third method you can use to import data from Excel to Word is to use the "paste as a hyperlink command".
1. Copy the data from Excel the same as in methods 1) and 2).
2. Position the cursor in the Word document where you want to import the Excel data.
3. Move to the "edit" dropdown box and click. Move down to "paste as a hyperlink" then click. This will import the Excel data into your word document.

You can make changes to the data and perform any Excel functions, using the same procedures described in Method 2). However, unlike in Method 2) any changes you make to the data after importing it into Word will also change the original spreadsheet in your Excel worksheet. Additionally, you can edit the original spreadsheet that is in Excel and these amendments will automatically appear in the data that was imported into the Word document.

The learning curves for Excel and Word are steep, but once you master them they are fun to use and very help in preparing professional looking document. So if you find it difficult at first stick to it, you will receive tremendous benefits in the end.

Learn more about this author, M. R. Hill.
Click here to send author comments or questions.

---

Add your voice

Know something about Microsoft Word tips: Importing Excel data?
We want to hear your view. Write now!