Documentation

Contents

1. Calling Commands
2. Standard Editing Tools
3. Selecting Cells
4. Editing Cells
5. Moving Data
6. Deleting Data
7. Duplicating Data
8. Inserting Rows and Columns
9. Finding and Replacing Data
10. Headers
11. Sorting Data
12. Filtering Data
13. Miscellaneous Data Manipulation
14. Read-Only Mode
15. Go To
16. Setting Preferences
17. Setting Delimiters
18. Showing or Hiding UI Features
19. Changing the Theme
20. Contacting Us



Calling Commands

There are four ways to call commands:

1. Command Launcher
2. Menu Bar
3. Keyboard Shortcuts
4. Right-click


1. Command Launcher

Command Launcher

ctrl+l or ctrl+shift+p (cmd+l or cmd+shift+p for Mac)
The command launcher allows you to quickly call commands by just typing. It uses fuzzy search, so your typing doesn't even have to be that accurate.


Menu Bar

The menu bar at the top of the window contains almost all commands.


3. Keyboard Shortcuts

Most commands you'll use on a regular basis have keyboard shortcuts. You can find out what these are by perusing the command launcher or the menu bar. You can also change them with the Edit Keyboard Shortcuts command.


4. Right-click

right-click Menu

Right-clicking on the table will bring up some helpful commands.



Standard Editing Tools

Modern CSV does the standard copy, cut, and paste commands (ctrl+c, ctrl+x, and ctrl+v for Windows and Linux, cmd+c, cmd+x, and cmd+v for Mac). It also has undo and redo for most commands (ctrl+z and ctrl+y for Windows and Linux, cmd+z and cmd+y for Mac).



Selecting Cells


Selecting a single cell

Click on a cell.
Use the arrow keys to move the selection to a cell.
alt+i, alt+j, alt+k, and alt+l- Use these to spare the 200 ms it takes to move your wrist to the arrow keys.
ctrl+g (cmd+g for Mac) or Go To Cell. It'll tell you what to do from there.


Selecting multiple cells

left-click and drag.
ctrl+left-click (ctrl+left-click for Mac) on a cell that's not already selected.
shift+arrow to add one cell to the selection.
ctrl+shift+arrow (cmd+shift+arrow for Mac) to select over to the next block edge.
ctrl+shift+r (cmd+shift+r for Mac) to select the whole row.
ctrl+shift+c (cmd+shift+c for Mac) to select the whole column.
ctrl+shift+t or ctrl+a (cmd+shift+t or cmd+a for Mac) to select the whole table.
left-click on the row or column label.
left-click on the top left corner button between the row and column labels.

Once you select multiple cells, you can move them around just like single cells (i.e. arrows or alt+[i|j|k|l]). Most commands work on multiple cells.


Nomenclature

Multi-cell

The orange cell is the main selected cell or main cell. The yellow cells are the secondary selected cells.



Editing Cells

Multi-cell Editing

There are numerous ways to edit cells:

1. Overwrite currently selected cells.
2. Append to selected cell.
3. Fill selected cells with series.
4. Append to multiple cells.

Additionally, you can either edit directly in the cell or use the editor box.


Overwrite currently selected cells

Overwrite Currently Selected Cells

Just start typing. This works with multiple cells selected.


Append to selected cell

Append to Selected Cell

ctrl+e (cmd+e for Mac)or Edit Selected Cell
This only works when one cell is selected.


Fill selected cells with series

Fill Selected Cells with Series

ctrl+n (cmd+n for Mac) or Fill Selected Cells with Series
This is useful for, say, incrementing numbers. Futher instructions will show up with the command.


Append to multiple cells

Append to Multiple Cells

Append Cell Contents
If you have multiple cells selected, it will ask you whether you want to add the same text to each cell or add a series of differing values.


The Editor Box

Editor Box

ctrl+k,ctrl+e (cmd+k,cmd+e for Mac) With the editor box, you can see more clearly the cell contents. Unlike the direct cell editor, you can also insert new lines with ctrl+enter and tab characters with ctrl+tab.



Moving Data

The alt key is used for data moving operations. You can move individual cells, entire rows and columns, and even the entire table.


Individual cells

Moving Individual Cells

alt+arrow or Move Cell Contents [Up|Down|Left|Right]


Rows or columns

Moving Rows or Columns

alt+shift+arrow or Move [Row(s)|Column(s)] [Up|Down|Left|Right]



Deleting Data

You can do the following:

1. Clear cell contents
2. Remove rows and columns
3. Remove duplicate rows and columns
4. Remove empty rows and columns


Clear cell contents

Clearing Cell Contents

delete or backspace or Clear Cell Contents


Remove rows and columns

Removing Rows and Columns

Rows: ctrl+shift+k (cmd+shift+k for Mac) or Remove Row(s).
Columns: ctrl+shift+l (cmd+shift+l for Mac) or Remove Column(s).
To clear a row or cell of its contents without removing it, select it and use delete or backspace.


Remove empty rows and columns

Removing Empty Rows and Columns

Rows: Remove Empty Rows
Columns: Remove Empty Columns



Duplicating Data

ctrl+alt (cmd+alt for Mac) duplicates data, whether it be individual cells or entire rows and columns.


Duplicate individual cells

Duplicating Cells

ctrl+alt+arrows (cmd+alt+arrows for Mac) or Duplicate Selected Cell Contents [Up|Down|Left|Right]


Duplicate rows and columns

Duplicating Rows and Columns

Rows: ctrl+alt+r (cmd+alt+r for Mac) or Duplicate Row(s)
Columns: ctrl+alt+c (cmd+alt+c for Mac) or Duplicate Column(s)



Inserting Rows and Columns

Inserting Rows and Columns

Rows: alt+r or Insert Row(s)
Columns: alt+c or Insert Column(s)



Finding and Replacing Data

Finding and Replacing Data

Find window: ctrl+f (cmd+f for Mac) or Find
Replace window: ctrl+h (cmd+h for Mac) or Replace
esc closes both of them.

The option buttons are at the top. Here the are from left to right.

Button Option Keyboard Shortcut
Case Sensitive Case Sensitive alt+a
Regular Expressions Regular Expressions alt+/
Match Whole Word Match Whole Word alt+w
Match Whole Cell Match Whole alt+e
Match Only Match Only alt+s
Highlight Matches Highlight Matches alt+h


Headers

Modern CSV allows you to define header rows and/or columns for your data. It's typical to have the first row of a CSV be the data labels and the rest be the actual data. For that reason, there is one header row by default. However, you can set as many header rows and columns as you want.

Headers are used for the following purposes:

1. Bold and highlight them so they stand out (or not).
2. Freeze them so they're always visible (or not).
3. Separate them from the data so they're not effected by sort and filter operations.


Setting number of header rows or columns

Setting Number of Header Rows and Columns

Set Number of Header [Rows|Columns] (Menu, Command Launcher)
Set Headers to Selected Cell (Menu, Command Launcher or right-click menu)
Set Header [Rows|Columns] to Selected [Row|Column] (Menu, Command Launcher or right-click menu)

In the menu, they're found under View->Headers.

These commands will change it only for the table you're currently working on. To change it for all tables, currently opened or new, change it in the Settings file under Number of Header [Rows|Columns].


Bolding or unbolding header rows and columns

Bolding or Unbolding Header Rows and Columns

Toggle Bold Header [Rows|Columns]


Freezing or unfreezing header rows and columns

Freezing or Unfreezing Header Rows and Columns

Toggle Freeze Header Rows and Columns
Toggle Freeze Header [Rows|Columns]



Sorting Data

Data can be sorted either by columns or rows, either ascending or descending. It sorts based on the data in the main selected row or column. The headers won't be sorted.

Sorting Columns

Double-click on the row or column labels.
Sort Selected [Row|Column]- Ascending
Sort Selected [Row|Column]- Descending

ctrl+z (cmd+z for Mac) undoes a sorting operation.



Filtering Data

Data can be filtered, either by rows or columns. That means it only keeps columns or rows that pass the filter criteria. The headers won't be filtered.

Filtering is subject to the undo and redo commands (ctrl+z and ctrl+y for Windows and Linux, cmd+z and cmd+y for Mac). However, it will not change the underlying data when you save the file. The reason is CSVs have no mechanism for saving filter data.


Adding filters

Adding Filters

Add Filter
Filter Selected [Row|Column]
Filter Selected [Row|Column] with Selected Cell Contents


View and edit filters

View and Edit Filters

View/Edit Filter(s)


Remove filters

Remove Filters

Remove Individual Filter(s)
The Remove All Filters command removes all filters.



Miscellaneous Data Manipulation


Transposition

You can transpose individual ranges or entire tables.


Transpose Selection

ctrl+t (cmd+t for Mac) or Transpose Selected Cells


Transpose Table

Tranpose Table


Case

Case

UPPER CASE: ctrl+k,ctrl+u (ctrl+u for Mac) or Upper Case
lower case: ctrl+k,ctrl+l (ctrl+l for Mac) or Lower Case
Title Case: Title Case
UpperCamelCase: Upper Camel Case
lowerCamelCase: Lower Camel Case
UPPER_UNDERSCORE_CASE: Upper Underscore Case
lower_underscore_case: Lower Underscore Case


Joining (Concatenating) Cells

Joining (Concatenating) Cells

Join Selected Cells Horizontally
Join Selected Cells Vertically


Splitting Cells

Splitting Cells

Split Selected Cells Horizontally
Split Selected Cells Vertically


Trimming Cells

You can trim the spaces before and after the non-space characters with Trim Selected Cell(s).



Read-Only Mode

Read-Only Mode

We recognize that some files are very large and you may want to simply view them without having to wait minutes or use up all of your computer's memory. With that in mind, we implemented a read-only mode for files. It loads more quickly than edit mode (which already is pretty quick) and uses very little memory.

In a nutshell, read-only mode doesn't load the file into memory. Rather, it indexes the file so it can quickly find each cell. Any time it needs to read row X, column Y, it references the indexing data and reads it directly from the file on disk.

Note that Modern CSV can handle up to two billion rows or columns (OK, technically it's 2147483647. It's a 32-bit thing.).

There's probably no benefit to opening small files in read-only mode unless you want to protect them from accidental editing. At the same time, you probably want at least the option of opening exceptionally large files in read-only mode. For that reason, the Minimum File Size to Ask About Opening in Read-Only Mode (MB) setting exists* . By default, it's set to 100 MB. That means it will automatically open any file less than 100 MB in edit mode. For larger files, it will ask whether you want to open in edit or read-only mode.

At any time, you can change an already open file back and forth between edit and read-only modes with the Toggle Read-only command. Note that it will close the file and reload it from scratch in its new mode.

If you have any suggestions for a shorter name that's equally descriptive, please let us know. Perhaps Minimum File Size for Read-Only Mode Query (MB)?



Go To

You can navigate to various places with just a few keystrokes.


Go To Cells

Go To Cells

ctrl+g (cmd+g for Mac)
More specific instructions pop up with the command itself.


Go To File

Go To File

ctrl+p or ctrl+t (cmd+p or cmd+t for Mac)
Only files that are already open or that are in a folder that's open will show up in the list. To open a file not on the list, you can either open its folder or use ctrl+o (cmd+o for Mac).



Setting Preferences

There are two preference files- settings and keyboard shortcuts. You can open them using the Edit Settings and Edit Keyboard Shortcuts commands.

Make your changes in the User Value or User Shortcut column. Once you save the file, the changes will immediately apply.

Further instructions are in the files themselves. You can delete those rows and move other rows and columns around all you want. In the Settings file, changes made under Type and Default Value will make no difference. They exist for informative purposes only. The same holds true for Default Shortcut in the Shortcuts file. You can even delete these columns with no consequence.

You must not change the name of any Setting (Settings file) or Command (Shortcuts file). You must also keep the headers there with at least columns for Setting and User Value (Settings file) or Command and User Shortcut (Shortcuts file).



Setting Delimiters

Modern CSV opens all .csv files with a comma delimiter, all .tsv and .tab files with a tab delimiter, all .txt files with no delimiter (all the data is in the first column), and all other files with a comma delimiter. You can change delimiters once a file is open with the Set Delimiter command. It will reload the file with the new delimiter.



Showing or Hiding UI Features

Showing/Hiding UI Features

Side bar: ctrl+k,ctrl+b (cmd+k,cmd+b for Mac)
Tab bar: ctrl+k,ctrl+t (cmd+k,cmd+t for Mac)
Menu bar: ctrl+k,ctrl+m (command doesn't exist for Mac)
Editor box: ctrl+k,ctrl+e (cmd+k,cmd+e for Mac)



Changing the Theme

Changing the Theme

Set Theme
Modern CSV currently has a light theme and a dark theme.



Contacting Us

Please contact us if you find a bug, have a question, want to request a new feature, feel like doing us a solid and taking a survey, or for another other reason. All of these options are under the Contact Us menu or can be invoked with the following commands:

Report a Bug
Request a Feature
Take a Survey
General Feedback/Questions