user guide

Files and formats

Opening and saving, delimiters, encodings, Excel and JSON, and the tabs you leave open.

  • Opening filesCSV, 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.
  • Delimiter and header rowHow Trusty CSV finds out the character between values and whether the first row has the names of the columns, and how to change either.
  • Encodings and line breaksThe encodings Trusty CSV reads and writes, how to fix accents that come out wrong, which encoding Excel likes, and the two kinds of line break.
  • SavingSave 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.
  • Changes on disk and previous versionsWhen another program changes a file you have open, Trusty CSV asks before loading it. It keeps previous versions of your files, and the tabs you close without saving, so that nothing it writes over is lost.
  • Comparing two versionsCompare a tab with what it was before a change, with its file on disk, with another tab or with a previous version. The differences are marked in the tab itself, which you can go on editing, and summed up in the Changes panel.
  • Excel workbooksOpen the sheets of an Excel or OpenDocument workbook as CSV, and save any tab, or all of them, as a new Excel workbook.
  • JSONOpen a JSON or JSON Lines file as a table, with its numbers as written, and export any file as JSON, an array of rows keyed by the column names, or as JSON Lines.
  • Tabs, and the work you leave openEvery file in its own tab, and every tab still there, unsaved changes and undo history included, after a reload or a restart.