วีดีโอ

Works with google spreadsheets too.. Just pay attention " Data -> Split Text to Columns" and then you will have small option in middle/down on the screen ( hard to notice tho ) option how you want to be separated ( default is detected automaticly ) but you can choose "custom" ( last option ) and add sign and it will automaticly do it for you.. Delete columns and there you go. Thank you so much for this video.

Brilliant thank you

Way better than trying to deal with command syntax

Very elegant Matt. Thanks. Instead of Excel you can also paste into Word and then do Control-H, search for the path string and replace with nothing. CHeers

fabulous info. Thanks !!!!!!!

Thanks for “copy as path”. The other option I’ve been using is Alt+D to go into the address bar, then type CMD to open the DOS command window, then type “dir /b >!files.txt”, which puts a full list of files (without path names) into a file called !files.txt.

Thank you sm!

Thank you for this 👌🏾

I came to give this video a thumbs up and saw that I already had. 🤣🤣 Reminds me of that alzheimer's joke where the links are already purple. uh oh.

Genius..... thank you

This helped me a lot. 👍 Thank you.

An easy way to clean file names is to paste the list, then use the 'Find and Replace' function to replace your path with nothing. In seconds, you'll have clean file names.

THANK YOU!

Office Harman Sandhu

8 years later and your video just saved my day. Struggling with a solution fot this a week now! Thank you

Thank you! It is now 2024 and I just learned this. I have been working with PCs since the late 80's. You need to tell Microsoft their hidden features should NOT Be hidden. But I think they are embarrassed they can't do it simply. Fire those developers and tech writers and project managers.

Thank you

found this from copilot AI, VERY USEFUL

I use notepad and it's easy, just delete the path in search and replace all occurences.

Awesome, saved me a ton of time! Thank you so much

Thank you so much. All the other instructions were complicated and I couldn't get the paths right. This one worked like a charm.

Now no need of ALT+SHIFT+right click. Just right click!

Excellent!

you save my life

Thank you.

Simple way: copy the path of the folder, paste in the browser, enter then copy the content on the browser, then paste on excel

Thanks for this video. I noticed that the pasted list was not sorted by file type??

Is there a way to reverse this? Go from column back to text?

Love this one!

Thank you! exactly what i was looking for

Thank you! This really helped.

I appreciate this! I tried for a while using command prompts but could never figure it out. This way worked perfectly for me.

amazing.... thanx for this brilliant info is there any method to copy thumbnails of all files in a folder

Very awesome

Thanks mate, i was searching for this solution for long time. ❤❤❤

great tips - here is a summary to make a list of files in a folder 1. Select all files 2. Alt shift right click copy as path 3. In Excel not google drive - click data, text to columns, be sure delimited is checked and put a backslash \ in “other” box, hit enter twice 4. Use ctl H to find and replace .docx or other file extension with nothing if you don't want the file extensions

Perfect. Although, I copypasted to Textpad and used a regexp to get rid of the path!

SUPER THANK U FOR THIS SIR !!!!!

Great tip Matt, Just some additions Quick tip-1: Instead splitting the data into columns, copy the filepath from the Windows Explorer and use replace in Excel for the list of file paths and simply replace using Ctrl+H (replace) and you will save a little more time sorting the data. Quick tip-2: You may as well use simply Shift + right click on your mouse to access "Copy as path" option. Quick tip-3: you can create a renamer.xls excel file for yourselves with REN Dos script Or can create a DOS script batch file that can change file names as it has been run each time. Scripts are available on internet for better automation. I often rename 100+ files weekly during my research and work Thank you so much

Super Amazing! Thanks for explaining the process. I had a requirement like this just today and Voila!

Thanks! Very helpful. Wished I had searched for it sooner!

JUST USE ALTAP SALAMANDER MUCH FASTER

Thank you! Really needed this, as I had an Excel list of 104 positions, yet only 102 files to cut out detail layouts. So I could either go through the list checking each position to find those two missing numbers or... Worked perfectly!

worthless garbage.

Absolutely brilliant. I don't even know what to say. Thank you.

this is awesssommmeeee, thank you

Exactly what I needed and quickly. Super easy! Thank you!

Make a CTRL+F to find the part of the path and replace it by nothing. you end with the list of files and folders

Legend. Thank you

Thanks! This tip is super helpful ❤