Hey everyone! In this Article I’ll show you how to convert a word document with data into an excel worksheet. Our goal is to take a document with text laid out in paragraphs and turning it into a field of cells. This is not so difficult because both Word and Excel have certain feature sets that can help you transition your document into a spreadsheet...
I’ve already opened a word document with data. Specifically, it’s a statement from paypal account. I want to convert this into an excel worksheet, so I’ll then add totals and other statistical values.
The first step is to save this file as a plain text file. Click on File , Save as, Browse, select a location to save it and in save as type I’m going to select Plain Text. Here it is. Save. In this File Conversion Window, I’ll leave the default settings, so click Okay. Great!
Close the word file and open a new excel file. Click inside on one of those cells and from Data menu click this icon From Text. A new window appears. In the popping dialog, select the text file you saved in the previous step and click import.
The text import wizard appears. This specific document that I exported from Paypal contains Tab as a Delimiter. So I’ll choose Delimited as file type. But in other case you could select the Fixed Width and then the wizard will automatically create column breaks. Okay let’s get back.
if you do not want the data split by delimiters, do not check any option. Choose Delimited and go to next step. We will check tab as a delimiter and as you can see our data is separated. Click next. If you want, you can specify the data format for each column. I’ll leave it as it is and go to final step. Select where you want to put the data. I’ll leave the default option which is A1 cell.
Okay and there you see, the data from word have transferred to our excel worksheet. If you have any questions, please leave a comment.
Thank you very much and waiting for your questions.
If you want to learn how to make amazing Dynamic Excel Charts, Dashboards and Pivot Charts in a few weeks, take our Udemy Course for only $25 !! (original price: $195 - 87% OFF!)