Unfortunately, Microsoft Excel doesn't include a one-step method for importing a file list from Windows Explorer, but Windows 7 offers an easy workaround.

In this article, we will see how you can import data from Excel to Google Sheets and vice versa automatically. This is a two-way integration between Google Sheets and Microsoft Excel.

However, using workbooks in Excel, one would need to save each page of the workbook as a .csv file, then import it, which could get rather cumbersome when dealing with many large workbooks, as I am.