How to Convert Word to Excel but Keep Formatting (2 Easy Methods)

This article illustrates how you can convert Word documents to Excel spreadsheets but keep the same formatting. Suppose you need to format or sort your data that is in a Word document. Obviously, Excel is the better choice to do that. Fortunately, you don’t have to type the data again in the new Excel file. You can just convert the Word document to an Excel spreadsheet while keeping the formatting. The following picture highlights the purpose of this article. Have a quick look through it to learn how to do that easily.

Convert Word to Excel with Same Formatting: 2 Easy Ways

Imagine you have the following Word document. Now you want to convert it to an Excel spreadsheet. Then follow the methods below.

1. Convert Word to Excel with Copy-Paste

You can simply copy the data from the Word document and paste it onto the Excel sheet. Follow the steps below to do that.

📌 Steps

• First, go to the Word file. Then, press CTRL+A to select the entire document. You can also select a particular range only if required.
• After that, press CTRL+C to copy the data as shown below.

• Next, go to the Excel spreadsheet. Then, select the upper-left cell of the range where you want to get the data.
• Now, press CTRL+V to paste the data. Alternatively, you can right-click on that cell. Then, select Keep Source Formatting (K) from the Paste Options.
• After that, you will get the following result.

Read More: How to Copy from Word to Excel into Multiple Cells

2. Convert Word to Excel with VBA

You can do the same with Excel VBA. Follow the steps below to do that.

📌 Steps

• First, add a new worksheet. Then, save the workbook as a macro-enabled workbook.
• Next, press ALT+F11 to open the VBA window.
• Then, select Insert >> Module to create a new module as shown in the picture below.

• After that, copy the following code using the copy button.

Sub WordToExcelWithFormatting()
Dim Document, Word As Object
Dim File As Variant
Dim PG, Range
Application.ScreenUpdating = False
File = Application.GetOpenFilename _ 
("Word file(*.doc;*.docx) ,*.doc;*.docx", , "ExcelDemy.Com - Please Select")
If File = False Then Exit Sub
Set Word = CreateObject("Word.Application")
Set Document = Word.Documents.Open(Filename:=File, ReadOnly:=True)
Document.Activate
PG = Document.Paragraphs.Count
Set Range = Document.Range(Start:=Document.Paragraphs(1).Range.Start, _ 
End:=Document.Paragraphs(PG).Range.End)
Range.Select
On Error Resume Next
Word.Selection.Copy
ActiveSheet.Range("B2").Select
ActiveSheet.Paste
Document.Close
Word.Quit (wdDoNotSaveChanges)
Application.ScreenUpdating = True
End Sub

• Then, paste the copied code onto the module window as shown below.

• Now, press F5 to run the code. You can also do that from the Run tab.
• After that, you will be asked to select the Word file that you want to convert.
• Now, browse to the location of your desired Word document. Then, select the file and click Open.

• Finally, you will get a similar result as in the earlier method.

🔎 How Does the Code Work?

Read More: How to Convert Word Table to Excel Spreadsheet

Things to Remember

• You can also save the Word file as a PDF. Then, use your PDF editor to convert it to an Excel Spreadsheet.
• Don’t forget to save the workbook as a .xlsm Otherwise, you will lose the code.

Download Practice Workbook

You can download the practice workbook from the download button below.

Conclusion

Now, you know how to convert a Word document to an Excel spreadsheet and to keep the formatting as well. Please let us know if this article has helped you to solve your problem. You can also use the comment section below for further queries or suggestions. Stay with us and keep learning.

Related Articles

• How to Convert Word to Excel with Columns
• Convert Word Picture to Excel Table
• How to Import Data from Word to Excel
• How to Link Word Document to Excel

<< Go Back to Import Word to Excel | Importing Data in Excel | Learn Excel