Importing files with variable number of columns

Monsignor

Board Regular
Joined
May 30, 2011
Messages
162
I noticed something odd today and I don't know if this is new or if I just never encountered this before.


  • I have 3 files in a folder and imported from the folder into Power Query.
  • 2 of the files have 2 columns, 1 file has 3 columns.
  • Power Query imported just the first 2 columns from each file.

I'm used to Power Query sometimes importing too many columns (several empty columns) rather than too few. Is there a way to tell Power Query to import all columns?
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
maybe:
Edit not Combine
expand Content
expand Data (choose columns you want to load)
select all columns and remove duplicates
then remove top/bottom rows with null (if necessary)
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

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