How to Add Word Data to an Excel File

If you use the Microsoft Office suite, it is easy to transfer data or text created using one program to another. For example, if you want to add data from a Word document to an Excel file, it takes only a few clicks of the mouse to add the data. This saves you time from having to locate, open and copy data from a document.

Instructions

    1

    Open the Excel file from which you want to add data to Word, and then select the worksheet to which you want to add the data.

    2

    Click the "Insert" tab located in the Excel ribbon at the top of the page. You can insert images, charts and data from other files here.

    3

    Look to the "Text" section of the ribbon, and click the arrow next to "Object." Select "Text from file" from the drop-down list of options.

    4

    Select the Word document from which you want to extract data in the box that opens. Scroll through the documents, and when you find the one you want to use, click the file name, and then click "Insert." The text will be added to your Excel spreadsheet.

Blog Archive