Trusty CSV has launched as a browser-based editor designed to treat CSV files as text rather than converted data tables. The tool addresses a persistent pain point for developers and data engineers: the loss of fidelity when opening CSVs in spreadsheets. By preserving leading zeros, preventing auto-formatting of dates, and keeping long numbers intact, Trusty CSV ensures that what you see on screen is byte-for-byte identical to what is saved on disk.

Editing Like Code, Not Spreadsheets

The interface adopts the keyboard-centric workflow of modern code editors, specifically mirroring VS Code shortcuts. Developers can use Ctrl+D to add cursors to the next occurrence in a column or Ctrl+Alt+Shift+C to place a cursor on every value in a selected column. This allows for bulk edits, such as reformatting thousands of dates or fixing prefixes, without leaving the keyboard. The editor detects delimiters, encodings, and line breaks automatically, maintaining these settings upon save to ensure cross-platform compatibility.

Built-In Data Quality Checks

Trusty CSV includes a 'Quality Check' feature that scans the entire file for 32 specific types of errors, such as broken encodings, stray spaces, and inconsistent date formats. Unlike data-prep tools that require importing files into a project, Trusty CSV fixes these issues in place. Each detected problem has a one-click fix button, and all changes remain fully undoable with Ctrl+Z. This approach allows users to clean messy exports directly in the browser without uploading sensitive data to a server.

Prepare: Data Reshaping and Cleaning Tools

Beyond basic error fixing, the 'Prepare' section offers robust tools to transform messy exports into usable tables. Users can group similar valuesβ€”such as consolidating 'Madrid', 'madrid', and 'MADRID' into a single canonical valueβ€”using varying levels of strictness from exact matches to phonetic similarity. The tool also supports filtering rows by condition or date, with excluded rows visible in grey to maintain context. For structural changes, Trusty CSV can split or join columns, reshape data by turning columns into rows (and vice versa), and summarize groups by counting, adding, or averaging. All operations modify the open file directly rather than a copy, and each step remains reversible with a single Ctrl+Z.

Key Takeaways

  • Trusty CSV operates entirely in the browser with no sign-up or file uploads, ensuring data privacy.
  • The tool prevents common spreadsheet pitfalls like losing leading zeros or converting zip codes to numbers.
  • It supports multi-cursor editing and column-specific selection for rapid bulk changes.
  • A desktop app for Windows, macOS, and Linux is currently in development for offline use.

The Bottom Line

For developers who frequently handle CSV exports, Trusty CSV offers a necessary middle ground between the raw text view of code editors and the destructive convenience of spreadsheets. It respects the file as data, not just a document, which is a rare and welcome feature in the current dev tool landscape.