What is easiest way to get data from Windows Explorer to Excel

lbeck · 04 Oct 2022

I need to get files from Windows Explorer filesnames into Excel. Cut/paste doesn't work. If I can select all and get the explorer files into a CSV file or some other list as text I can do what I want.

Try3 · 04 Oct 2022

If what you want is to get the paths & filenames into Excel then
- select all the files,
- press the Shift key as you right-click,
- select Copy as path,
- paste into Excel.

The whole drive - folder path - filename - file extension will always get pasted in using this method so there's some tidying up to do if you don't want all of it.

Denis

mngerhold · 05 Oct 2022

One learns something every day - thanks, Denis!

Try3 · 05 Oct 2022

Martin,

One is absolutely delighted to have been in a position to have rendered assistance.

Denis

lbeck · 05 Oct 2022

Try3 said:

If what you want is to get the paths & filenames into Excel then
- select all the files,
- press the Shift key as you right-click,
- select Copy as path,
- paste into Excel.

The whole drive - folder path - filename - file extension will always get pasted in using this method so there's some tidying up to do if you don't want all of it.

Denis

That WORKS!

Thanks so much. Your method will save me lots of time. I have thousands of data in Explorer. Using your method then "Data/text to columns" I can do exactly what I need. I can parse out the data needed.

Paul Black · 05 Oct 2022

Hello @lbeck,

Just for your curiosity, you might also find these useful . . .

> Copy path - Add to Context Menu in Windows 10
> Add Copy Contents to Clipboard to Context Menu in Windows 10

I hope this helps.