When you require to export the search results to a CSV or Google Spreadsheet. You have several options in GAT+. In this post, we will cover all of the different options.
Members flattened (without paths)
When the export is generated each file will display its editors or readers on a separate row. This type of export will not display the file paths.
Owner only path
Sometimes a file can be created by one user but can be sitting in someone else’s folder. That is why it’s important to have this export option. For example bob@companyX.com owns a document but the folder its in is owned by emma@companyX.com.
In the flattened format each path gets its own row, so you might see many rows related with one file.
If you are interested in paths of one particular file I would suggest using the flattened format. You will get a report containing only paths related to this one file.
The unique path format shows all paths related to a file in one row. Each path is separated from other paths by ” | ” vertical bar.
Example: My Drive / Folder_A / Subfolder_A / Documents / | My Drive / Folder X / Subfolder_X / Documents
No path data will be provided in the exported CSV or Google Spreadsheet for any file or folder. This option is provided in situation when the file/folder path is not necessary to display.