Import excel files with a dynamic starting row

This is the 4th post of a series that covers everything about importing all files in a folder into Excel using a tool called Power Query. Click here to see the series. The previous scenario covered how to import all Excel files in a folder getting the data below the 9th row. Therefore, the data on all […]

Import specific cells from Excel files

This is the 5th post of a series that covers everything about importing all files in a folder into Excel using a tool called Power Query. Click here to see the series. In this post, I’ll show you how to import the contents from specific cells of all files in a folder. For example, in the file […]

Import and clean each file from a folder

This is the third post of a series that covers everything about importing all files in a folder into Excel. Click here to see the series. The previous scenario covered how to import all Excel files in a folder, however, for that example we assumed that all files had the right format and were ready to be […]

Analyzing 50 million records in Excel

A common myth I hear very frequently is that you can’t work with more than 1 million records in Excel. Actually, the right myth should be that you can’t use more than 1,048,576 rows, since this is the number of rows on each sheet; but even this one is false. In this post I’ll debunk […]