![]() ![]() If not all attributes are shown, click the ‘Load More’ link. To clear the list and just select one or two, clear the ‘Select All’ checkbox at the top of the list, then choose the attributes you want to list. By default the Attributes column likely displays ‘Record’-you can click the double-arrow icon to the right of that column header to show the attribute types you can select from. In the next window, right click on the column header of any column you don’t need, then select Remove. If you want to add or delete columns, click Transform Data.If you’re happy with what you see, click Load and go to Step 8.A preview of the data found is shown in a new window (NOTE: This is NOT all the data, just a sample).Depending on how many files there are, the list could take several seconds (or more) to display. Click Browse and choose the topmost folder containing the files you want to list.On the Data tab, click the drop-down arrow next to Get Data. ![]() In case that video ever gets deleted or moved, here are the basic steps: Details and demo in this 3 minute YouTube video. And any updates to the folders can be updated automatically via Excel if you save your list. It’s quick, clean, and you can specify which data to keep, delete or add before you get your final list. ( Update 28 November 2022: There are some issues with Method 1 that I found while testing it, so for an even quicker and cleaner method, skip to Method 2 below) Method 1 I first wrote about the methods for doing this back in 2008 (!), but today I found another, much simpler way of getting a list of all files in a Windows folder and its subfolders using Excel (any version after 2010, I believe). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |