There are two straightforward methods for moving data from a Word document into an Excel workbook.

If you need to import data from a Word document into an Excel worksheet or perform a conversion from Word to Excel, do you have a fast method at your disposal other than copying and pasting? This guide will show you the two simplest approaches to completing the task at hand.

Word's Save As feature and Excel's From Text wizard can be used together to turn any Word doc into an editable Excel sheet.

To convert a Word document into an Excel worksheet: 1. Open the document in Word; click the File > Save As command; 2. Click Browse to open the Save As dialog; 3. Select a location to save the new file; 4. In the Save as type drop-down list, select Plain Text 5.

A File Conversion dialog will appear after you click Save to convert the Word file to text format; after making your selection, click OK to dismiss the window.

When you're ready to import data from a Word document into an Excel workbook, you'll need to enable the workbook, go to Data > From Text, and then, in the Import Text File dialog, choose the file to import.

4. Select Delimited, then click Next

Step 2 of the wizard's instructions ask you to select the delimiter you'll use to divide the data.

In step six of the wizard, you can choose the data format; if you don't need to make any changes, select the "General" option.

Then, in Step 7, select the Finish button. When you click the Import button, a dialogue box will appear asking where you'd like to import the text data. You have the option of placing it in an existing cell on the active worksheet, or creating a new one by selecting the New worksheet option. Click OK

Then the information from the Word document was transferred to the Excel sheet.

Using VBA code, you can transfer all the information from a Word document to an Excel spreadsheet.

To open the Visual Basic for Applications editor in Microsoft Office, press Alt + F11.

2. Create a new Module script by clicking Insert > Module, and then paste the code below into it.

How to Import Word Documents into Excel Using Visual Basic for Applications

Use Case: ImportWord() 'UpdatebyExtendoffice20190530 Declare xObjDoc As Object To Create An Object Variable Of Name xWdApp Fill In xWdName As Variant Set xWb To Be A Workbook Assign xWs To A Worksheet Replace xName with a string variable. Initialize variables (xPC, xRPP) Application When ScreenUpdating = FALSE, the screen does not update. Application False if DisplayAlerts is set. Aplication xWdName = For a Word document, open GetOpenFilename("Word file(* doc;* docx) ,* doc;* Document Format (.docx), (Kutools - Pick One), When xWdName is not equal to false, the subroutine is terminated. Application The value of ScreenUpdating is untrue. Input xWb = Program ActiveWorkbook Put xWs = xWb. Worksheets Add To do this, go to xWdApp = CreateObject("Word Application") xWdApp UpdateScreen = False xWdApp NotifyMe = False To make xObjDoc equal to xWdApp, just swap the two variables. Documents Specifically, I would like to open the file with the following syntax: open(Filename:=xWdName, ReadOnly:=True xObjDoc Activate Ans: xPC = xObjDoc Paragraphs Count Input: xObjDoc = xRPP Range(Start:=xObjDoc Paragraphs(1) Range Beginning, Closing: =xObjDoc Paragraphs(xPC) Range End) xRPP Select This Error Will Be Carried Over to the Next Step xWdApp Selection Copy "xName" = "xObjDoc" Name Replace(xName, ":", "_") A name is changed by typing Replace(xName, "", "_") For example, xName = Replace(xName, "/", "_"). To change a name, type: xName = Replace(xName, " ", "_") Replace(xName, "*", "_") Replace(xName, "[", "_") Name = Replace(xName, "]", "_") If Len(xName) is Larger Than 31 In other words, xName = Left(xName, 31) End If xWs Title = xName xWs Range("A1") Select xWs Paste xObjDoc Close To make xObjDoc equal to nothing, set this. xWdApp When DisplayAlerts = True xWdApp The value of ScreenUpdating is True xWdApp Abandon (wdDoNotSaveChanges) Application When Alerts are displayed, set DisplayAlerts to True. Application UpdateScreen = Real End Sub

After you press the F5 key to run the code, a Kutools - Please select dialog will appear, from which you can choose a single Word document to import (you can only import a single file at a time).

When you select a Word file and click Open, Excel will create a new sheet based on the information contained in the file you chose. Check out the screenshot:
You can import a Word document and the new sheet will be named after the document.

On the flip side, there are times when you might need to convert Excel files to something else, like a PDF. Format Converter is an advanced tool introduced here that can convert multiple Excel files in a folder to individual PDFs.

Please take a few moments to download and install Kutools for Excel for free before using this tool.

Kutools for Excel is an impressive and useful Excel add-in that currently includes 229 utilities and can solve 91% of all Excel problems.

To convert your Kutools Plus workbook to another format, follow these steps: 1.

To begin, open the File Format Converter dialogue by

1. From the Type menu, choose the desired conversion method, such as "Excel to PDF."
2. Click  Insert Target Folder or Files Here
3. You can choose where the converted files will go.

Once you've finished converting your files and clicked "Ok," a new workbook will open and display the results.

Tip:

Excel 97–2003 to Excel 2007 and later versions can be converted in bulk with the Format Converter tool.

Learn the inner workings of Format Converter.

An Explanation of the Conversion of Files