Google Drive app on phone

Drive Audit Export Options

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.

Paths flattened

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.

Unique Paths

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

Without Paths

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.