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.