How to convert a Word file to Excel
You have a Word file but you want to switch to Excel to make it easier to calculate and process data. But if you enter it again, it will take a lot of time, so you are looking to convert Word files into Excel. Below the article guides you two ways to convert Word files to Excel, please refer.
How to convert a Word file to Excel Picture 1
Method 1: Save Plain Text format and import into Excel
Step 1: Open the Word file that you want to convert to Excel worksheet, select File -> Save As -> Browse (or press F12 key ) to open the Save As window to save the file. .
How to convert a Word file to Excel Picture 2
Step 2 : In the Save As window, enter the navigation to any folder to save the file, in the Save as type section, select Plain Text format and select Save .
How to convert a Word file to Excel Picture 3
Step 3: File Conversion appears, select Other encoding and select Unicode (UTF-8) if your Word uses built-in Unicode to avoid converting to Plain Text with font errors. Then click OK to save the Word file as Plain Text.
How to convert a Word file to Excel Picture 4
Step 4 : Open the new Excel file, on the Excel interface, select Data -> From Text tab .
How to convert a Word file to Excel Picture 5
Step 5 : The Import Text File window appears, select the Plain Text file you just saved and select Import .
How to convert a Word file to Excel Picture 6
Step 6 : In the Text Import Wizard window - select Step 1 of 3, select Delimited , if the data in Word is a table and include column headings, then check the box for My data has headers . Next click Next .
How to convert a Word file to Excel Picture 7
Step 7 : Next in the Text Import Wizard window - Step 2 of 3 you choose the delimiters included in Word to separate the column in Word, if you do not want to separate the data by the delimiter, you deselect in all options then click Next .
How to convert a Word file to Excel Picture 8
Step 8: Select the type of data format in the Text Import Wizard - Step 3 of 3. Next, click Finish .
How to convert a Word file to Excel Picture 9
Step 9: Next, in the Import Data dialog box, select the location to put the data into: Exitsting worksheet (current sheet); New worksheet (new sheet). Then click OK .
How to convert a Word file to Excel Picture 10
Then you save the Excel file again, so you've moved the Word file to Excel already.
How to convert a Word file to Excel Picture 11
Method 2: Use MS Word To Excel Converter Software
Step 1: You need to download and install MS Word To Excel Converter Software to the system.
- Link to download software http://www.sobolsoft.com/convertwordexcel/download/setup.exe
Step 2 : Run the program, on the interface you select Add Doc File (s), you can select all Word files in a folder by selecting Add All Doc File (s) In Folder.
How to convert a Word file to Excel Picture 12
Step 3 : The Add File window appears, select the Word file to convert to Excel and click Open .
How to convert a Word file to Excel Picture 13
Step 4 : In the Conversion Options section (1), choose the separation options:
- Do not split: do not split.
- Split by comma: separated by commas.
- Split by comma-space: separate with commas - spaces.
- Split by space: separated by spaces.
In the Save Results To This Folder (2) section, select the path to save the Excel file after converting from Word file. Then choose Start Converting (3).
How to convert a Word file to Excel Picture 14
The success message appears, select OK .
How to convert a Word file to Excel Picture 15
The result you will receive Excel file, you can open up to see the results.
How to convert a Word file to Excel Picture 16
Above the article has guided you two ways to convert Word files to Excel, hope you will be able to quickly convert Word files to Excel with two ways that the article has shared. Good luck!
You should read it
- How to convert Word to a CSV file
- How to Convert Excel to Word
- How to convert Cad to Word, PDF, Excel
- How to convert PDF files to Word Online very fast
- How to Convert Word to Excel
- How to convert a Word file to an image file - Save the Word file as an image
- Professional PDF file conversion software for Word
- Convert Word files to PDF, convert DOC / DOCX files into PDF quickly
- Convert PDF to Word, convert PDF files for free
- 2 ways to convert JPG image file to PDF
- How to insert a Word document into an Excel file
- How to convert a CSV file to Excel
May be interested
Other diacritics in Excel, different diacritics in Excel
How to calculate percentages in Excel, the percentage calculation in Excel is the fastest and most standard
Keyboard shortcut in Excel, how to delete lines in Excel with keyboard shortcuts
How to read the amount in words in Excel
How to filter duplicate data from 2 Sheets in Excel
How to quickly save all pictures in Word file into a separate folder