Skip to content

Frequently Asked Questions

How can I handle cells with newline (CRLF or LF) or tab characters?

You can use the editor pane for that. Keep in mind the Let Editor Pane Consume Navigation Keystrokes settings is enabled by default. If you turn it off, you can still insert newlines with shift+enter and tabs with alt+tab.


How do I filter out all rows with empty cells in a column?

Filter the column using filter phrase !. The ! means "NOT" and there's emptiness after it, so it means "NOT empty". You can also filter out non-empty rows by simply leaving the filter phrase blank.

If it appears to leave some rows with empty cells, those cells may have spaces. You can select them and check the cell lengths in the status bar. The Trim Selected Cell(s) command can remove them.


I filtered a file. How do I save the result to a new file?

Use the Save Visible Data As command.


How do I get Convert Date/Time Filter to work?

You'll need to enter a format for both the current date/file format and the new one (it does not guess the current format because of the possiblity of mixing up months, days, and years). If you have a custom format, be sure to select the Enter Custom Format option first.

Also, be sure the "From" format matches the current date/time format. If not, it won't make any changes.


How do I sort dates and times?

It depends on how your date/time strings are formatted. If they're in ISO 8601, Unix Epoch, or Excel formats, you can sort them like you would anything else. Likewise if they're in a format with the following order from left to right: year, month (numbers only, not names), day, hour, minute, AM/PM, second, millisecond.

If they're in some other format, you can do the following:

  1. Duplicate the column (ctrl+alt+c).
  2. Convert the new column to ISO 8601, Unix Epoch, or Excel format using the Convert Date/Time Format command.
  3. Sort the new column.
  4. Delete the column (ctrl+shift+L).
  1. Duplicate the column (cmd+alt+c).
  2. Convert the new column to ISO 8601, Unix Epoch, or Excel format using the Convert Date/Time Format command.
  3. Sort the new column.
  4. Delete the column (cmd+shift+L).


Does Modern CSV keep my data private?

Yes. File contents or metadata are kept on your local machine and never sent to anybody. Modern CSV will occasionally send us information about your OS, license, and version number.