files and formats

Opening files

CSV, TSV, text, Excel and JSON files, also compressed, from the Open dialog, by dragging them in or from the recent list, with their format worked out for you.

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.
  • JSON: .json, and JSON Lines in .jsonl or .ndjson, as a table. See 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.

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: 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;
  • 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.

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.