Instead, try the direct export method shown below: If you have Excel 2016 version or newer, you may not need to export the folder’s structure to a separate file before importing it to Excel.
Microsoft excel 2016 file location bar how to#
How to Export Folder Structure to Excel Directly Click on “Existing Worksheet” and select the spreadsheet cell to put your data.Select the preferred data format in the third step and click on “Finish.”.
In the Text Import Wizard’s window first step, select the “Delimited” option and click on “Next.”.Select the “.csv” file containing your folder’s structure and click on “Import.”.Launch Excel and open a new or existing spreadsheet.Once you have the file, follow the steps below to import it to Excel: Wait for PowerShell to generate a “.csv” format file containing the folder’s structure.Replace the “d:\demo” with your folder name. Paste the following command into the PowerShell window and hit the “Enter” key: “Get-ChildItem -Recurse ‘d:\demo’ | Select-Object FullName, name | Export-Csv -path d:\list.csv -noTypeInfo”.Select “Windows PowerShell” from the menu.Use the “Windows + X” keyboard shortcut to open a quick access menu.If you need to save the folder’s structure in the “.csv” format rather than “.doc,” you can do that using Windows PowerShell: How to Export Folder Structure to Excel in Windows as a “.CSV” File