Import Multiple CSV Files from a Folder, and getting multiple query folders

hofston

New Member
Joined
Dec 15, 2017
Messages
4
Hello,

Whenever I click the "double down arrow" next to Content in my query that I just created from a folder that contains CSV files, downloaded from ExcelisFun PowerQuery04, I am getting a new screen titled "Combine Files"; Combine Files screen is asking me for Example File, File origin, Delimiter, and Data Type Detection. When I click "OK", My query now jumps from one to 5. I have a parent Query Folder titled "Transform File from PowerQuery04, I have a Sample Query Folder, etc.

When Mike did this in ExcelisFun, after he clicked the double-down arrow, he didn't get the "Combine Files" screen, and he did not have any Query Folders. I am using the same CSV files that Mike had provided in Youtube.

I am assuming this issue is because I am using a newer version of Excel than Mike was at the time the video was posted.

Any help is appreciated.
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Forum statistics

Threads
1,215,566
Messages
6,125,596
Members
449,238
Latest member
wcbyers

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top