How to Copy a List of Files in a Windows Folder to an Excel Sheet

preview_player
Показать описание
How to List Files Name from Windows Folder to an Excel Sheet?

Method 1:
=======================================
Steps:
1. Open folder and Select Range
2. Press Shift+ Right Click (Mouse) then Click "Copy as path"
3. Open an excel workbook and paste
4. for Extract file names only Tab-Text to columns-Delimited-uncheck Tab, check Other and type \ in the box and press next - Finish
5. Will Generate a full list of file names for selected range of folder.

Method 1:
=======================================
Steps:(For Up to Windows 8)
1. Go to the folder
2. Press Shift+ Right Click (Mouse) then Click "Open Command Window here"

Steps:(For Windows 10)
1. In Windows 10 Shift+ Right Click (Mouse) will not give you the option of “Open Command Window here”
2. Go to Search bar and type cmd to open command prompt
3. It will open C: drive by default and if your folder in other drive then for change directory type cd/d D:Live Demo
5. Now you can copy and paste to Excel sheet.

*Note:- Angle Bracket or Greater than Symbol is not allowed to write in
description box, Please type Angle Bracket symbol wherever I
mentioned (Angle Bracket).

Thank you for watching the video! Please share and subscribe.

=======================================
=======================================

See more stream line solutions.

Reach me through direct email

Time Code

1. Introduction- 0:00
2. Method 1 for All Version of Windows- 0:11
3. Method 2 PART 1 For Up to Windows 8- 1:20
4. Method 2 PART 2 for Windows 10- 3:56
Рекомендации по теме