There are a couple of different ways to do this. My favorite is to use an
Excel add-in called ASAP Utilities. One of the commands will populate a
spreadsheet with the file name, path, folder, file size, etc and even make
them a hyperlink. It is so simple plus the add-in has *scads* of
can't-live-without commands!