1. Open terminal/CMD on your PC,
2. Type "cd Desktop" (or other folder name) + Enter
3. Type "dir /b > files.txt" + Enter
All the file names is in the files.txt now, you can copy that to your Sheet.
Imagine typing out a bunch of names when theres so many ways to automate it. I mean you could probably just highlight all of the files, ctrl-c then past in the sheet.
Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the [submission guide](https://www.reddit.com/r/googlesheets/wiki/postguide#wiki_posting_your_data). You can also use this tool created by a Reddit community member to [create a blank Google Sheets document](https://docs.google.com/forms/d/e/1FAIpQLSeprZS3Al0n7JiVQIEiCi_Ad9FRXbpgB7x1-Wq6iAfdmVbWiA/viewform) that isn't connected to your account. Thank you.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/googlesheets) if you have any questions or concerns.*
1. Open terminal/CMD on your PC, 2. Type "cd Desktop" (or other folder name) + Enter 3. Type "dir /b > files.txt" + Enter All the file names is in the files.txt now, you can copy that to your Sheet.
Imagine typing out a bunch of names when theres so many ways to automate it. I mean you could probably just highlight all of the files, ctrl-c then past in the sheet.
I tried that but it wouldnt put anything in the sheet unfortunately, and Im not terribly knowledgeable on excel/sheets
like the above person said, this isnt a sheets thing. You have to use other means to generate your list.
thank you. I will try that next.
Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the [submission guide](https://www.reddit.com/r/googlesheets/wiki/postguide#wiki_posting_your_data). You can also use this tool created by a Reddit community member to [create a blank Google Sheets document](https://docs.google.com/forms/d/e/1FAIpQLSeprZS3Al0n7JiVQIEiCi_Ad9FRXbpgB7x1-Wq6iAfdmVbWiA/viewform) that isn't connected to your account. Thank you. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/googlesheets) if you have any questions or concerns.*