How To Convert A List In Word To Excel

Two Like shooting fish in a barrel 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 information to worksheet, practise you know whatsoever quick way instead of copying and pasting? This tutorial provides two easiest means to handle this job.

• Method A: Convert Word to Excel with the Salve As and the From Text utility (seven 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 information from Word to Excel, but the charts may exist overlapped
• Relative Operation: Batch convert Excel workbooks to PDF files Demo
  Batch convert Excel files in folders to separated PDF files
• Other Operations (Articles) Related To File Conversion
  Convert Excel tabular array to PDF  Batch import csv/txt/xml files to Excel and so on

---

Method A: Convert Word to Excel with the Salvage As and the From Text utility (seven steps)

To catechumen Word certificate to Excel worksheet, you tin combine Relieve As function in Discussion and From Text office in Excel.

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

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

3. So 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 y'all want to import.

4. Bank check Delimited selection, click Next.

v. In the step 2 of the sorcerer, check the delimiter you want to split the data based on, click Side by side.

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

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

And then the Word document contents have been imported in Excel worksheet.

Note:

If you lot want to convert Give-and-take document information to Excel worksheet (convert data delimited based a separator in Word document to a table in Excel) as below screenshot shown, this method volition be a skillful pick，but if you just desire to import all Word document data including graphs to Excel worksheet, please become to method B.

---

---

Method B: Catechumen Word to Excel with the VBA (iv steps)

If you want to catechumen or import all information in Word certificate to Excel, you can use VBA lawmaking.

1. Press Alt + F11 key to enable Microsoft Visual Bones 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 Equally Object  Dim xWdApp Every bit 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 = Simulated  xWdName = Awarding.GetOpenFilename("Word file(*.md;*.docx) ,*.doc;*.docx", , "Kutools - Please select")  If xWdName = Fake Then Get out Sub  Application.ScreenUpdating = False  Ready xWb = Application.ActiveWorkbook  Prepare 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  Prepare xRPP = xObjDoc.Range(Commencement:=xObjDoc.Paragraphs(1).Range.Showtime, End:=xObjDoc.Paragraphs(xPC).Range.End)  xRPP.Select  On Error Resume Side by side  xWdApp.Choice.Copy  xName = xObjDoc.Name  xName = Supersede(xName, ":", "_")  xName = Replace(xName, "\", "_")  xName = Replace(xName, "/", "_")  xName = Replace(xName, "?", "_")  xName = Supersede(xName, "*", "_")  xName = Replace(xName, "[", "_")  xName = Supplant(xName, "]", "_")  If Len(xName) > 31 Then      xName = Left(xName, 31)  Stop If  xWs.Proper name = xName  xWs.Range("A1").Select  xWs.Paste  xObjDoc.Close  Prepare xObjDoc = Aught  xWdApp.DisplayAlerts = True  xWdApp.ScreenUpdating = True  xWdApp.Quit (wdDoNotSaveChanges)  Application.DisplayAlerts = True  Awarding.ScreenUpdating = True  End Sub                  

3. Press F5 fundamental to run the code, a Kutools – Delight select dialog pops out for you to select one Give-and-take certificate to import (only tin import 1 document once time).

4. Click Open, then the selected Word document will be imported as one new canvas. See screenshot:
Tip: The new sail will be car named with the name of imported Give-and-take.

Notation:

If there are multiple graphs (pictures, charts, formulas), they may be overlapped by each other.

---

V File Format Converters Boots Your Efficiency By 90%, Leave Much Time To Enjoy Life ▲ Batch catechumen files with clicks, such as Format Converter (catechumen between xlsx and xls, convert Excel to PDF). ▲ Except tools displayed in picture, at that place are 200 advanced tools else in Kutools for Excel, which can solve your 82% Excel puzzles. ▲ Become an Excel expert in v minutes, gain people's recognition and promotion. ▲ 110000+ high efficiency people sand 300+ world renowned companies' selection. 30-days free trial, no credit card require

---

Relative Operation: Batch catechumen Excel workbooks to PDF files

In reverse, sometimes, you may desire to convert Excel workbooks to other file formats, such equally PDF file. In this department, information technology introduces an avant-garde tool – Format Converter can help you batch catechumen Excel workbooks of one folder to separate PDF files.

Earlier applying this tool, please take minutes to gratuitous install Kutools for Excel firstly.

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

one. Click Kutools Plus > Workbook > Format Converter.

2. In the File Format Converter dialog,

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

3. Click Ok, a new workbook created to list the conversion consequence for y'all, and at the meanwhile, the files accept been done conversion.

Tip:

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

Know more than details about Format Converter.

Demo: File Converter

---

Other Operations (Articles) Related To File Conversion

Catechumen Excel table to PDF
This article introduces iii 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 assist yous speedily import csv/txt/xml files from one folder to one single Excel sheet, also introduces a helpful add-in tool which can solve nearly of importing and exporting puzzels in Excel

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

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, simply hither I can introduce y'all a good converter to chop-chop convert multiple xlsx files to xls files or pdf files in Excel.

Convert Excel to Word document
In this article, it provides 2 ways to convert a Excel canvass to Word certificate, i is using the Copy and Paste Command, the another ane is inserting Excel sail to Word as object.

---

---

The All-time Office Productivity Tools

Kutools for Excel Solves Virtually of Your Problems, and Increases Your Productivity by 80%

• 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 Information; Split Cells Content; Combine Duplicate Rows and Sum/Average... Preclude 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 Re-create Multiple Cells without irresolute 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 countersign; Create Mailing Listing and send emails...
• Extract Text, Add Text, Remove by Position, Remove Space; Create and Impress Paging Subtotals; Convert Between Cells Content and Comments...
• Super Filter (save and apply filter schemes to other sheets); Avant-garde Sort past month/week/twenty-four hour period, frequency and more; Special Filter by bold, italic...
• Combine Workbooks and WorkSheets; Merge Tables based on cardinal columns; Split Information into Multiple Sheets; Batch Convert xls, xlsx and PDF...
• Pivot Table Group by week number, twenty-four hours of week and more... Show Unlocked, Locked Cells by different colors; Highlight Cells That Have Formula/Name...

---

Office Tab - brings tabbed interface to Role, and make your work much easier

• Enable tabbed editing and reading in Word, Excel, PowerPoint , Publisher, Admission, 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 24-hour interval!

Source: https://www.extendoffice.com/documents/excel/2481-convert-word-to-excel.html

Posted by: rudeagiand1969.blogspot.com

Share this post