From the course: Excel for Sales Professionals

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Import data from many files

Import data from many files

From the course: Excel for Sales Professionals

Start my 1-month free trial

Import data from many files

“

- [Instructor] Now what if you have many files you want to import? So for example, let's say your IT department gave you these three files here to import. Could you do it all at once? Yes, and let's go one step further. What if at the end of a sales cycle, like at the end of the month, you get a new file. Could you drop it in this folder and have Excel automatically update and receive the data for that new file? You sure could. I'll show you how. Let's switch on over to Excel, and we'll go to Data, New Query, From File, and then we'll choose From Folder. And I'm gonna click Browse, and I'm gonna navigate to that chapter two folder and then the folder called monthly sales files, which is inside the chapter two folder. I'll click ok, and then ok again. We get a preview here, and it's not like the other previews we saw earlier. It just shows the file names and the extensions, the dates, etc. But if we click this awesome button down here, we can actually combine the data from all three…

Contents