Modern CSV

​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.

​Edit CSV is a free online tool that allows users to edit CSV files through a table-based user interface. It offers features such as undo/redo functionality, column sorting by clicking on header text, and the ability to rearrange rows and columns by dragging. Users can resize rows and columns, and navigate efficiently using keyboard shortcuts to move to the first cell in a row, to move to the last cell, to jump to the first cell in a column, and to reach the last cell. You can also add a line break within a cell. To delete a row or column, hover over it and click the trash icon. Double-clicking a column's resize handle adjusts its width to fit the content; double-clicking an auto-sized column sets its width to 200px, which is useful for very wide columns. It also provides a context menu accessible via right-click and supports copy-pasting using the tab key as a separator, similar to Excel.