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 () 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,.taband.txt, with any delimiter. - Excel and OpenDocument workbooks:
.xlsx,.xlsm,.xlsand.ods, one sheet per tab. See Excel workbooks. - JSON:
.json, and JSON Lines in.jsonlor.ndjson, as a table. See Opening a JSON file. - Compressed files: a
.gz, such assales.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 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
, 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.