Free
$0
Use the Free version as long as you wish.
- Multi-cell editing
- Large file handling
- Basic editing tools These include inserting, deleting, moving, and duplicating rows, columns, and cells.
- Find/replace Options include: case sensitive, regular expressions, match whole word, match whole cell, match only selected cells, highlight matches.
- Sort rows and columns
- Multiple themes Light, Dark, Dracula, Solarized Light, Solarized Dark.
- Command and file launcher
- Delimiter auto-detect
- Freeze row/column headers
- Read-only mode
- Import and export JSON and XML files Option to preserve structure so it's possible to import a file, edit it, and export it without losing data.
- Filter and hide rows/columns Filtering based on a custom syntax, numerical values, or regular expressions.
- Join and split cells Split by delimiter or index. Vertical or Horizontal. For joining, you can either move the rest of the rows/columns or leave them. For splitting, you have the option of inserting new rows/columns.
- Deduplication You can remove rows that are identical on just a subset of columns or on every column. Vice versa for column deduplication.
- Convert date/time formats Options include: Custom format, ISO 8601 (Date+time or date only), Unix epoch time (seconds or milliseconds), Excel format.
- Case conversion Options include: UPPER CASE, lower case, Title Case, lower_underscore_case (snake_case), UPPER_UNDERSCORE_CASE.
- Transpose Transpose either entire tables or portions of tables.
- File system commands Options include: deleting files, renaming files, duplicating files, opening files in the terminal.
- Print and PDF export Options include: headers on each page, row/column labels on each page, gridlines, centered, page order row-wise or column-wise, file name and page numbers on each page, selected rows and/or columns only.
- Column lookup Look up data in the same file or a different file. Option to insert new column or overwrite existing column. Leaves failed matches blank.
- Statistics Sum, Mean, Variance, Standard Deviation, Median, Min, Max, Quintiles, Number of Data Points.
- Column analysis Number of Fields, Number of Empty/Non-Empty Fields, Percent Non-Empty Fields, Minimum/Maximum Field Length, Data Type.
- Unique values analysis 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 Unlimited rows, columns, and values. Provides sum, mean, median, count, variance, and standard deviation.
- Transferable license A transferable license lasts forever and may be transferred from one user to the next as long as it is assigned to only one user at a time. A non-transferable is only assigned to one person, cannot be transferred to anyone else, and lasts for life.