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

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

HomeOther ContentImport Word Document into Excel | Convert / Transfer Data in Word into Excel Worksheet
ChannelPublish DateThumbnail & View CountActions
Channel AvatarPublish Date not found Thumbnail
0 Views
If you have found this content useful and want to show your appreciation, please use this link to buy me a beer .
https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ
Thank you!

Download the featured Word documents here:
https://www.bluepecantraining.com/import-word-document-into-excel-convert-transfer-data-in-word-into-excel-worksheet/

————————————————————
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 https://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.
————————

Please take the opportunity to connect and share this video with your friends and family if you find it useful.