Skip to main content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

FIU Digital Project Guidelines and Help Materials

The internal standard operating procedures for FIU Libraries' digital collections

How To

**These instructions can help you to create a list of files, along with their file structure, in an excel.  **

For Windows:

This process requires Window Powershell which is available on Windows 10. It is available on other versions of windows but you may need to install it.

Here is an article on Finding and Installing Windows Powershell on your computer.

Step 1: Open Command Prompt:

Step 2: Type powershell then press enter.

Step 3: Get the file path name and insert it between the quotation marks in the command below. Then enter this command in the command prompt window:

get-childitem "[file_path]" -rec | where {!$_.PSIsContainer} |select-object FullName | export-csv -notypeinformation -delimiter '|' -path file.csv

Step 4: Press Enter.

Step 5: The exported CSV will be listed directly after the command. For this example, my file was exported to c:\Users\jkrefft>

Here is an example of the csv output. You can use the Text to Column function in Excel using the delimeter "\" to separate the heirarchy into columns.