How to Import Word Into Excel

By Michael Jones

To import a Word document into Excel, you have to open up Excel and import the data through the file commands. When importing a Word file into Excel, the most important thing to remember is how you want to split your text. Once in Excel, your information will be placed into columns and rows. You can make sure your document gets imported into Excel just the way you want it by following a few simple steps.

Things You'll Need

  • Microsoft Excel
  • Microsoft Word documents

Step 1

Save the Word document as a plain text file. There should be a character or tab between each field. This will ensure that your document is split into the proper rows and columns when you import it to Excel. If you have created a table in Word, convert it to text, and then save it as plain text.

Step 2

Open Excel.

Step 3

Select "Data," then "Get External Data" and then "Import Text File." Choose "Delimited" as the data type and use whatever character you used to separate the fields in your Word document as your delimiter.