Tutorial on How to Convert Word Document to Excel

Hello everyone. Welcome to my channel. Today s tutorial will be on converting or changing a word document to an excel spreadsheet. Therefore, basically. What we will be doing here is. We will be moving all the data in the word file to an excel spreadsheet, without copying and pasting information. Before we go on further, please make sure you subscribe to our channel. And, don t forget to click on this bell icon to get notifications on future videos. Now! Let us look at how to do this. So this the document here that I want to convert into an excel file. I want to move all these data into an excel file for a different purpose. Rather than copy pasting. Which may or may not end up moving all data properly. Or it may also be time consuming if there is a large volume of data in the word file. Therefore I will show an easy method to work around this. Before we look at how to work around this. Let me show you whether we can open a word file or document on an excel spreadsheet. In general word files can only be opened on a word program. It cannot be opened on an excel file. Both these programs are completely different from each other. And they do not open other file formats. Let me show you to be certain. I will open a new excel spreadsheet and open a word file. Let me open the word file used in this tutorial. Once we open it. We will be prompted with a little dialog box. This one here says the word file that we just opened, is locked for editing and is only usable for read only purpose. Now that is not helpful. Because I need to be able to make edits on the excel spreadsheet. Anyway. Let us give it a try to see whether it opens. But, though it says it can only be used only for read only purpose. It cannot be opened. We can come to see that shortly. As you can see now. Another dialog box appears even after accepting it as a read only file. This one here says that, this file format is not valid. Therefore cannot be opened on excel. Alright. Now that I have shown you that it cannot be opened on an excel program. We will look at how to work around this, to move data from a word document to an excel spreadsheet. One of the easiest ways is to first convert this word document as a plain text file. Let me do that before we go any further. Go to Save As under the File. And choose Save As. Choose you location to save. Once you are at the Save As Type option. And then click on the save as type. And choose the Plain Text file format. And Click on Save. Before it saves this file as a Plain text file. It will popup another window giving you more options to choose. I wont be making any changes to any options here. Leave it as it is. And check on the Preview area to make sure everything is fine. Once you have checked the Preview of your file, click on Okay. Ok we have now successfully saved our word file to a plain text file. Now I will open a new spreadsheet. Here I will show you how we can open this plain text file into the excel spreadsheet. Once you are on the excel spreadsheet. Let me enlarge it. Go to data. Under data, click on this feature From Text . Navigate to the saved location of your plain text file and import the file. This here is the one that I saved. And I will import it into my excel spreadsheet. Now there are three steps before we import the file into this excel spreadsheet. On the first step it gives you the option to choose what best suits your data on your text file. Whether Delimited or Fixed Width. I will leave it at delimited. Let me check the preview if the data is properly imported without any separations. Yep. Now that I have checked, it all looks to be fine. And before I move to the next step. This here gives you the option to choose on which row you want to start importing the data. If you select 1 here. The data will be imported starting from the row 1 here which is A1. You can choose which row you want to start importing your data according to your needs. And it will import starting into that row. But I will leave it at row 1 for this tutorial. I am not going to do any changes here. Leave it as it is. And my file has no headers. So I will leave that too. And click on Next. This window is step two of the three steps. Since we chose delimiters on our earlier step. It has given up more options to choose the type of separators we want to apply. As I said earlier. I do not need any separators. So I will deselect the Tab selection. And I will click on next. On our third step. It will ask for the format type you want to apply. Its ok to keep it as general. But however. Since we know it is a text file. I will choose the text option. And I want all of it to appear as text format anyway. And I will click on finish. Once the three steps are done. It will open up another little dialog box with a few options. This here gives you the option to choose whether you want to import the data to an existing worksheet or a new worksheet. I will stick to the default because I have a worksheet already opened. This here is the cell in which the data import begins. As we select row 1 earlier on step two. It has chosen the cell from column A and row 1. Now let me click on Okay and see what happens. As you can see all the data from the word document is imported into the excel spreadsheet. Except that the formatting of the headings have changed. I might have to reformat those headings. However. This tutorial was about how to convert a word document to an excel spreadsheet. And we have successfully done that. We have moved all the data from the word file to excel without much changes apart from the formatting. That s all it is for this video. Thanks for watching my video and please don t forget to like my video, comment on it, share this video and subscribe to my channel.

Channel: Faizur Farook

Views: 237,906

Keywords: How to convert a word document to an Excel spreadsheet, Can you convert a text file to Excel, How do I convert Excel to Word without losing formatting, convert word to excel, import word to excel, import data from word to excel, convert data word to excel, how to import data from ms word to ms excel, how to convert word to excel, word to excel converter, word document to excel worksheet, word to excel convert, how to convert excel to word, how to export word to excel

Id: k1LuVUssVGc

Length: 7min 5sec (425 seconds)

Published: Tue Jun 01 2021