List of filenames from folder and subfolders into Excel

preview_player
Показать описание
Use Power Query to get a list of files in a folder and subfolders with information such as date modified and file size. The list will update if you add or remove files.
---------------------------------------------------------------------------------
#exceltips #exceltutorials

Microsoft Office 365, 2016, Office Insider, Version 2012
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
  1. Karina Adcock
  2. quickly copy list of files into excel
  3. copy list of files to excel
  4. copy list of files
  5. copy file names from folder to excel
  6. get a list of file names
Рекомендации по теме
List of filenames 0:03:20

List of filenames from folder and subfolders into Excel

Quickly creating a 0:03:44

Quickly creating a list of files in a folder

Copy list of 0:03:16

Copy list of filenames from folder into Excel (Windows)

Export list of 0:00:24

Export list of files, folders including subfolders to a txt file from command line

List of filenames 0:04:22

List of filenames from folder into Excel

How to Get 0:08:13

How to Get the List of File Names in a Folder in Excel (without VBA)

List of filenames 0:06:43

List of filenames from folder into Excel (Windows)

How To List 0:05:36

How To List All File Names from A Folder into Excel Using Formula

#141 Swift Programming 0:10:06

#141 Swift Programming - Contents of Directory Using FileManager

How to Get 0:03:15

How to Get a List of all Files in a Folder and Subfolders into Excel

How to get 0:03:26

How to get the list of filenames in a folder at one click

How To Get 0:03:38

How To Get A List Of File Names From A Folder And All Subfolders

List all the 0:06:00

List all the files in a folder and subfolders with Power Query

Export list of 0:07:04

Export list of file names from Windows Explorer folder tree to Microsoft Excel

How To List 0:05:05

How To List File Names In A Folder & Subfolder And Link In Excel

15 - Get 0:07:14

15 - Get a List of File Names from a Folder in Excel Using Power Query

List of file 0:01:19

List of file names from folders and sub folders using VBA

How to List 0:01:40

How to List all Filenames of a Folder and Create Hyperlinks to Them in Excel

Create the list 0:08:03

Create the list of Files and Sub-folders in a Folder in Excel (Macro to list File Names)

Instantly Create Folders 0:01:15

Instantly Create Folders Directly from List in Excel | Excel Tricks

How to Get 0:08:20

How to Get a List of Filenames in Folder Using Command Prompt

Quickly List All 0:01:38

Quickly List All Files And Sub-Directories Of A Folder Or Directory In Excel

CMD - list 0:01:12

CMD - list all files and/or folders names into a text file

How to Get 0:04:37

How to Get the List of File Names in a Folder (image, audio or video files) with path & details ...

Комментарии
Автор

This was an amazing recording. Clear and to the point. Thank you.

denisereynolds
Автор

Took me forever to find this tutorial. Thank you!

plor
Автор

Wow. I never know you can do something like this. Very clear instruction.

A-broken-clay-jar
Автор

Thank you for your excellent instructions. I was unfamiliar with Power Query and this completely resolved my issue. Cheers!

denisebreard
Автор

Thank you so much. It's straightforward and well-structured. You save me a day!

hanaict
Автор

Thank you for this. Excellent tutorial!

Ngovandan
Автор

Why don't I have the "Get Data from File/Folder" option in excel 2016?

Hybe
Автор

what is the unit of file size which is shown in power query?

ArifBudimanPage
Автор

Is there any way that the folder name/path can be changed whenever needed? Like a drop down box or data entry cell to introduce other folder's name/path ( of course one folder at a time?)

moesadr