In this case our Orders table has many products in it, but our Products table has a unique list of products.
We call those other tables “lookup” or “reference” tables as they contain the missing information that we often want to pull into our main data table, allowing us to make better use of Excel’s rich toolsets.
In Excel 2010-2013, download the free Power Query add-in from Microsoft, then use Power Query, From File, From Folder.
In either version, you will be asked to browse to the folder containing the CSV files.
This will take you to an Excel-like grid listing all of the files in the folder and any subfolders. If you click the expand icon (the two-headed arrow) next to the Attributes heading, you can choose to show additional fields, such as file size.
Use the Filter dropdown at the top of the extension column and uncheck any files you don’t want to include, especially all the non-CSV files (such as the file that Windows often adds to a folder). But the amazing icon is shown next to the Content column in Figure 1.