Import Word Document into Excel | Convert / Transfer Data in Word into Excel Worksheet

Download the featured Word documents here:
www.bluepecantraining.com/imp...
------------------------------------------------------------
Blue Pecan Computer Training Ltd offers on-site or online Excel training for businesses. Training can be delivered at your business premises in the south-east of England or via Teams wherever you are in the world. Visit our training page at www.bluepecan.co.uk
In this video I demonstrate how to transfer data held in a Microsoft Word document into an Excel worksheet. I look at two methods:
The first requires us to save the Word document as a Text file (.txt) and then to use Power Query in Microsoft Excel to import the data.
The second uses a simple copy / paste method. This method works if the data is in a Word table.
------------------------

[@Frisbinator]

Finally found a video that didn't ONLY explain pasting perfectly formatted tables into excel, appreciate it!

[@makeuplily]

I AGREE!

[@SensiRojo20]

This was simple, and also the only video that worked for me. Thanks!

[@cursedpellets44]

Exactly what I needed, explained simply and effectively. Thank you!

[@lamine4483]

I was going to say that. The other keep rambling on things that I didn't need at this moment. So enjoying!

[@makeuplily]

@@lamine4483 Yup I know the feeling....frustrating and just went through that. But thank God for this channel and shared video

[@gammap6114]

Oh you make my life so much easier your help... Really appreciate. Thank you

[@dannylewandowski2822]

Thank you! Amazing walkthroughs.

[@apostolis_23]

Chester thank you so much mate. It worked as a charm! 🙂 Greetings from Greece!

[@Yesterdayis2soon]

Helped so much! Thank you!

[@kekeofgod8997]

This was very helpful. Thanks so much

[@djstar6320]

Thank you. I've had tables before, that's easy. But like in the first part I had data, it just wanted to put everything in the first row. Maddening

[@IvanCortinas_ES]

Excellent tutorial. This case is quite recurrent. Thank you Chester.

[@allspecialtube]

My sincerest appreciation, 🙏 really helpful

[@aninejensen4672]

Thank you for a good video.

[@noreason5309]

Understandable have a great day🙂✌

[@devinamarasinghe7656]

Love you so much

[@hailebeyene3271]

great work

[@kinius37]

Thank you 😊 just what I needed 😇

[@ruthhopeful1405]

Thanks. It saved me a lot of hassle. I did it in google sheets and the "import" is under "file " tab. Thanks

[@buntuscainte4987]

thank you

[@pepomow]

thanks alot

[@EDITZZ-or5jl]

thankyou bro very helpful

[@savetheearth6980]

Great 💐q

[@showell5414]

Thank you!!!

[@rescuediaries]

thank you.

[@makeuplily]

Thank you so much for sharing both methods, you are the man! Also if it is not to much to ask, could you share how to add column headers when converting this same exact process. Let's say in the case that no column headers (Date, Description, Money In, Money out, and Balance) were in the Word Doc. Maybe another video potentially? I am subscribed and notification's are on also. Anxiously waiting on your response. Thank you, your#788 liked viewer

[@michaelb388]

Hi, I have an issue where I am trying to scrape data from the body of an email and I need to organize it into columns in excel. It wouldn't be that much of an issue if I were only doing it a few times every day, but I receive up to 100 support emails a day that I need to organize. I've gone far enough to where I am able to automatically copy and paste the email information into Word and it comes out like this: From: Subject: To: Reply To: First Name: Last Name: Company: Title: Email: Phone: Message: This is how support messages are usually sent to me. Is there a way I can have this all organized into columns?

[@babyreen1978]

I have the same document you have, a bank statement but when I try to follow your steps, it isn't coming of as yours. Mine re arranges its self in columns only. How do go about it please help

[@shamraaj5566]

Can we extract name, phone number, email from word to excel? I have a zipped word file that has 100+ data so it's time consuming to open each file and take Name, phone number and email. Please help.

[@rocket-lf9rm]

I have data in ms word in id card format I want to convert or export that data in excel in row wise is that possible sir

[@Riya-pm5]

did you find any way to do it?

[@jessicalafleur4115]

so how do you separate the items in description... example Direct debit customer--6844 Direct debit customer-1722 Direct debit customer-8865 separate words from numbers

[@azureolivia6678]

Thank you so much. This is very helpful .