From the course: Excel: Power Query (Get & Transform)

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Query data from another Excel file

Query data from another Excel file - Microsoft Excel Tutorial

From the course: Excel: Power Query (Get & Transform)

Start my 1-month free trial Buy for my team

Query data from another Excel file

“

It is possible to import data from another file. In this situation, we have survey data from a magicians conference, specifically the mentalism sessions. We've got survey results from Tuesday, Wednesday, Saturday. We've got averages being calculated. There's a lot happening. And let's say you and I are concerned about the food and venue results. Well, there's a lot to clean up. Like column C is empty. We've got these averages. We don't want those. We can calculate those when we need them. The main thing is to get a lot of stuff out of our way so that we can do our analysis. Now, what if we go straight forward and right-click, Get Data from Table/Range? I don't have all of my data. All right. Cancel this out. Here's what I am going to do. I'm going to go to File, blank workbook. All right. I don't like gridlines. I want to minimize this and then close the survey results and then go back to Book 1, Data, Get Data, From File, From Excel Workbook. Import survey data. Double-click that…

Contents