Opening Word Document in Excel 2016

Question

I need to open a Word document in Excel to convert to a spreadsheet and I get an error to says the type is not valid and the Wizard does not open.

Answer 1

Hi Elizabeth,

These problems occur when the association between the file and the corresponding application is missing or if the docs didn't convert successfully.

For us to make sure of everything, we suggest that you perform these steps on how to 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.
2. Select a location you want to put and select Plain Text from the drop down list of Save as Type.
3. Click Save, then click OK to close the File Conversion dialog. Then close the Word document.
4. Now open Excel and select Data. Choose From Text. See screenshot:

5. In the popping dialog, select the text file you saved at step 1, and click Import. 6. Check Delimited option in the Text Import Wizard – Step 1 of 3dialog, click Next. 7. 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. 8. You can specify the data format in Step 3 of 3. Click Finish. 9. Select a cell to put the data if you check Existing worksheet. 10. Click OK.

Once done, you can now save the worksheet. Let's see if this helps.

Update us with the results for further assistance.