Free
$0
Use the Free version as long as you wish.
- Multi-cell editing
- Large file handling Rapid file loading, responsive editing, and cancellable progress updates for long operations. Includes Stream Edit and Read-Only modes for even lighter memory footprints.
- Basic editing tools Insert, delete, move, or duplicate rows and columns. Find and replace values or sort your data.
- Filter and hide rows/columns Filter using text patterns, numeric comparisons, or regular expressions. Hide selected rows or columns.
- Multiple themes Light, Dark, Harvest Moon, Vintage Dark, Dracula, Solarized Dark, Solarized Light, Retro Green, Grayscale Dark, Grayscale Light, None More Black, Cyberpunk, Sepia, Vintage Light, Radiant Red, Nightfall Blue, Kind of Blue, Velvet Purple
- Command and file launcher
- Delimiter and character encoding detection
- Import/export JSON, XML, and Excel files
- Print and PDF export (not included)
- Join and split cells (not included)
- Merge and split files (not included)
- Deduplication (not included) You can remove rows that are identical on just a subset of columns or on every column. Same for column deduplication.
- Convert date/time formats (not included) Includes format auto-detection.
- SQL queries and filters (not included) Use SQLite syntax to filter rows or query across multiple files.
- Column lookup (not included) Look up data in the same file or a different file. Option to insert new column or overwrite existing column. Leaves failed matches blank.
- Compare and reconcile columns (not included) Compare values in columns from the same or different files. Remove or add the deltas.
- Statistics (not included) Sum, Mean, Variance, Standard Deviation, Median, Min, Max, Quintiles, Number of Data Points.
- Column analysis (not included) Number of Fields, Number of Empty/Non-Empty Fields, Percent Non-Empty Fields, Minimum/Maximum Field Length, Data Type.
- Unique values analysis (not included) Frequency Count of Each Unique Value in a Column, Percent of All Values, Histogram Plot. You can select one or more values to filter in or out.
- Pivot Table (not included) Unlimited rows, columns, and values. Provides sum, mean, median, count, variance, and standard deviation.
- Charts (not included) Scatter, line, histogram, bar, and pie charts. Includes export and print options.
- Formulas plugin (not included) Write formulas in Python.
- Scripts plugin (not included) Write custom commands in Python and record macros.
- Terminal Commands plugin (not included) Call and send file data to other applications directly from Modern CSV.