files and formats

Saving

Save keeps the file exactly as it was written; Save As changes its format, delimiter, encoding or line breaks. In the browser, Chrome and Edge save in place and the others download a copy.

Save

Ctrl+S⌘S writes the file back as it was: the same delimiter, the same quotes, the same encoding with or without its byte order mark, the same line breaks between rows and inside values. Only what you changed is different. Nothing is re-quoted or reformatted, so the file still opens the same way in the program it came from, and a version control system shows only your edits.

Where it goes depends on where the editor runs:

  • In the desktop app, and in Chrome and Edge on a computer, Ctrl+S⌘S writes to the file you opened. The first time you save a new file, it asks where.
  • In other browsers, which can’t write to your files, saving downloads a copy of the file to your downloads folder, and the menus say Download As… instead of Save As….

A tab imported from an Excel workbook or a JSON file is saved as a new file instead: see Excel workbooks and JSON.

Save As

Ctrl+Shift+S⇧⌘S asks how to write the file before asking where:

The Save As dialog: Format set to CSV — comma-separated (.csv), Encoding UTF-8, Line breaks LF (Unix, macOS), a Quote every value checkbox, and the buttons Save… and Cancel
Option Choices
Format CSV separated by commas or by semicolons, TSV, pipe-separated, Excel workbook, OpenDocument spreadsheet, JSON, JSON Lines, SQL, Markdown table, HTML page
Encoding UTF-8, UTF-8 with BOM (best for Excel), Western (Windows 1252), UTF-16 LE
Line breaks LF (Unix, macOS) or CRLF (Windows)
Quote every value puts every value between quotes, as some programs need
Rows with a filter on: every row, or only the rows it shows
Columns with columns hidden: every column, or only the ones not hidden

Choosing another delimiter rewrites the file with it, and quotes the values that need it: a value with a comma in it gets quotes in a comma-separated file. With the same delimiter and no quoting, the text is written as it is.

After Save As to a CSV or TSV file, the tab is that new file. The other formats are exports: the tab stays with its own file, unsaved changes included. So is a file with only the rows a filter shows, in any format (see Exporting the rows that show). File › Download as (File › Export as in the desktop app) opens the same dialog with a format already chosen. See Excel workbooks and JSON.

Other formats

Encoding, line breaks and quotes don’t apply to these: the text ones are written in UTF-8 with LF line breaks.

Format What it writes
OpenDocument spreadsheet (.ods) a spreadsheet for LibreOffice, Numbers or Google Sheets, as an Excel workbook is written: numbers as numbers, codes such as 00123 and the header as text. With more than one tab open, Sheets can take every tab, one sheet each.
SQL (.sql) a script that creates a table named after the file and fills it: CREATE TABLE and then INSERT statements, 500 rows each, in a transaction. It runs in SQLite and PostgreSQL.
Markdown table (.md) the table as Edit › Copy As › Markdown copies it: its columns padded to line up, numbers to the right.
HTML page (.html) a page with the table, titled with the file’s name, that opens in a browser or a word processor.

The columns of the SQL table get their type from their values:

Values Type
whole numbers INTEGER (BIGINT past 2,147,483,647)
numbers with decimals NUMERIC: exact, the digits as they are written
dates written 2026-05-03 DATE
anything else TEXT, also numbers with a currency or a unit ($12, 5 kg), codes such as 00123, and dates written another way

Numbers are written without their thousands separators and with a decimal point (1.234,50 → 1234.50). An empty or missing value (NA, null, -) in a column of numbers or dates is NULL; in a TEXT column it stays as it is. Column names that aren’t a plain word go in double quotes ("unit price"); an empty name becomes column3 (its column’s number), a repeated one name_2, and without a header row the columns are column1, column2…

Unsaved changes

A dot in place of a tab’s × means it has changes you haven’t saved. Closing it asks whether to save them, not to save them, or not to close.

Leaving the page or closing the browser doesn’t lose them: the tabs, unsaved changes included, are there when you come back (see Tabs, and the work you leave open). Still, they are only saved in the file when you save it.

File › Revert File throws the changes away and reads the file again as it is now.