getting started

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.

The Trusty CSV window with three files open in tabs, world-cities.csv in front: the menu bar from File to Help at the top, the tabs under it, the bar of column numbers 1 to 7, the rows of the file in a colour per column with the line numbers at the left, and the status bar at the bottom, with the cursor’s column, city, and Row 3 of 30 at the left, and Select by Rows or Columns, Comma, the Header row switch, UTF-8 and LF at the right

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.

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

View › 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

Table › 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 Help › User Guide opens this guide.