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.
------------------------