Excel Power Trick - How to Combine a Folder of CSV Files

Download the data set here

Excels Power Query ( or Get and Transform Data in Excel 2016) will allow you get data from almost any source and then transform that data into a usable format

One of the features available is Combine Binary's. This will allow you combine data contained within a folder.

In this video you will learn how to use Combine binary's in Excel Power Query (get and transform data) to connect to a folder of CSV files and then transform the data to a usable format.

Once you save your workbook and query, when you get a new CSV file all you have to do is drop it in the folder and update your spreadsheet, saving you a massive amount of time in the long run

Would love to hear your feedback....comment below

Sign up to our newsletter

Watch more Power BI videos

Watch more Excel Videos

Join the online Excel and PowerBI community

DOWNLOAD THE FREE APP 'Power BI - The Ultimate Orientation'

[GroundPounder]

JUST what I was looking for. Thank-You. Is it possible to set this up so instead of seperate Store2, Store1, Store3 being displayed, for each week, there are only One row for each Sotre, and all Teddy Bears are totaled, all Jigsaws are totaled etc? Say Just the Units and Sales columns totaled? Or will this require a pivot table to accomplish this? I can do the Pivot table, but was wondering if this can be aggregated upon the import. If it's covered in a pay video, that's fine, just let me know which one please. Regardless, Well presented.