Exporting results to a file

Discussion related to "Everything" 1.5 Alpha.
Post Reply
void
Developer
Posts: 15441
Joined: Fri Oct 16, 2009 11:31 pm

Exporting results to a file

Post by void »

The current selection or all results can be exported to a file.
All values from all columns can be exported.

Progress is shown in the status bar on the right when exporting.



Gathering Information
Exporting to a file
Export selection only
Export to a CSV file
Export to a EFU file
Export to a HTML file
Export to a JSON file
Export to a TXT file (tab delimited)
Export to a TXT file (filenames only)
Save filename instead of Name + Path when exporting as CSV
Remove the trailing path separator for folders
Export with a UTF-8 Byte Order Mark (BOM)
Save with human readable filetimes when exporting as EFU
Double quote filenames when exporting as TXT
Export from the command line
Advanced



Gathering Information
Only gathered information is exported.
To gather all information before exporting:
  • In Everything 1.5, from the Edit menu, click Select All (Ctrl + A).
  • From the File menu, click Read Extended Information (Ctrl + Shift + E).
  • Gathering progress is shown in the status bar on the right.


Exporting to a file

To export to a file:
  • In Everything 1.5, from the File menu, click Export.
    -or-
  • Press Ctrl + S


Export Selection Only

To export the selection only:
  • In Everything 1.5, from the File menu, click Export.
  • Check Export selection only.
All results are exported if this option is unchecked.



Export to a CSV file

All visible columns are exported.

CSV files can be imported in Excel and other programs.

To export results to a CSV file:
  • In Everything 1.5, from the File menu, click Export.
  • Change Save as type to: CSV Comma Separated Values (*.csv)
  • Choose a File name and click Save.
See also: Save the full path and name instead of name and path separately.



Export to a EFU file

EFU files are Everything file lists.
They contain the filename and basic file information, such as size, date modified and attributes for each file/folder.

File lists can be indexed or opened in Everything.

The full filename is exported.
All other visible columns are exported.

To export results to a EFU file:
  • In Everything 1.5, from the File menu, click Export.
  • Change Save as type to: EFU Everything File List (*.efu)
  • Choose a File name and click Save.
See also: Saving the filetime as readable ISO8601



Export to a HTML file

HTML files can be opened in your webbrowser.

All visible columns are exported.

To export results to a HTML file:
  • In Everything 1.5, from the File menu, click Export.
  • Change Save as type to: HTML Web Page (*.html)
  • Choose a File name and click Save.


Export to a JSON file

JSON files are JavaScript Object Notation files.
They can be easily parsed by external programs.

The full filename is exported.
All other visible columns are exported.

To export results to a JSON file:
  • In Everything 1.5, from the File menu, click Export.
  • Change Save as type to: JSON JavaScript Object Notation (*.json)
  • Choose a File name and click Save.


Export to a TXT file (tab delimited)

Also known as Tab Separated Values (TSV)

All visible columns are exported.

TXT files can be imported in Excel.

To export results to a TXT file:
  • In Everything 1.5, from the File menu, click Export.
  • Change Save as type to: TXT Tab Separated Values (*.txt)
  • Choose a File name and click Save.


Export to a TXT file (filenames only)

Only the full path and name is exported.
A filename is stored on each line.

To export results to a TXT file:
  • In Everything 1.5, from the File menu, click Export.
  • Change Save as type to: TXT Text Files (*.txt)
  • Choose a File name and click Save.
See also: Double quote filenames when exporting as TXT



Save filename instead of Name + Path when exporting as CSV

To save the full path and name when exporting as CSV:
  • In Everything 1.5, from the Tools menu, click Options.
  • Click the Advanced tab on the left.
  • To the right of Show settings containing, search for:
    csv
  • Select csv_type.
  • Set the value to: Filename
  • Click OK.


Remove the trailing path separator for folders

EFU, CSV and TXT export folders with a trailing path separator.

To remove the trailing path separator:
  • In Everything 1.5, from the Tools menu, click Options.
  • Click the Advanced tab on the left.
  • To the right of Show settings containing, search for:
    append
  • Select one of the following settings:
    • csv_folder_append_path_separator
    • efu_folder_append_path_separator
    • txt_folder_append_path_separator
  • Set the value to: false
  • Click OK.


Export with a UTF-8 Byte Order Mark (BOM)

Everything uses UTF-8 encoding when exporting.

Including a UTF-8 BOM can make it easier for external text viewers to open your exported file.

To include a UTF-8 Byte Order Mark (BOM) at the start of the exported file.
  • In Everything 1.5, from the Tools menu, click Options.
  • Click the Advanced tab on the left.
  • To the right of Show settings containing, search for:
    bom
  • Select utf8_bom
  • Set the value to: true
  • Click OK.


Save with human readable filetimes when exporting as EFU

To save filetimes in ISO8601 when exporting as EFU:
  • In Everything 1.5, from the Tools menu, click Options.
  • Click the Advanced tab on the left.
  • To the right of Show settings containing, search for:
    efu
  • Select efu_filetime
  • Set the value to: ISO8601 (with timezone)
  • Click OK.
Loading EFU files with ISO8601 filetimes is slightly slower.


Double quote filenames when exporting as TXT

To wrap filenames when exporting as TXT files with double quotes ("):
  • In Everything 1.5, from the Tools menu, click Options.
  • Click the Advanced tab on the left.
  • To the right of Show settings containing, search for:
    txt
  • Select txt_double_quote
  • Set the value to: true
  • Click OK.


Export from the command line

ES can be used to export results to a file from the command line.

Example usage:

Code: Select all

es.exe "my search" -export-csv out.csv
es.exe "my search" -export-efu out.efu
es.exe "my search" -export-txt out.txt
es.exe "my search" -export-m3u out.m3u
es.exe "my search" -export-m3u8 out.m3u8
es.exe "my search" > out.txt


Advanced

-create-file-list
/copy from a bookmark.
Copy as CSV/TSV commands under Tools -> Options -> Keyboard.
copy_as_csv_header
copy_as_tsv_header
Post Reply