I have been trying to find a video or anything about this topic for over a year bro a year! I believe this is the only thing on the whole internet that shows you how to do it. It should be preserved!
Dude! This is EXACTLY what I was looking for! As a writer, I've been wondering how to do this for years. I have so many files that I didn't know how to keep track of them. This is wonderful. Thank you so much for posting.
Awesome ! Instant subscription for Michael ! There is a bunch of supposedly "perfect" mini seminars about this procedure but all failed. Happy i came across your channel.
Thank you so much! I did a week's work in just 10 minutes!!! I had to put 2 years' PO's into a spreadsheet. Can you imagine how I would have struggled?
I've been using search and replace, but your keyboard shortcuts will save me time and make my end product more accurate! I'm checking this 6 yrs from original and will try on Windows 11 and MS Office 365 to see if it's still current. I've saved and will thank you later!
This was so clear, thank you and useful. On some of your videos you have a link to a written set of instructions to accompany the video and that would be truly helpful. Thank you.
Wow, amazing and neat! Was searching for a way to export a list of folder names, but came upon this gem. Definitely would use this way of organizing in the future. Thank you!
HOLE LEE SH*T, I'm stupid, it's okay, I've known this for some time, but I did it, thank you so much! I thought I had to take every individual PDF title and insert manually into an excel sector - omg it worked! Thank you, some really intelligent sounding Indian guy made a vid so far over my head, I was consigned to transfer all the names manually!
Developing a systematic protocol for labeling files in a consistent fashion is key to making this sort of list manipulation easy. Example: C:\Folder\genre\Last name\first name\project name\city\state\zip code\milage\ etc. etc. You can use dashes or underscores instead of back slash, but you get the point. As long as you keep the file label consistent this is massively useful.
Hi Michael - for the hyperlinks, they would work if the path file copied is on your own PC. Let us say your assistant prepares the excel list on a common server, the hyperlinks would be specific to the assistant's file paths on his or her PC. Is there any way to make the hyperlinks universal or have relative links such that they work on anyone clicking on the link?
Good question, and yes it is possible to set the hyperlinks up as "relative paths" so long as the spreadsheet is in the "parent folder" containing the library of files. If a full path down to a drive letter (e.g. "C:\") is specified then Excel will open the document at that full path, but if there is no full path all the way back to a drive letter then Excel will follow the path, starting from the location of the Excel spreadsheet the links are in. So you want to truncate all paths to only show the address relative the the folder containing the Excel spreadsheet. To do this, go to the column in your spreadsheet containing the paths, and do a "find and replace with nothing" for the portion of the paths (this portion should be common to all of the paths in the list) that matches the path to the "parent" folder that also contains the Excel spreadsheet. Then the links should all work no matter whose computer they are opened on, and even if the files are saved in Dropbox or some other cloud environment. I do this all the time when sharing libraries with other people.
Great, but does not work if you have mixed file types, not only pdfs, in the folders...
Search for just a period, that will bring up all items in the folder and its subfolders.
I am shook...all I have ever previously found was how to do this through DIR commands. This is so much simpler. Thank you!
Christy K same here. Lol
I have been trying to find a video or anything about this topic for over a year bro a year! I believe this is the only thing on the whole internet that shows you how to do it. It should be preserved!
I VERY rarely comment on anything, but this seriously just saved me days and days of work. Thank you so much!
This is the simple and elegant solution I've been searching for for over 3 years. Thank you!!
You just EASILY saved me a MINIMUM of 4 - 5 hrs of work. Thank you for posting this great video!
I searched a whole pile of instructions to do this. Probably tried 6 or 7. Yours is the first one that actually worked. Nice job.
Shift+Right Click gives Copy as Path...... Simply Superb, Thanks a Lot Michael Dew
"Copy as path" saved me big time here. Thanks very much.
The first two minutes of your video explained exactly what I was trying to do. Thank you for posting.
Dude! This is EXACTLY what I was looking for! As a writer, I've been wondering how to do this for years. I have so many files that I didn't know how to keep track of them. This is wonderful. Thank you so much for posting.
This is one of the greatest videos i have ever seen. I was wondering if this could be done and you have done it. Well done that man.
God bless you Michael. Excellent and so simple. I have no idea how come some users chose a thumbs down for this excellent video clip.
teaches so much excel possibilities in a single video. thanks!
OMG thank you. I can't even tell you how much time this just saved me, but we're talking HOURS, at least.
saves me time, EVERYTIME i need it!!! I will remember it one day, but dont use it often enough
Awesome ! Instant subscription for Michael ! There is a bunch of supposedly "perfect" mini seminars about this procedure but all failed. Happy i came across your channel.
It helped me a lot instead of doing it separately and will consume more time and main thing is Hyper Link, it is superb. Thank you Dear Michael.
Thank you so much! I did a week's work in just 10 minutes!!! I had to put 2 years' PO's into a spreadsheet. Can you imagine how I would have struggled?
Thank you for this tutorial. I didn't have "copy as path" but read a comment from another person on how to do it. Very helpful.
How do u get it??
You deserve a medal just for the 0:00-2:00 part. Thanks!
Thank you. The select all and shift key with "copy as path" worked for me.
I've been using search and replace, but your keyboard shortcuts will save me time and make my end product more accurate! I'm checking this 6 yrs from original and will try on Windows 11 and MS Office 365 to see if it's still current. I've saved and will thank you later!
You have solved a problem I've been working on for a while. Thank you SO much!!
This was not the video i was looking for. But the video I needed !
I am very glad that people like you exist. Thank you!
Thanks!!! Saved me about 5 hours of tedious work!!!
This was so clear, thank you and useful. On some of your videos you have a link to a written set of instructions to accompany the video and that would be truly helpful. Thank you.
Huge amount of time saved. Thank you.
Excellent tutorial... Saved me hours of work.....
Finally! I even downloaded a software to do that, and it got stucked after the first use. Thanks a lot.
Excellent!! Wondered how to do this for years. Thank you!
Thanks. This helped me out from individually copy pasting the names of 710 items lol.
Nice explanation. There are a number of ways to do this, and you managed to do it very efficiently. Thanks for your contribution!
This is such a big brain Excel move, thank you so much.
Thank u Michael.... It has saved my time like anything. I was looking for it from many days. This will help me in Mail merge
fab, easy way to copy broad list of files.
You went a bit further to and split sorted etc.BRAVO
WOW. Best video ever. Saved me like a weeks work
This helped soooooo much. You my guy are Awesome!!!
This link helped tremendously - saving me hours - thank you very much JMG
Thank you! This is the best & simplest solution! Saved me hours of work
This is EXACTLY what I was looking for! Thank you so much, Michael! from your new subscriber.👍👍
Thanks, found what I needed in 1:20. Much appreciated.
This saved me so much time. Thanks for posting.
That was brilliant! Thanks for posting! You just saved me hours of work by this little trick!
Wow, amazing and neat! Was searching for a way to export a list of folder names, but came upon this gem. Definitely would use this way of organizing in the future. Thank you!
Wow, you are genius. Thank you so much for sharing this. Extremely helpful!
Brilliant. Works very well for what I needed . Many thanks
Thank you so much, saved me hours of time
YOU JUST SAVED ME SOOOOOOOO much time!!! Thank You!!!
ME TOO
Thank you very much. Was able to set up my video files for easy access.
This saved me the hassle of programming it. Thank you!!!
HOLE LEE SH*T, I'm stupid, it's okay, I've known this for some time, but I did it, thank you so much! I thought I had to take every individual PDF title and insert manually into an excel sector - omg it worked! Thank you, some really intelligent sounding Indian guy made a vid so far over my head, I was consigned to transfer all the names manually!
Great video. Now I will try to get all that done automatically every I add a new file/folder to update that excel sheet automatically.
Thanks Michael. I have been using dos and a .bat file; and freaked out my replacement. This is a whole lot easier! She Thanks You!
This video is my new hero! Thank you!
Super helpful. I learned a few new tricks.
Hi dear trillions of thanks it solved my biggest problem
even I was having multiple *.pdf in the Folder
Thanks Michael this was very useful for me.
I am trying to sort out 10,000 music tracks - this has been very useful
Well then, this is still relevant in 2020 it seems xD; Kudos for the video!
I cant explain the help from this video it made frustrating work easy,thank u Dew
Michael Dew, you are AWESOME!!!
Thank you for this video!!
This is very help full for maintaining files, Thank you for sharing
Very helpful video and exactly what I was looking for.
Perfect. Exactly what I was looking for, thank you very much!
YOU JUST SAVED MY LIFE Thank You!!!
Super Helpful!!! This was exactly what I was trying to do! Thank you!
Exactly what I was looking for, and more. Thanks.
Excellent video. Very helpful!
This worked like a charm. Thanks so much!
Perfectly explained tutorial. Just great!
thank you super trick, video it to long but in one minute you told the secret SHIFT COPY LOVE YOU
Great application example. Thank you!
Outstanding video tutorial. Thank you
Thank you! So concise and simple- it helped a ton!
BINGO! thank you very much - excellent tutorial and saved me many many hours!
What a very helpful trick it is...
Thanks for it.
Thank you very much .... This video make my job easy
Developing a systematic protocol for labeling files in a consistent fashion is key to making this sort of list manipulation easy. Example: C:\Folder\genre\Last name\first name\project name\city\state\zip code\milage\ etc. etc. You can use dashes or underscores instead of back slash, but you get the point. As long as you keep the file label consistent this is massively useful.
This video helps me alot!!!!Thank you!
Great explanation! Many thanks
Thank you. Exactly what I needed! This will save me a ton of time.
Exactly what I needed and more that I hadn't even thought I needed
it was really helpful. appreciate that.
Thanks. Saved lot of time
Saved me hours. Thank you!
This is what I need! Thanks a lot!
this is so helpful! I learned a new thing today! Thanks :)
This was extremely helpful. Thank you.
Excellent job. Thank you!
You, sir, are a bloody genius.
It's an easy and fastest method of copying files. Thank you
Thanks, this is so much more easy than the difficult way of bla bla
Hi Michael - for the hyperlinks, they would work if the path file copied is on your own PC. Let us say your assistant prepares the excel list on a common server, the hyperlinks would be specific to the assistant's file paths on his or her PC. Is there any way to make the hyperlinks universal or have relative links such that they work on anyone clicking on the link?
Good question, and yes it is possible to set the hyperlinks up as "relative paths" so long as the spreadsheet is in the "parent folder" containing the library of files. If a full path down to a drive letter (e.g. "C:\") is specified then Excel will open the document at that full path, but if there is no full path all the way back to a drive letter then Excel will follow the path, starting from the location of the Excel spreadsheet the links are in. So you want to truncate all paths to only show the address relative the the folder containing the Excel spreadsheet. To do this, go to the column in your spreadsheet containing the paths, and do a "find and replace with nothing" for the portion of the paths (this portion should be common to all of the paths in the list) that matches the path to the "parent" folder that also contains the Excel spreadsheet. Then the links should all work no matter whose computer they are opened on, and even if the files are saved in Dropbox or some other cloud environment. I do this all the time when sharing libraries with other people.
Hi,
Thank you so much for this. I want to check, is there a way to copy the date modified as well? Unfortunately my documents don’t have dates on it
See link in the description to other video.
thanks a lot, you're a gem
Thank you so much..!! It works so nice.
Excellent! Thank you. Very clear.