Скачать или смотреть Merge Excel/ CSV files in a folder into a single Excel file

00:00 Import multiple Excel/ CSV files into Excel (merge from a folder)
00:20 Also how to auto update new files in the folder into Excel
00:40 Import data from all the files in a folder to Excel
01:15 List of the files in the folder to import into Excel
01:30 Import the multiple csv files into PowerQuery editor
01:50 Tell PowerQuery to combine all the files into a single file (actually an append)
02:35 Files contents pasted underneath each other with a column for the Source Name
03:00 Load the combined CSV files back into Excel
03:25 Auto refresh of combined file in Excel for new CSV's in the folder
04:20 PowerQuery re-runs the steps to import ALL CSV files in the folder (even the new ones)
04:40 Remove CSV's from the folder, PowerQuery automatically removes them from combined file

How to import multiple CSV or Excel files in a folder into a single Excel file WITHOUT using VBA macros and in such a way that it is possible to automatically refresh the import of the files in the folder when files are added or removed. Although it is often called merging files in the folder, it is actually an append files in folder, as manually you would open each file, copy the data and paste it below the previous one in Excel.

Main options:
Same workbook-    • Excel PowerQuery table in same workbook  
Text file e.g. csv-    • Convert CSV to Excel automatically (PowerQ...  
Other Excel workbooks-    • Auto import data from other Excel workbook...  
Databases e.g. Access-    • Import data INTO Excel FROM database (Powe...  
From a folder with csv's, excel workbooks and more- (this video)    • Merge Excel/ CSV files in a folder into a ...