Cookies help us deliver our services. By using our services, you agree to our use of cookies.
Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to convert word document to excel worksheet?

In some cases, you may want to convert a word document to an Excel worksheet, here I will tell you the way to finish this conversion.

Convert word document to Excel

Convert Excel file to PDF filegood idea3


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

Convert word document to Excel


1. Open the word document you want to convert to an Excel worksheet, and click File or Office Button > Save As. Then select a location you want to put at, and select Plain Text from the drop down list of Save as Type.

doc-word-to-excel-1doc-word-to-excel-2

Note: In Word 2013, click File > Save As > Computer > Browse.

2. Click Save, then click > OK to close the File Conversion dialog. Then close the word document.

3. Now open Excel, and click Data > From Text. See screenshot:
doc-word-to-excel-4

4. Then in the popping dialog, select the text file you saved at step 1, and click Import.
doc-word-to-excel-5

5. Check Delimited option in the Text Import Wizard – Step 1of 3 dialog, click Next.
doc-word-to-excel-6

6. In this step, check the delimiters you need (if you do not want the data split by delimiters, do not check any option), then click Next.doc-word-to-excel-7

7. Then you can specify the data format in Step 3 of 3. Click Finish.
doc-word-to-excel-8

8. Then select a cell to put the data if you check Existing worksheet. See screenshot:
doc-word-to-excel-9

9. Click OK. Now you can save the worksheet.
doc-word-to-excel-10


Convert Excel file to PDF file

If you want to convert dozens of workbooks from folders to PDF files, you do not need to convert them one by one while you have Kutools for Excel. Its Format Converter utility can do you a favor on conversion between Excel files and PDF files, or xls files and xlsx files.

Kutools for Excel, with more than 200 handy functions, makes your jobs more easier. 

After installing Kutools for Excel, please do as below:(Free Download Kutools for Excel Now!)

1. Enable Excel and click Enterprise > Workbook > Format Converter. See screenshot:
doc file converter 1

2. In the Format Converter dialog, do as below operation.

1) Select the convert type you need in the Type drop down list.
doc file converter 2

2) Add files or folders to convert.
doc file converter 3

3) Choose a folder to place the files.
doc file converter 4

doc file converter 5

3. Click Ok, and the files have been converted, and a new sheet list the converted information for you.
doc file converter 6

Tip. If you want to have a free trial of the Format Converter function, please go to free try Kutools for Excel first, and then go to apply the operation according above steps.


quickly convert or export a range of a sheet to separate XLS/Word/PDF or other format files in once time

Normally, Excel does not support you with an option to quickly export or save a range as a CSV or Excel file. If you want to save a range of data as a CSV or workbook in Excel, you may need to use a VBA Macro for doing this or to copy the range to clipboard and paste it in a new workbook and then save the workbook as CSV or Workbook. Kutools for Excel augments Excel with Export Range to File utility for Excel users who want to quickly process the following operations:  Click for 60-day full featured free trial!
doc export cell range to file
 
Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 60 days.



Recommended Productivity Tools

Office Tab

gold star1 Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 300 New Features for Excel, Make Excel Much Easy and Powerful:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Screen shot of Kutools for Excel

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    n · 13 days ago
    با سلام : مطلب نحوه تبدیل word به اکسل کمک خیلی زیادی به من کرد خیلی خیلی از مطالب مفیدتان ممنونم
  • To post as a guest, your comment is unpublished.
    Julia · 2 months ago
    Super helpful, thank you!
  • To post as a guest, your comment is unpublished.
    Trish · 8 months ago
    Soooo helpful! :)
  • To post as a guest, your comment is unpublished.
    Linda Willis · 1 years ago
    Thank you SO much! Your directions on turning a Word document into an Excel spreadsheet worked perfectly. You just save me hours of time!
  • To post as a guest, your comment is unpublished.
    anita subedi · 1 years ago
    thankyou so much.....great relif!!