The window
The menu bar and the tabs at the top, the file in the middle, the status bar at the bottom, and the command palette for everything else.
Trusty CSV looks like a code editor because it is one: a text editor that knows where the columns of a CSV file are. What you see is the file’s own text, every character of it, drawn so that it reads like a table.

Starting
With no file open, the window shows where to begin: a new empty file, a file from your computer (CSV, TSV, Excel or JSON), the files you opened recently, and four samples to try things on, among them a list of cities of the world and a semicolon-separated file in European format. You can also drop files from your computer anywhere on the window.
The New File button, the + after the last tab, starts an empty file; so does a double click on the empty part of the tab strip. See Opening files for everything that can be opened.
The menu bar
File, Edit, Selection, View, Table, Rows, Columns, Cells, Go and Help hold every command of the app, with its shortcut beside it. Alt+F⌥F, Alt+E⌥E, Alt+S⌥S, Alt+V⌥V, Alt+T⌥T, Alt+R⌥R, Alt+C⌥C (Columns), Alt+G⌥G and Alt+H⌥H open them from the keyboard, and F10 moves to the menu bar; then the arrow keys move between menus and items, and Esc goes back to the file.
Four menus change the data, each named after what it changes. Table is for the table as a whole: it starts with the Quality Check, and has how the file is read. Rows removes, splits and moves rows. Columns has everything about columns, sorting and filtering by one included. Cells changes what is written in the cells: spaces, capitals, numbers and dates. See How data operations work.
A right click in the file opens a shorter menu with what is most useful where you clicked: cut, copy and paste, Select Column, expanding the column if its values are long, and the occurrences of the selection.
Links in cells
When you right-click a cell with a web address in it (https://…, http://… or www.…), the menu starts with Open Link to and the site it goes to, Open Link to example.com; it opens in your browser, in a new tab. With an email link (mailto:…) it says Email and the address, and opens your mail app. In a cell with several links, it’s the one you clicked. Edit: Open Link in Cell, in the command palette, opens the link in the cursor’s cell. Clicking a link only puts the cursor in it, as in any other value: Ctrl+Click⌃Click adds a cursor.
The file
The numbers down the left are the file’s lines, and the bar above the rows numbers its columns; the numbers of the cursor’s line and column light up. Once you scroll past the header row, the names of the columns stay at the top, under the numbers. A click on a line number selects the row, and a click on a column number the whole column: see Selecting columns and rows. The three dots where each column ends in that bar are its menu: there you expand a column with long values, sort the rows by the column, insert a column beside it or delete it, and open the column’s filter, which hides the rows you don’t want to see for now: see Filtering rows.
Tabs
Every file opens in its own tab. A dot in place of the tab’s × means it has changes you haven’t saved. Drag a tab to move it; a blue line shows where it will go. When there are more tabs than fit, arrows at the end of the strip bring the hidden ones into view, one at a time. See Tabs, and the work you leave open.
The status bar
The bar at the bottom has two halves. The left one is about what you are looking at: where the cursor is and what is selected. The right one is about the file: how it is read and how it is saved. An item with a small arrow after it opens a list to choose from, a switch turns something on or off, and plain text only tells.
| Item | What it says | A click on it |
|---|---|---|
1 unclosed quote |
a warning, see below | opens the Quality Check panel |
412 of 1,978 rows |
with a filter on, how many rows show | a menu: clear the filter, or remove rows with it; its × clears it |
city |
the cursor’s column, with a dot in its colour and an icon for what its values are: numbers, dates, times, email addresses or text. Rest the pointer on it to see its number and, in a column of numbers, its decimal separator | Go to Column… |
Row 11 of 1,978 |
the cursor’s row, counted from the one after the header, and how many rows there are (in the header row, Header · 1,978 rows). Rest the pointer on it to see its line |
Go to Line…, ready for a row number |
3 cursors |
how many cursors there are (3 selections when they select text; Column selected, 3 columns selected) |
|
Count 4 Sum 18.5 Average 4.625 Min 2 Max 8.5 |
the selected cells, as in a spreadsheet: see Count, sum, average, minimum and maximum | copies that figure |
Select by Rows Columns |
how a drag down the file selects | Columns turns on Column Selection Mode, and Rows turns it off |
; Semicolon |
the character between values | picks another one |
| Header row | a switch, on when the first row holds the names of the columns | turns it on or off |
UTF-8 |
the file’s encoding | saves or reopens it with another |
LF |
the line breaks: LF (Unix, macOS) or CRLF (Windows) |
changes them |
When a quote opens a value and never closes, a warning at the left says how many there are. A click on it opens the Quality Check panel, which lists those and everything else that looks wrong in the file; with the panel open, the warning counts them all (7 problems).
The column profile
opens a panel at the right of the file with what the cursor’s column holds: its type, how many cells are empty, and every value with how many cells have it (in a column of numbers, a histogram of them). A click on a value or a range selects its cells. See Column profile.
Quality Check
opens, in the same place as the column profile, the list of what looks wrong in the file: rows too short or too long, stray spaces, values of the wrong type. F8 goes through them, and Ctrl+.⌘. fixes them. See Quality Check.
The command palette
Ctrl+Shift+P⇧⌘P or F1 opens the command palette: type a few letters of what you want to do and press Enter. Every command of the menus is there, named after its menu (Cells: Trim Whitespace, View: Align Columns), with its shortcut, so the palette is also the quickest way to learn them.
Ctrl+K⌘K lists every shortcut, and opens this guide.