Import Excel 2007 Data Into Word
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.
- On the Home tab, in the Clipboard group, click Copy.
- Switch to your Word document.
- Place the insertion point where you want the data.
- Press CTRL + V.
You can then modify the data in the table as you would any other Word table.

5 Comments
vm
June 9th, 2007
at 5:07am
how to get rid of the excel formatting, if the text in excel has been formatted with colors like grey color, bold, underline, etc, i used paste special… unformatted text and it would then lose the table format, there is no option to just impot/copy paste an excel table as plain word table with no formatting.
David thomas
June 11th, 2007
at 2:37pm
Thanks, now how do I import it AND retain some functionality?
blair
January 16th, 2008
at 11:11pm
This only works (any import it seems) as long as the document is not more than one page long. Otherwise you have to copy and paste one page at a time. Maybe there is an easier way, but MS Help and Googling around doesn’t seem to bring in the answer.
Roger
May 21st, 2008
at 5:52pm
I believe the question asked about IMPORTING, not cutting and pasting. I’m still looking for the importing directions.
kent steen
May 24th, 2009
at 7:28am
It does appear that we have lost an important feature, e.g. create a flow chart in excel, import whole file into word.