Typing, copying and pasting
The file is text, and you edit it as text: values, delimiters, quotes and line breaks, with a few helps that keep the columns in place.
Click anywhere and type. There are no cells to enter or leave: a value is the text between two delimiters, a row is a line, and what you type goes into the file exactly as you type it.
- A comma (or the file’s delimiter) ends a value and starts the next one.
- Enter starts a new row.
- Tab types a tab character, which in a tab-separated file is the delimiter. To move from one value to the next, use Ctrl+Alt+→⌥⌘→ and Ctrl+Alt+←⌥⌘←.
While you type in a column that is lined up on its decimal point, its @ or its colon, it stays lined up, even when what you have typed so far isn’t a number or an address yet. See Numbers, dates and other values.
Quotes
A value that contains the delimiter, a quote or a line break goes between double quotes: "Paris, France". Typing " at the start of a value types the closing quote too, so that a half-written value never swallows the rest of the line. Inside quotes, a quote is written twice: "the ""best"" one".
You don’t need to do this for the operations of the Table, Rows, Columns and Cells menus: a value they change gets its quotes when it needs them, and keeps the ones it had.
A new file
A new file, or a file that opens empty, takes its delimiter and header row from what you type or paste into it: paste a few rows separated by semicolons and it becomes a semicolon-separated file, with or without a header, as it would if you had opened it. As soon as you pick a delimiter or switch the header row by hand, your choice stays. See Delimiter and header row.
Copy and paste
Ctrl+C⌘C and Ctrl+X⌘X with nothing selected take the whole line, and Ctrl+V⌘V pastes it as a line. With several cursors, each copies its own selection; pasting as many lines as there are cursors puts one line at each, so a column copied from the column bar pastes back value by value.
To copy whole rows, select them on the line numbers: see Selecting columns and rows.
A table from a spreadsheet
Cells copied from Excel, Google Sheets or LibreOffice, or a table copied from Word or a web page, reach the clipboard separated by tabs. Pasted into a file with another delimiter, they become rows of the file: each tab becomes the file’s delimiter, and a value that needs quotes in the file gets them ("Smith, John" in a comma-separated file). Everything else goes in exactly as it was copied: numbers, dates and spaces are not changed.
A message says how many rows and columns went in. Its Paste as Is button puts the text back as it came, tabs and all, and Ctrl+Z⌘Z takes the whole paste away in one step.
This only happens when what you paste looks like a table: a tab between values, and the same number of values on every row. A single value, rows of different lengths, or anything pasted into a tab-separated file goes in as it is. So does a table pasted into a new, empty file: it becomes the file, tab-separated, as if you had opened it.
A table without tabs
Some programs copy a table with no tabs in its text, a line for each cell, and the table only in the formatted copy that goes with it. When the text you paste with Ctrl+V⌘V has no tabs and what was copied is a table and nothing else, Trusty CSV reads the table instead, in any file, also a tab-separated or a new one, with the same message and Paste as Is. A cell’s text is what you saw: line breaks where it had them, spaces as they showed. A cell that spans several columns gives its value and then empty values; one that spans several rows, empty values in the rows below. A page with a table and text around it isn’t a table: its text goes in as it is. pastes text only.