SheetLore

Rons Data Edit is a professional CSV / tabular text Editor for Windows. The CSV Editor provides a wealth of tools and features designed to flexibly manipulate data. Ideal to remove duplicates and split or merge columns or rows. The interface is modern, clean, and user-friendly and the power and speed of the application allow the handling of large files with ease. Unlike Excel, the Editor knows that the data is text and does not try to 'adjust' it and introduce workflow interruption with confusing errors. A perfect alternative to Excel for handling CSV data files. If additional power is needed, Rons Data Edit can run Rons Data Stream 'Cleaners' to run lists of operations in multiple data files. For more information, a complete list of features, a lite free version and a Pro Trial, are available on the Rons Place Software website.

​Tablecruncher is a lightweight yet powerful CSV editor for Mac, designed to handle large datasets efficiently. It can open files larger than 2GB, containing over 15 million rows, with a 100MB CSV file loading in under 5 seconds on a dual-core MacBook Pro. It supports various encodings, including UTF-8, UTF-16LE, UTF-16BE, Latin-1 (ISO-8859-1), and Windows 1252, automatically detecting most CSV formats and encodings. Users can utilize JavaScript as a macro language to manipulate CSV files, accessing all cells for content changes and calculations. Tablecruncher allows exporting table data to JSON, producing an array of objects if a header row is present, or an array of arrays otherwise. The find and replace dialog supports pattern searches within the table or selected areas, with Regular Expressions compliant with the ECMAScript 5 standard. It offers four color themes, including a dark mode compatible theme, enhancing user experience.