Combine Multiple CSV Files in Excel with Power Query

Combine monthly CSV exports into one Excel table using Power Query's From Folder connection. See how to select a folder, combine the contents, clean up the result, and refresh the query. Watch the full webinar in Excel & AI Live: https://stringfestdata.gumroad.com/l/... Download the exercise files (ZIP): https://github.com/stringfestdata/exc... Unzip the folder before opening the workbook. In this video: Connect to a folder containing CSV exports Combine files using a sample file Keep track of the source filename Apply cleanup after combining and load the result Chapters: 0:00 Start with consistent CSV files 0:44 Get Data from a folder 1:40 Combine file contents 1:56 Choose a sample file 2:26 Understand the combined query 2:57 Clean up the source filename 3:38 Load and refresh 4:07 Apply cleanup to the combined data Recorded September 2, 2026. The example uses CSV files with consistent schemas. The source data includes a value changed during an earlier demonstration. Do your exports arrive by month, department, location, or customer? What makes combining them difficult? Upcoming live sessions: https://www.eventbrite.com/o/stringfe... George Mount | Stringfest Analytics #Excel #PowerQuery #Automation