the tables in Word documents do not have the functions of sorting, calculation and statistics, if we want to process the data in the tables, we must convert them into Excel. There are 3 ways to batch convert Word tables into Excel without deformation: HeSoft Doc Batch Tool Online document conversion tool, VBA macro automatically copy and paste. The following is a detailed description of the specific steps of each method.
Under what circumstances should Word tables be converted into Excel
1. The documents sent by colleagues and leaders are in docx format. We need to filter, count and sum the data in the documents. Word documents do not have this function and must be converted into Excel.
2. The application forms, information collection forms and other forms we received are all in the form of Word documents. The form contains information such as name, telephone number, department, etc. We need to sort, de-weight or summarize the information and convert it into Excel to process it quickly.
3. Many of the company's data are Word documents in docx format, which need to be converted into Excel for unified management.
To sum up, when we need to do all kinds of processing on the data in the table, because the Word table does not have the function of statistical calculation, it must be converted into an Excel table. Excel has powerful data calculation, analysis, sorting function. When we have a lot of Word to convert to Excel, we must learn how to batch convert to quickly improve work efficiency.
Word table into Excel table effect preview
before treatment:
after treatment:
Method 1: Use HeSoft Doc Batch Tool Batch convert Word to Excel
recommended Index:★★★★★
Advantages: The operation steps are very simple, just select Word to Excel, and then add files, and the conversion can be completed automatically. The conversion speed is fast, the effect is good, the table is not easy to deform, and it supports one-click batch conversion of hundreds of files.
Disadvantages: need to be installed on the computer.
Operation steps:
1. Open 【 HeSoft Doc Batch Tool ], select [Word Tool]-[Word to Excel]].
2. Add all Word documents that need to be converted.
3. After the conversion is completed, click the save location to view, and all docx documents are changed to xlsx format.
Method 2: Use the Online converter Online Conversion Tool
recommended Index:★★★☆ ☆
advantages: No need to download and install, as long as there is a network, open the browser to search for this tool can be used directly. The operation is simple and direct, upload files, choose to convert to xlsx format, and download to the local after the conversion is completed.
Disadvantages: Need to upload files to a third-party server, insufficient security.
Operation steps:
open the [Online converter] online tool and select [Document converter]-[Convert to XLSX]]. Upload the Word document, wait for the conversion to complete, and finally download the xlsx file to your computer.
Method 3: Use VBA macro to automatically copy Word form and paste it into Excel
recommended Index:★★★☆ ☆
advantages: No need to use other tools, Office's own macro functions can be used without a network. And VBA macro is to automatically copy the table and paste it into Excel, which can keep the original appearance of the table to the greatest extent without destroying typesetting and formatting.
Disadvantages: The operation is difficult, you need to find the available code yourself, and it is not very friendly to novices.
Operation steps:
1. Put all the Word documents to be converted into the same folder, and then create a new blank Excel file.
2. Open the newly-built Excel, press [Alt F11] to open the VBA editor, click [Insert]-[Module], paste the code in, and change the file path to the path where Word documents are stored.
3. Press F5 to run, it will automatically help you copy the Word form into Excel, and finally save it as. xlsx.
