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

Подписаться 107 тыс.

Просмотров 314 тыс.

50% 1

Download the featured Word documents here:
www.bluepecant...
------------------------------------------------------------
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....
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.
------------------------

Опубликовано:

30 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 36

@cursedpellets44 3 года назад

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

@lamine4483 2 года назад

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

@1Billion.1 Месяц назад

You just saved me from doing 1 week manual labour.

@Frisbinator 2 года назад

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

@makeuplily Год назад

I AGREE!

@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

@shamraaj5566 2 года назад

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.

@michaelb388 2 года назад

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?

@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

@rofibhoi9788 21 день назад

HOLY HELL, Thanks a LOT.

@gammap6114 Год назад

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

@IvanCortinas_ES 3 года назад

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

@worldinmotionwithreen Год назад

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

@SensiRojo20 2 года назад

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

@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