Skip to main content

Export Options & Data Manipulation in Excel v2.5

Brandon Langley
Updated

Export Your Results

You can export your results, whether they come from drilling down the file tree or running a search. From the Export menu, you can also copy paths or file names directly to your clipboard. Let’s go through each option.

⚠️ IMPORTANT! We recommend limiting your exports to 100,000 line items—if you try to export more than that:

  • Diskover will still attempt the export, but you’ll see a warning message.

  • The process may take several minutes or even hours, depending on how many items are included.

  • Remember that Excel has a maximum of 1 million rows.

If you experience issues exporting a large dataset, please have your System Administrator open a support ticket for further guidance.

export.png

CALLOUT

DESCRIPTION

A

Export menu: This is where all export options are located.

B

Export Files: Use these options only if your results include files, otherwise the export will be empty.

✏️ Selected items are ignored — these options always export full file lists.

  • Exports all the metadata attached to the files.

  • Your choice of CSV or JSON formats.

  • Files this page: Exports only the files on the current page of results. 

  • Files all pages: Export files from all pages of results.

Your exported file will go to your browser’s Downloads folder—the file name will include the export timestamp, e.g.: diskover_export_file_250303_104938.csv

C

Export Directories: Use these options only if your results include directories, otherwise the export will be empty.

✏️ Selected items are ignored — these options always export full file lists.

  • Exports all the metadata attached to the directories.

  • Your choice of CSV or JSON formats.

  • Directories this page: Exports only the directories on the current page of results. 

  • Directories all pages: Export directories from all pages of results.

Your exported file will go to your browser’s Downloads folder—the file name will include the export timestamp, e.g.: diskover_export_file_250303_104938.csv

D

Copy all paths this page: Copies all file and directory paths on the current page to your clipboard—selected items are not considered.

E

Copy all file names this page: Copies only the file names (not full paths) from the current page to your clipboard—selected items are not considered.

F

Copy selected paths this page: Copies the full paths of all selected files or directories in I to your clipboard.

G

Copy selected file names this page: Copies only the file names—not the full paths—of all selected items in I to your clipboard.

H

Items per page and number of pages: Your items-per-page setting can affect some export options, like “this page”.

I

Selection: May affect some of the export options as explained above, learn more about selecting items →

Data Manipulation in Excel

🍿 Watch Quick Tips → Recursive Search, Export, and Excel Manipulation

✏️ The instructions and screenshots in this section may vary depending on your operating system and Excel version.

Export Data in CSV Format

Refer to the export section above to learn how to export to a CSV format.

Open CSV File with Excel

Once you export your data to CSV, you can open it directly in Excel for sorting and filtering. All metadata appears in separate columns, giving you full flexibility to work with the data.

✏️ You can use Sort and Filter together in Excel to isolate exactly what you need.

Excel → Data → Sort

image-20251119-125459.png

CALLOUT

DESCRIPTION

A

Click Data in the top menu.

B

Click Sort—this opens Excel’s sorting panel.

C

For example, select parent_path to sort by path/directories:

  • You can add multiple levels of sort using the + button (for example: sort by size, then by file name).

  • You can also access the Data → Sort function from Excel’s top drop-down menu.

  • Refer to Excel’s Help menu for more detailed instructions.

Excel → Data → Filter (When Exporting Files)

image-20251119-125530.png

CALLOUT

DESCRIPTION

A

Click Data in the top menu.

B

Click Filter.

C

Click on the down-arrow in any column—this opens Excel’s filter panel.

  • Select what you want to isolate and click Apply Filter.

  • You can also access the Data → Filter function from Excel’s top drop-down menu.

  • Refer to Excel’s Help menu for more detailed instructions.

Excel → Data → Filter (When Exporting Directories)

When you export directories, you’ll see additional columns such as dir_depth.

image-20251119-125544.png

CALLOUT

DESCRIPTION

A

From the Excel application menu, select Data.

B

Click on the Filter icon.

C

In this example, we clicked the down arrow from the dir_depth column, which opened a window with multiple options:

  • Select the depth of sub-directories you want to isolate in your results and click Apply Filter.

  • You can also access the Data → Filter function from Excel’s top drop-down menu.

  • Refer to Excel’s Help menu for more detailed instructions.

Related articles

Comments

0 comments

Please sign in to leave a comment.

Powered by Zendesk