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
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
There are four ways to call commands:
1. Command Launcher
2. Menu Bar
3. Keyboard Shortcuts
1. Command Launcher
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.
2. 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.
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+v for Windows and Linux,
cmd+v for Mac). It also has undo and redo for most commands (
ctrl+y for Windows and Linux,
cmd+y for Mac).
Selecting a single cell
Click on a cell.
Use the arrow keys to move the selection to a cell.
alt+l- Use these to spare the 200 ms it takes to move your wrist to the arrow keys.
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 for Mac) on a cell that's not already selected.
shift+arrow to add one cell to the selection.
cmd+shift+arrow for Mac) to select over to the next block edge.
cmd+shift+r for Mac) to select the whole row.
cmd+shift+c for Mac) to select the whole column.
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.
The orange cell is the
main selected cell or
main cell. The yellow cells are the
secondary selected cells.
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
Just start typing. This works with multiple cells selected.
Append to selected cell
cmd+e for Mac)or
Edit Selected Cell
This only works when one cell is selected.
Fill selected cells with series
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 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
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
alt key is used for data moving operations. You can move individual cells, entire rows and columns, and even the entire table.
Move Cell Contents [Up|Down|Left|Right]
Rows or columns
Move [Row(s)|Column(s)] [Up|Down|Left|Right]
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
Clear Cell Contents
Remove rows and columns
cmd+shift+k for Mac) or
cmd+shift+l for Mac) or
To clear a row or cell of its contents without removing it, select it and use
Remove empty rows and columns
Remove Empty Rows
Remove Empty Columns
cmd+alt for Mac) duplicates data, whether it be individual cells or entire rows and columns.
Duplicate individual cells
cmd+alt+arrows for Mac) or
Duplicate Selected Cell Contents [Up|Down|Left|Right]
Duplicate rows and columns
cmd+alt+r for Mac) or
cmd+alt+c for Mac) or
Inserting Rows and Columns
Finding and Replacing Data
cmd+f for Mac) or
cmd+h for Mac) or
esc closes both of them.
The option buttons are at the top. Here the are from left to right.
|Match Whole Word|
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
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
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
Toggle Bold Header [Rows|Columns]
Freezing or unfreezing header rows and columns
Toggle Freeze Header Rows and Columns
Toggle Freeze Header [Rows|Columns]
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.
Double-click on the row or column labels.
Sort Selected [Row|Column]- Ascending
Sort Selected [Row|Column]- Descending
cmd+z for Mac) undoes a sorting operation.
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+y for Windows and Linux,
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.
Filter Selected [Row|Column]
Filter Selected [Row|Column] with Selected Cell Contents
View and edit filters
Remove Individual Filter(s)
Remove All Filters command removes all filters.
Miscellaneous Data Manipulation
You can transpose individual ranges or entire tables.
cmd+t for Mac) or
Transpose Selected Cells
ctrl+u for Mac) or
ctrl+l for Mac) or
Upper Camel Case
Lower Camel Case
Upper Underscore Case
Lower Underscore Case
Joining (Concatenating) Cells
Join Selected Cells Horizontally
Join Selected Cells Vertically
Split Selected Cells Horizontally
Split Selected Cells Vertically
You can trim the spaces before and after the non-space characters with
Trim Selected Cell(s).
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)?
You can navigate to various places with just a few keystrokes.
Go To Cells
cmd+g for Mac)
More specific instructions pop up with the command itself.
Go To File
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
cmd+o for Mac).
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
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
User Value (Settings file) or
User Shortcut (Shortcuts file).
Modern CSV opens all
.csv files with a comma delimiter, all
.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
cmd+k,cmd+b for Mac)
cmd+k,cmd+t for Mac)
ctrl+k,ctrl+m (command doesn't exist for Mac)
cmd+k,cmd+e for Mac)
Changing the Theme
Modern CSV currently has a light theme and a dark theme.
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