Copying for other programs
Copy As puts the selected rows and columns on the clipboard as a table to paste into a spreadsheet or a document, as Markdown, HTML, JSON or SQL, or as the values without the file’s quotes.
Ctrl+C⌘C copies the text as it is in the file: delimiters, quotes and all. To paste a part of the table somewhere else, use (also in the menu of a right click), which copies it in the form that the other program reads.

What is copied
- Columns selected in the column bar: those columns, every row.
- A selection: the rows it touches, and the columns it touches in any of them. A selection inside one row copies those cells; one from the middle of a row to the middle of another copies those rows whole; a box made with Alt+Shift⌥Shift and a drag copies its rows and columns.
- Nothing selected: the whole table.
The column names of the header row head what is copied, and rows that a filter hides are left out. A message says how many rows and columns went to the clipboard.
The formats
- : a table to paste into Excel, Google Sheets, Word, Google Docs or an email, which arrives as a table, with its rows and columns. Excel keeps the columns that aren’t numbers as text, so a code such as
00123keeps its zeros and3/5doesn’t become a date. - : a Markdown table, for a README, an issue or a chat. Its columns are padded to line up in the text too, and columns of numbers are aligned to the right.
- : the code of an HTML table.
- : the rows as JSON, as JSON export writes them: objects named after the columns, numbers as numbers.
- : an
INSERTstatement per row, into a table named after the file. In columns of numbers, numbers go as they are written and empty values asNULL. To write the whole table to a file, with theCREATE TABLEtoo, save it as SQL. - : the values exactly as they are, without the quotes the file needs around some of them; a tab between columns and a line per row. Useful to copy one value, such as an address with a comma or a text with line breaks, into another program.