Excel 365 - Get & Transform data (Folder) - listing path not pulling in files

[Lawro]

Hi - First time poster!

Could you please help?

I want to set up a query that pulls in the file data from a given folder. These are the steps I followed:

Data > Get Data > From file > From folder - Select folder - Open > Load

I've done this before without issue however this time the end results is as seen on the attached picture

There is a CSV file in the folder that I wish to update periodically and was expecting it to pull in the data from the file. However, despite repeating the steps and hoping for a different outcome, it keeps just list the folder path!

Any help appreciated

 

[Chihiro]

You need to Open. Then in next pane, instead of "Load" choose either "Combine" or "Transform Data".

 

[Lawro]

Thanks Chihiro. Using the combine option did the trick. NB. Transform data didn't work and produced the same result as previously.

 

[Chihiro]

For Transform. You need to click on the Content column to expand the content.

This is more useful when you don't want to combine all files within given folder. Or you want to apply different transformation steps to files in given folder. Since you can use initial query as reference, or apply filter steps etc.