Excel has the functionality to make the conversion if you have data in a Microsoft Word document that you need to import into a Microsoft Excel spreadsheet. To convert your Word document to plain text and import it into Excel, choose the Word and Excel versions you are using and follow the on-screen instructions.
Table of Contents
365 Microsoft Office
Open the Word file containing the data you wish to transfer to Excel.
Select the Save As option under the File tab on the ribbon.
Change the file type to Plain Text, input a file name, then select the place on your computer where you wish to save the plain text file. Click Save after giving the file a name and selecting a location.
A pop-up window for file conversion appears. Click Ok while Windows is selected.
The Word document and the software can now be closed.
Launch Excel, then select New > Blank Workbook.
Click the Data tab and then the From Text/CSV option on the ribbon.
On your computer, locate the directory where you saved the plain text file in step 3. Click Import after selecting the file.
You are prompted by Excel to enter the file origin, delimiter, and data type in a blank pop-up box. Click Upload after making sure the default information is accurate. Make any required corrections to any inaccurate information before clicking Upload. The format of the imported data is now right in Excel.
Open the Word file containing the data you wish to transfer to Excel.
Select the Save As option under the File tab on the ribbon.
Change the file type to Plain Text, input a file name, then select the place on your computer where you wish to save the plain text file. Click Save after giving the file a name and selecting a location.
A pop-up window for file conversion appears. Click Ok while Windows is selected.
The Word document and the software can now be closed.
Launch Excel, then select New > Blank Workbook.
Click the Data tab and then the From Text option on the ribbon.
On your computer, locate the directory where you saved the plain text file in step 3. Click Import after clicking the file name.
Click Delimited on step 1 of the Import Text Wizard’s three steps before selecting Next.
In step 2 of 3 select the required delimiters (space, comma, tab, etc.) by checking the box next to them, and 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. Select Ok. The format of the imported data is now right in Excel.
