Importing Excel Data into Word 2002
- 2
- Add a Comment
One of the most common questions I hear when doing Office training is “How do I import data from Excel into my document?” Well there are a few different ways in which you can import data from Excel. The method you use will depend on whether or not you want the Excel data to retain its functionality in Word.
If you want, you can simply copy and paste your data into Word. When you do this, all the Excel data is converted into a Word table. So the Excel data does not retain any of its functionality once it’s pasted into word.
To perform this simple replication of data, use the steps outlined below:
- Open your Word document.
- Open your Excel spreadsheet.
- Within Excel, select the cells you want to copy into Word.
- From the Edit menu, click Copy.
- Switch to your Word document.
- Place the insertion point where you want the data.
- From the Edit menu, click Paste.
You can then modify the data in the table as you would any other Word table.

2 Comments
Alison Martin
April 18th, 2007
at 2:14am
I hope you can help me with a problem merging an Excel spreadsheet into my Word master document which has the merge fields.
One column of has numbers, ie 0000 but one shown as A0000 merges as just 0
Some cells in another column are shown as 1,394.00 - 8% which when merged come out as 1239.08
There is also wording “20c in every $ incl allowances” which doesn’t convert either.
Mike Rider
April 26th, 2007
at 5:57pm
Alison, If you save your excel sheet as a Text Tab Delimeted and then mail merge it. The numbers should come out oK