Question: how to transfer data from word to excel automatically?
Answer: Open a blank worksheet in Excel.
Go to Data | Import External Data | Import Data. ... 
Click the text file you want to import, then click Import.
Select the Delimited option (Figure C) and then click Next.