How to Import a Word Document Into Excel?

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Import a Word document into Microsoft Excel.

Importing a Microsoft Word document into Microsoft Excel is often useful if you want to create a spreadsheet out of a list or form you've already made, such as an address book. Fortunately, since Word and Excel are both Microsoft Office programs, they work together well. You just need to make sure the Word document is saved properly, and then use Excel's Text Import Wizard to complete the conversion.

Advertisement

Step 1

Open a Word document you want to import.

Video of the Day

Step 2

Click the "Microsoft Office Button." Click "Word Options."

Step 3

Click the "Advanced" tab. Under "Preserve Fidelity when Sharing this Document, click "Save Data as Delimited Text File." This feature will allow Excel to read the file you are going to import. Click "OK."

Advertisement

Step 4

Click the "Microsoft Office Button." Choose "Save as." Under "Save as Type." Select "Plain Text." This will save the file as a .txt file. A file conversion window will appear. Click "OK."

Step 5

Open Microsoft Excel.

Advertisement

Step 6

Click the "Data" tab. In the "Get External Data," click "From Text."

Advertisement

Step 7

Select the file you just saved in step 4. Click "Open." The Text Import Wizard will appear.

Advertisement

Step 8

Select "Delimited" under "Original Data Type." Click "Next."

Step 9

Select the delimiter you want to use. For instance, check "Comma" instead of "Tab" to see how it affects the conversion. Click "Next." Click "Finish."

Step 10

Click in the first cell (A1) in Excel. Click "OK" to import the data.

Video of the Day

Advertisement

Advertisement

references