When you have similar data in different Excel files, say, split by the year, eventually you'll need to create a chart, a Pivot table, or some sort of summary report with it.
Whether or not you are familiar with the Excel consolidate option, its power is included and enhanced in the add-in.
When a new CSV file arrived, those records had to be deleted and replaced in the workbook.
Columns in the grid include file name, date accessed, date modified, date created, and folder path. When you click the icon with two down arrows, Excel will load all of the records from all of the CSV files in the grid.
If you use this technique to load 200 CSV files into the grid, you might find that the header row appears 200 times in the file. First, choose the Transform tab and click Use First Row As Headers.
A new feature hidden in Excel 2016 (and available for download for Excel 2010-2013) makes this process painless.
If you have Excel 2016, use Data, New Query, From File, From Folder.