# Opening Files in Trusty CSV

`Ctrl` + `O` / `⌘`  `O` (File › Open File…) opens one file or several, each in its own tab. You can also drag files from your computer and drop them anywhere on the window.

Trusty CSV opens:

- **Text files**: `.csv`, `.tsv`, `.tab` and `.txt`, with any delimiter.
- **Excel and OpenDocument workbooks**: `.xlsx`, `.xlsm`, `.xls` and `.ods`, one sheet per tab. See [Excel workbooks](/content/help/files/excel-workbooks/index.html).
- **JSON**: `.json`, and JSON Lines in `.jsonl` or `.ndjson`, as a table. See [Opening a JSON file](/content/help/files/json/index.html#opening-a-json-file).
- **Compressed files**: a `.gz`, such as `sales.csv.gz`, and the CSV, TSV, text and JSON files in a `.zip`. See [Compressed files](/content/help/files/opening-files/index.html#compressed-files).

A file that is already open isn’t opened twice: its tab comes to the front.

## Compressed files

A `.gz` file holds one file: `sales.csv.gz` opens as `sales.csv`, and `orders.json.gz` as the JSON file it holds. A `.zip` can hold many: with one CSV, TSV, text or JSON file it opens it, and with several it lists them to pick one, or **All files**, one tab each. Folders don’t matter, and what isn’t a table (images, documents, the hidden files a Mac adds) is left out. Archives with a password, `.tar.gz` files and zip files over 4 GB can’t be opened: extract their files first.

The tab is a copy of the file, as with an [Excel workbook](/content/help/files/excel-workbooks/index.html): the archive is never changed. `Ctrl` + `S` / `⌘`  `S` asks where to save the file, as File › Save As… does, and saves it uncompressed.

## What it works out

When it opens a text file, Trusty CSV reads it to find out how it is written, and the status bar shows what it found:

- the **delimiter**, comma, semicolon, tab or pipe, and whether the first row is a **header**: see [Delimiter and header row](/content/help/files/delimiter-and-header/index.html);
- the **encoding**, UTF-8, Windows 1252 or UTF-16, and whether it starts with a byte order mark;
- the **line breaks**, between rows and inside values, which aren’t always the same: see [Encodings and line breaks](/content/help/files/encodings-and-line-breaks/index.html).

You don’t need to say any of it, and saving keeps all of it, so the file still opens the same way in the program it came from.

## Recent files and samples

File › Open Recent, and the start page, list the files you opened lately: in the desktop app, every one; online, in Chrome and Edge, the ones opened from the Open dialog or dropped on the window (other browsers can’t open a file again by themselves). **Clear Recently Opened**, at the end of the list, empties it.

The start page also has four sample files to try things on: cities of the world with a header row, a semicolon-separated file with decimal commas, support tickets with long values and line breaks inside them, and a tab-separated file with no header. File: Open Sample… in the command palette opens them too.

## Large files

Files of tens of megabytes and around a million rows open in a few seconds and stay smooth to edit, and the cleaning operations work on all of it. Beyond that it depends on your computer’s memory; for a file over 150 MB, Trusty CSV asks before opening it.

## In the desktop app

Double-click a `.csv`, `.tsv` or `.tab` file, or use your system’s **Open with**, and it opens in Trusty CSV; if the app is already running, the file opens in a new tab of its window.
