If you need to import data from a Microsoft Word document into an Excel spreadsheet, Excel has the functionality to accomplish the conversion. Choose the Word and Excel versions you’re using, then follow the instructions to convert your Word document to plain text and import it into Excel.
Table of Contents
Microsoft Office 365
You should first open the Word document containing the data you wish to transfer to Excel.
Click the File tab in the Ribbon and then select Save As.
Change the file type to Plain Text, give the file a name, then select the directory on your computer where you wish to save the plain text file. Once you’ve selected the location and given the file a name, click Save.
This opens a pop-up window for file conversion. Click Ok after leaving Windows (default) checked.
The Word software and document can now be closed.
Launch Excel, then select New -> Blank Workbook.
Select the From Text/CSV button under the Data tab on the Ribbon.
Go to the computer’s location where you stored the plain text file in step and locate it.
Click Import after selecting the file.
To define the File Origin, Delimiter, and Data Type detection, Excel displays a blank pop-up window. Click Load after making sure the default information is accurate. Make any required corrections if any information is incorrect, then click the Load button. The format of the imported data is now right in Excel.
You should first open the Word document containing the data you wish to transfer to Excel.
Click the File tab in the Ribbon and then select Save As.
Change the file type to Plain Text, give the file a name, then select the directory on your computer where you wish to save the plain text file. Click Save after naming the file and selecting a location.
This opens a pop-up window for file conversion, pick the Windows (default) checked.
Press Ok.
The Word software and document can now be closed.
Launch Excel, then select New -> Blank Workbook.
Select the From Text option under the Data tab on the Ribbon.
In step 3, you stored the plain text file somewhere on your computer. Find that place.
Click Import after clicking the file name.
On step 1 of the Text Import Wizard’s third phase, choose Delimited, then press Next.
In step 2 of 3, select the required delimiters (space, comma, tab, etc.) by checking the box next to them, then click Next.
Verify that all of the information is accurate in step 3 of 3, make any required corrections, and then click Finish.
If Existing Worksheet was checked, choose the cell where you want the data to go. The imported data is now in Excel’s proper format when you click Ok.
