### 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](/content/help/cleaning/filtering/index.html) hides are left out. A message says how many rows and columns went to the clipboard.

### The formats

- Edit › Copy As › Table: 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 `00123` keeps its zeros and `3/5` doesn’t become a date.
- Edit › Copy As › Markdown: 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.
- Edit › Copy As › HTML: the code of an HTML table.
- Edit › Copy As › JSON: the rows as JSON, as [JSON export](/content/help/files/json/index.html) writes them: objects named after the columns, numbers as numbers.
- Edit › Copy As › SQL: an `INSERT` statement per row, into a table named after the file. In columns of numbers, numbers go as they are written and empty values as `NULL`. To write the whole table to a file, with the `CREATE TABLE` too, save it as [SQL](/content/help/files/saving/index.html#other-formats).
- Edit › Copy As › Values Without Quotes: 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.
