Is Trusty CSV free?
Yes. Open the editor and start working: no sign-up and no limits on the number of files.
Why not just use Excel, or a code editor?
A spreadsheet converts a CSV when it opens it: by default, codes lose their leading zeros, some become dates and long numbers are rounded, and that’s what gets saved. A code editor keeps the text but doesn’t know it’s a table: it can’t line up the columns, sort the rows without breaking a cell that has a line break, or tell you that a row is short. Trusty CSV keeps the text and knows the table. More in Edit CSV files without Excel changing them.
How is it different from OpenRefine or Tableau Prep?
They import your data into a project or a flow, and you export a new file at the end. Trusty CSV opens the file itself, in your browser with nothing to install, shows every row, finds the problems for you, and saves the file with only your changes. It groups similar values, filters, reshapes and joins files too. What it doesn’t do yet is replay a list of steps on the next file, and it reads files, not databases. Compared in detail: an OpenRefine alternative, a Tableau Prep alternative.
Are my files uploaded anywhere?
No. Everything happens in your browser: opening, editing, converting to and from Excel and saving. The files never travel to a server.
Can it find what’s wrong with a CSV file?
Yes. Table › Quality Check reads the whole file and lists its problems: rows cut in two or too short, repeated rows, text with a broken encoding, stray spaces, lost leading zeros, dates, numbers, yes/no values and countries written in several ways, and more, 32 kinds in all. Most have a button that fixes every case at once, and Ctrl+Z undoes it. See Quality Check in the User Guide.
Does the alignment change my file?
No. Columns are aligned only on screen. The file keeps its exact text (the same delimiter, quotes, encoding and line breaks) unless you edit it or choose another format when saving.
How large a file can it open?
Files of tens of megabytes and around a million lines open in a few seconds and stay smooth to edit. Beyond that it depends on your computer’s memory.
Can I open and save Excel files?
Yes: .xlsx, .xls and .ods open sheet by sheet as CSV, and any file can be downloaded as a new .xlsx or .ods workbook. The original workbook is never overwritten, because formulas and formatting can’t be kept in CSV.
Which browsers does it work in?
Any modern browser. Saving straight back to the original file needs Chrome or Edge on a computer; elsewhere, files are saved as downloads.
Is there a desktop app?
It’s on its way, for Windows, macOS and Linux: it opens .csv files with a double-click, saves straight back to disk and works without a connection.