It is particularly beneficial to use data-entry forms when your data range or table has many columns. A standard data-entry form in Excel looks similar to the screenshot below. (To follow along, ...

Launch Excel and click the "Data" ribbon tab. Select "From Text." A "Text Import Wizard – Step 1 of 3" dialog box will appear. Browse for the Word form you want to import and click on it.