Skip to main content

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)

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.
doc convert word to excel 3

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.
doc convert word to excel 4

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.
doc convert word to excel 5
doc convert word to excel 20

4. Check Delimited option, click Next.
doc convert word to excel 6

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

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.
doc convert word to excel 8

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.
doc convert word to excel 9

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.

doc convert word to excel 1 doc arrow doc convert word to excel 2

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!
doc file format
 
Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.

Method B: Convert Word to Excel with the VBA (4 steps)

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

doc convert word to excel 10

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).
doc convert word to excel 11

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.

doc convert word to excel 12

Note:

If there are multiple graphs (pictures, charts, formulas), they may be overlapped by each other.
doc convert word to excel 19


doc file convert

Five File Format Converters Boots Your Efficiency By 90%, Leave Much Time To Enjoy Life

▲ Batch convert files with clicks, such as Format Converter (convert between xlsx and xls, convert Excel to PDF).

▲ Except tools displayed in picture, there are 200 advanced tools else in Kutools for Excel, which can solve your 82% Excel puzzles.

▲ Become an Excel expert in 5 minutes, gain people's recognition and promotion.

▲ 110000+ high efficiency people sand 300+ world renowned companies' choice.

30-days free trial, no credit card require


Relative Operation: Batch convert Excel workbooks to PDF files

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.

Kutools for Excel is a powerful and helpful Excel add-in, which contains 229 utilities (is still increasing) can handle 91% Excel puzzles.

1. Click Kutools Plus > Workbook > Format Converter.
doc convert word to excel 13

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  doc add to add files or folders you want to convert.
  3. Select one destination to place the converted files.

doc convert word to excel 14

3. Click Ok, a new workbook created to list the conversion result for you, and at the meanwhile, the files have been done conversion.
doc convert word to excel 15
doc convert word to excel 16

Tip:

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

Know more details about Format Converter.

Demo: File Converter


Other Operations (Articles) Related To File Conversion

Convert Excel table to PDF
This article introduces three ways on convert one or all Excel tables to separated PDF files.

Batch import multiple csv/txt/xml files to Excel
In this tutorial, it lists several VBA codes help you quickly import csv/txt/xml files from one folder to one single Excel sheet, also introduces a helpful add-in tool which can solve almost of importing and exporting puzzels in Excel

Convert PDF to Excel sheet
Here introduce the way to convert one PDF to one Excel sheet, and the way to convert a Excel range to PDF file with steps.

Convert a text file to an Excel sheet
Here using the Open command or a trick to insert a text file to Excel, data is delimited by a separator.

Convert XLSX file to XLS or PDF file
In some cases, we may want to convert Excel 2007 or higher xlsx file to Excel 97-2003 xls file or PDF file. In Excel, we may use the Save as command to solve this task, but here I can introduce you a good converter to quickly convert multiple xlsx files to xls files or pdf files in Excel.

Convert Excel to Word document
In this article, it provides two ways to convert a Excel sheet to Word document, one is using the Copy and Paste Command, the another one is inserting Excel sheet to Word as object.


  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns and Keeping Data; Split Cells Content; Combine Duplicate Rows and Sum/Average... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Favorite and Quickly Insert Formulas, Ranges, Charts and Pictures; Encrypt Cells with password; Create Mailing List and send emails...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • Pivot Table Grouping by week number, day of week and more... Show Unlocked, Locked Cells by different colors; Highlight Cells That Have Formula/Name...
kte tab 201905
  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Comments (17)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Hello ,Real gerat works good .I have one Question , what i have to change that the Copy is every time in the same Worksheed Named Technician .Thanks for your helpRegardsGuido
This comment was minimized by the moderator on the site
Is it possible to import data from a word to excel on colors algorithm? So, I spell the cities with red and countries with blue in a word document, and then to import only these to excel. I don’t know if I made myself clear. Thanks
This comment was minimized by the moderator on the site
Hi there, what if you wanted to copy paragraphs after the table of contents in the word document instead of the entire document?
This comment was minimized by the moderator on the site
Hi, ak, what is you mean? To copy the paragraphs after a table, just select the paragraphs only and copy them. Please explain your question in more details.
This comment was minimized by the moderator on the site
با سلام : مطلب نحوه تبدیل word به اکسل کمک خیلی زیادی به من کرد خیلی خیلی از مطالب مفیدتان ممنونم
This comment was minimized by the moderator on the site
Super helpful, thank you!
This comment was minimized by the moderator on the site
Soooo helpful! :)
This comment was minimized by the moderator on the site
Thank you SO much! Your directions on turning a Word document into an Excel spreadsheet worked perfectly. You just save me hours of time!
This comment was minimized by the moderator on the site
thankyou so much.....great relif!!
This comment was minimized by the moderator on the site
Thank you so much! that was very helpful and easy to follow.
This comment was minimized by the moderator on the site
really helpful.well explained.
thanks you :)
There are no comments posted here yet
Load More
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations