tecosystems

Copying Windows Directory Information Into a Spreadsheet?

Share via Twitter Share via Facebook Share via Linkedin Share via Reddit

Enjoying Mashup Camp a great deal and will have more on it soon, but just got a semi-urgent technical question from a friend that I don’t have an immediate answer to. It seems absurdly simple, but for some reason I can think of how to do it.

The problem is this: said friend needs to take the contents of several Windows network directories (don’t ask why – I’ve already been down that route) – with extended file attributes included, like “Owner” – and get it from the directory into an Excel spreadsheet. In short, all they need to do is cut and paste a bunch of file names along with the file owner into a spreadsheet. Not particularly difficult, one would think.

Normally, I’d just get into the directory on the command line and do a “dir,” and cut and paste from a terminal window – but the directory is a network share and only accessible over a VPN, and this apparently prevents such access. Or at least I don’t know how to do that on Windows. At this point, the only way to cut and paste the file names is by accessing the network share on Firefox (IE turns into Windows Explorer, rather than a standard browser window) – but there’s no way to get the owner information in that fashion.

There’s got to be an easy way to do this: any quick, easy thoughts? I’m sure I’m not thinking of something, so any and all help appreciated.