How to Load Data in Power Query WITHOUT Converting to a Table!

Hey everyone! In today’s video, I’m sharing a quick tip on how to load data into Power Query without going through the hassle of converting it into a table first. I know, it’s one of those little things that can save you a ton of time and effort, especially if you're working with lots of data.

I’ll walk you through the steps, show you a simple transformation, and then load the data back into Excel. It's super easy and a great way to streamline your workflow!

If you found this helpful, don’t forget to hit the LIKE button, SUBSCRIBE for more Excel tips, and turn on notifications so you don’t miss any new videos! Thanks for watching!

[neocyte]

Wow! Great tip. This also works to "Add to Data Model" to create a Power Pivot Table, which normally requires a Table to created first.

[wfbane]

Thanks. I have found that this approach also allows me to load into Power Query data that is in a pivot table.