Often while working with Excel, we need to import data from different sources. These sources may include Word files which is another commonly used software for storing data or making tables. So for convenience, often we need to import the Word file data into excel. In this article, we will learn how to import data from Word to Excel.
Import Data from Word to Excel: 3 Easy Methods
There are several methods through which we can import data from Word to Excel. The most common one is the copy-paste method, which is widely used. The other method is using the default ‘From Text’ option. All of these methods are described in the proper steps below.
1. Import Only One Cell
This is the most common method that we use ]to import data from Word to Excel. For this method, let’s say we have Word data like the below image.
So here we can simply copy these data from the Word file and then paste them to our expected cell in Excel. Let’s say we want to paste in cell B4. So we will select the B4 cell and right-click to get the paste button. Or we can simply press Ctrl+V to paste the values.
In this way, we will copy-paste the entire data set and customize it to complete the excel worksheet like the below image.
2. Import Data for Multiple Cells
We can import the entire dataset if they are in a table or sorted as a table in Word. Excel will automatically sort them as different column data and we will get our expected data. The steps with proper illustrations are below.
- First, we need to sort the data in the Word file or keep the data in the structure. So here, we will keep the data in a table or table-like structure like the below image.
- Second, select the entire table or table-like structured data in the Word file. Right-click and select copy or just press Ctrl+C to copy all the data at once.
- Third, select the cell where we want to start pasting our data. In our case the cell is B4.
- At last, right click on the selected cell and click on Paste. Or you can just press Ctrl+V to do the same.
3. Using the From Text/CSV Option
When we are importing a very large amount of data, making a table-like structure or making a table is very inefficient and may consume a lot more memory than usual. So for importing a large amount of data, this excel provided method is the most reliable.
- Firstly we need to save the Word file as a text file. So we will go to the Save As section of the Word file and save it as a .txt We can do the same by accessing the file properties as well.
- Secondly, we will go to the Data tab in the Ribbon and go to the Get & Transform section.
- Thirdly we will select the From Text/CSV option on the top left side. We can also find the option in the Get Data and From Files options.
- Next, a selection box will appear. Select the file by finding its path.
- Then selecting the file will trigger a window naming the text file’s name. In this window, we can see the preview of our table. Here we can also edit our fields and even delete them by choosing the Transform Data option.
- After that, we will click on the Load option at the bottom. This will immediately open a new worksheet named the text file’s name.
- Finally, edit the worksheet to get the desired table look.
Things to Remember
- If your data is too large to be in one cell of Excel, try merging multiple cells or increasing cell size. We can also enable Text Wrap to keep things within one cell.
- The entire demonstration was done with Microsoft 365 so the interface may vary with different versions.
Download Practice Workbook
You can download the practice workbook from here.
This is how we transform data from Word to Excel. Hope this article will help you. If you’re still having trouble with any of these methods, let us know in the comments. Our team is ready to answer all of your questions.
Import Word to Excel: Knowledge Hub
- Convert Word to Excel with Columns
- Convert Word Picture to Excel Table
- Convert Word to Excel but Keep Formatting
- Link Word Document to Excel