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.

Import vendors to QuickBooks Online using a CSV or Excel file There are a few steps to importing your vendor data into QuickBooks online via CSV or Excel file.

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.