Two Easy Ways to convert or import Word document contents to Excel worksheet

Sometimes, you may need to convert a Word document to Excel worksheet or import the Word document data to worksheet, do you know any quick way instead of copying and pasting? This tutorial provides two easiest ways to handle this job.

• Method A: Convert Word to Excel with the Save As and the From Text utility (7 steps)
  Cannot import/convert charts from Word to Excel, one file imported once time.
• Method B: Convert Word to Excel with the VBA (4 steps)
  Import all data from Word to Excel, but the charts may be overlapped
• Relative Operation: Batch convert Excel workbooks to PDF files
  Batch convert Excel files in folders to separated PDF files
• Other Operations (Articles) Related To File Conversion
  Convert Excel table to PDF  Batch import csv/txt/xml files to Excel and so on

To convert Word document to Excel worksheet, you can combine Save As function in Word and From Text function in Excel.

1. Open the Word document you want to Excel worksheet, click File > Save As command, then click Browse to open Save As dialog, choose one destination to place the new file, and in the Save as type drop-down list, select Plain Text.

2. Click Save to save the Word document as new text file, then a File Conversion dialog pops out, just click OK to close the dialog.

3. Then enable the Excel workbook you want to import Word document data, click Data > From Text, and in Import Text File dialog, select the text file you want to import.

4. Check Delimited option, click Next.

5. In the step 2 of the wizard, check the delimiter you want to split the data based on, click Next.

6. In the last step of the wizard, you can specify the format of data, if you do not need to change the format, check General option.

7. Click Finish. Then the Import Data dialog pops out, you can choose one cell of the active worksheet to place the import text data, or check New worksheet option to import data in a new sheet. Click OK.

Then the Word document contents have been imported in Excel worksheet.

Note:

If you want to convert Word document data to Excel worksheet (convert data delimited based a separator in Word document to a table in Excel) as below screenshot shown, this method will be a good choice，but if you just want to import all Word document data including graphs to Excel worksheet, please go to method B.

---

quickly convert multiple XLSX. files to XLS or PDF. files in once time

In many cases, you may want to convert between XLSX and XLS, or convert a workbook to PDF file, but in Excel, you only can convert one workbook once time, have you ever imaged to convert multiple workbooks at once time? With Kutools for Excel's File Format Converter, you can quickly convert multiple workbook to pdf/97-2003 workbook/2007 or higher workbook at once and save them in a folder, at the same time, a converted report is generated!  Click for free full featured trial in 30 days!

Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.

If you want to convert or import all data in Word document to Excel, you can use VBA code.

1. Press Alt + F11 key to enable Microsoft Visual Basic for Applications window.

2. Click Insert > Module to create a new Module script, copy and paste below code to the script.

VBA code: Import Word To Excel

  Sub ImportWord()
'UpdatebyExtendoffice20190530

Dim xObjDoc As Object

Dim xWdApp As Object

Dim xWdName As Variant

Dim xWb As Workbook

Dim xWs As Worksheet

Dim xName As String

Dim xPC, xRPP

Application.ScreenUpdating = False

Application.DisplayAlerts = False

xWdName = Application.GetOpenFilename("Word file(*.doc;*.docx) ,*.doc;*.docx", , "Kutools - Please select")

If xWdName = False Then Exit Sub

Application.ScreenUpdating = False

Set xWb = Application.ActiveWorkbook

Set xWs = xWb.Worksheets.Add

Set xWdApp = CreateObject("Word.Application")

xWdApp.ScreenUpdating = False

xWdApp.DisplayAlerts = False

Set xObjDoc = xWdApp.Documents.Open(Filename:=xWdName, ReadOnly:=True)

xObjDoc.Activate

xPC = xObjDoc.Paragraphs.Count

Set xRPP = xObjDoc.Range(Start:=xObjDoc.Paragraphs(1).Range.Start, End:=xObjDoc.Paragraphs(xPC).Range.End)

xRPP.Select

On Error Resume Next

xWdApp.Selection.Copy

xName = xObjDoc.Name

xName = Replace(xName, ":", "_")

xName = Replace(xName, "\", "_")

xName = Replace(xName, "/", "_")

xName = Replace(xName, "?", "_")

xName = Replace(xName, "*", "_")

xName = Replace(xName, "[", "_")

xName = Replace(xName, "]", "_")

If Len(xName) > 31 Then

    xName = Left(xName, 31)

End If

xWs.Name = xName

xWs.Range("A1").Select

xWs.Paste

xObjDoc.Close

Set xObjDoc = Nothing

xWdApp.DisplayAlerts = True

xWdApp.ScreenUpdating = True

xWdApp.Quit (wdDoNotSaveChanges)

Application.DisplayAlerts = True

Application.ScreenUpdating = True

End Sub

3. Press F5 key to run the code, a Kutools – Please select dialog pops out for you to select one Word document to import (only can import one document once time).

4. Click Open, then the selected Word document will be imported as one new sheet. See screenshot:
Tip: The new sheet will be auto named with the name of imported Word.

In reverse, sometimes, you may want to convert Excel workbooks to other file formats, such as PDF file. In this section, it introduces an advanced tool – Format Converter can help you batch convert Excel workbooks of one folder to separate PDF files.

Before applying this tool, please take minutes to free install Kutools for Excel firstly.

1. Click Kutools Plus > Workbook > Format Converter.

2. In the File Format Converter dialog,

1. Select the conversion operation as you need in Type drop-down list, such as Excel workbook to PDF;
2. Click  to add files or folders you want to convert.
3. Select one destination to place the converted files.

3. Click Ok, a new workbook created to list the conversion result for you, and at the meanwhile, the files have been done conversion.

Tip:

With the Format Converter tool, you can batch convert between Excel 97-2003 and Excel 2007 or higher versions also.