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.
Download Practice Workbook
You can download the practice workbook from here.
3 Easy Methods to Import Data from Word to Excel
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.
Read More: How to Copy from Word to Excel into Multiple Cells (3 Ways)
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.
Read More: How to Convert Word Table to Excel Spreadsheet (6 Methods)
- How to Convert Word Picture to Excel Table
- Transfer Data from One Excel Worksheet to Another Automatically
- How to Convert Word to Excel but Keep Formatting (2 Easy Methods)
- Import Data from Excel into Word Automatically Using VBA (2 Ways)
- How to Import Text File to Excel (4 Easy Ways)
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.
Read More: Importing Data into Excel (3 Suitable Ways)
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 Excel 365 so the interface may vary with different versions.
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. For any excel-related problems, you can visit our website Exceldemy for solutions.
- How to Convert Word to Excel with Columns (2 Methods)
- Import Data into Excel from Another Excel File (2 Ways)
- How to Import Data from Text File into Excel (3 Methods)
- Import Data from Secure Website to Excel (With Quick Steps)
- How to Extract Data from Excel to Word (4 Ways)
- Pull Data From Another Sheet Based on Criteria in Excel
Great post. You helped me a lot.
Can you please explain me how can I import the first line of the text (title) from every single Word page (I have about 250 pages) into Excel (separate sheets for every single title)?
Thanks for your comment. We are very pleased to know that you find this article useful for you. As far as I know, Excel doesn’t have any built-in feature which can resolve your problem.
I recommend that you can set the first line of every MS Word page as a heading. This feature will help you see the text in the Navigation Panel of MS Word. As a result, you don’t need to scroll down all pages. You will just click on each text, then select the text and manually copy that into your Excel workbook.