Download Modern CSV

Bug Fixes

• Improved context menu reliability across tables, headers, tabs, side bar, analysis views, and pivot tables.
• Improved selection behavior after removing non-contiguous rows or columns; a cell is now selected after each removed block.
• Fixed behavior when hiding header rows and columns.
• Fixed external file refresh behavior so discarding unsaved edits also clears the undo stack.
• Fixed saving CSV rows with trailing empty cells when using the All Quotes parsing standard.
• Fixed File Metadata when loading a new file so it updates immediately.
• Fixed File Metadata where it was showing infinite file size for large files (>1 GB).
• Linux: Fixed a crash when using the Set Text Editor command.
• Minor bug fixes.

Bug Fixes

• Fixed issues with pasting.
• Fixed sizing issues with the side bar.

Features

• Copy Cells to Markdown and Copy Cells to HTML commands.
• When pasting, added automatic detection of text delimiters, Markdown, and HTML.
• Paste Cell(s) (Special) command to manually decide how to parse text on the clipboard.
• Parse Selected Cell Contents as Table command.
• Sidebar: Added Rename Folder and Reveal Folder in File System to the folder context menu.

Bug Fixes

• Behavior When File Is Changed Externally: When set to Refresh, the user is now asked what to do if they have unsaved changes.
• Fixed the height of rows when Auto-Fit Row Height is enabled.

Misc

• When editing a medium-length cell in the editor pane, the cursor now starts at the front. For shorter cells, it still starts at the back.
• Added a warning for Auto-Fit when there are a lot of rows or columns. This can be disabled in settings.

Bug Fixes

• Improved save stability, especially when Behavior When File Is Changed Externally is set to Refresh automatically.
• Improved stability in read-only mode.
• Unique Values: Fixed Histogram column sort order and made the Histogram column non-selectable.
• Fixed Duplicate Cell Contents To incorrectly writing into the first row in some cases.
• Fixed Japanese character input issues.
• Fixed selection behavior after Insert Row(s) After and Insert Column(s) After.
• Improved handling of large cells (i.e. greater than 4,096 characters).
• Fixed an issue where copying and pasting a cell from Excel could delete the cell to the right.
• Mac: Fixed an issue where attempting to paste into the Save dialog filename field would actually paste into the table.
• Minor bug fixes.

Aesthetics

• Minor aesthetic improvements.

Minor Features

• Fill Selected Cells with UUID/GUID command. Comes with a UUID Type setting to use UUID v4 (random) or UUID v7 (time-ordered).
• UUID/GUID generation via middle-mouse button click-drag. Press +, -, =, or number keys while dragging to generate a new UUID. Supports finding UUIDs within any string and preserving surrounding text.

Bug Fixes

• Fixed dragging cells below the frozen header rows or to the right of the frozen header columns.
• Fixed a bug in Add or Update ID Column where it would sometimes fill cells to the end of the viewable table rather than the end of the data.
• Fixed the location of popup windows so they don't appear in random places on the screen.
• Middle-mouse button click-drag increment/decrement improvements: It now respects leading zeros in numbers, handles large numbers better, and does not interpret values like "INV-1001" as negative numbers. Also, hitting the key again now undoes the increment/decrement.
• Fixed ctrl+left in Launcher. The shortcut to go back to the previous option is now ctrl+minus (or cmd+minus on Mac).
• Minor bug fixes.

Performance

• Find: Improved performance when rows or columns are filtered out or hidden.
• JSON/XML Import: Improved performance with both displaying file previews and with performing the conversion.

Misc

• Improvements to Import Window's UI
• Go to Cell: Improvement to the location parsing algorithm.

Bug Fixes

• Fixed Split Selected Cells Horizontally, Move Rest of Row Right when using the Split by Index option.
• Linux: Fixed crash with Recent Files from the launcher.
• Fixed the File Extension Options preferences tab where the only option for Line Ending was "(platform)".
• Improved ability to type Japanese characters. There are still known issues to be resolved in future releases.
• Fixed Reshape Selected Cells Column-Wise so it truly works column-wise.
• Fixed Save Visible Data As where it was incorrectly disabled in some circumstances.
• When the Represent Columns as Letters setting is on, fixed column headers not showing correctly when some columns are hidden.
• Fixed a bug with Convert Date/Time Format where recent two-digits years were converted to the 1900s instead of 2000s (e.g. "25" converted to 1925" instead of "2025").
• Fixed newly created/saved files not appearing in the recent files list in some cases.
• Fixed crash when closing a tab while editing in the editor pane.
• Fixed UTF-16LE (and similar) files inserting a leading newline in the first cell of each row in some cases.
• Fixed UTF-16LE regex replace appending stray characters to cells.
• Fixed Save File As ignoring the line ending chosen in Save Parameters.
• Solved false delimiter-length warning when saving files with no delimiters.
• Mac: Fixed launcher's cmd+left navigation back to prior option widgets.
• Sidebar: In the context menu for folders, fixed Copy Folder Path to Clipboard.
• Linux: Fixed Save File As or new file saves where they were omitting extensions unless typed manually.
• Linux: Fixed crashes on certain commands.
• Minor bug fixes.

Bug Fixes

• Fixed a crash when editor with the editor pane.

Bug Fixes

• Print and Export to PDF: Fixed Custom page size.
• Linux: Removed some unnecessary console messages.
• Linux: Fixed Pivot Table. In some circumstances, it would not complete.
• Minor bug fixes.

Performance

• Improved Pivot Table's performance.

Aesthetics

• Small aesthetic improvements.

Bug Fixes

• Unique Values: Fixed a bug where, when "Exclude Empty Cells" was enabled, it didn't change the percent values to reflect their absence.
• Fixed an issue where changes to the Font setting weren't persistent across sessions.
• Fixed a crash that occurs in some conditions when ctrl+shift+scrolling (or cmd+shift+scrolling on Mac).
• Made the side bar width persist across sessions.
• Print: Fixed word wrap.
• Windows: Fixed window sizing issues when using multiple monitors with different scaling factors.
• Windows: Fixed an issue where in some situations, upon startup, the window is tiny and in the corner of the display.
• Linux: Fixed a crash when running the Duplicate File command.
• Minor bug fixes.

Major Features

• Print.
• Export to PDF.

Bug Fixes

• Minor bug fixes.

Bug Fixes

• Fixed Pivot Table for large files.
• Minor bug fixes.

Performance

• Mac: Fixed UI lags when working on large files.

Aesthetics

• Minor aesthetic improvements.

Minor Features

• Pivot Table: In the right-click context menu, there's a "Copy Entire Table" option that will copy all headers and data to the clipboard.
• Separated the Highlight Main Selected Cell's Row and Column setting into two settings - one for row and one for column.

Bug Fixes

• Solved a crash when selecting entire columns in read-only mode.
• Solved a crash when importing empty or small JSON or XML files.
• Fixed some bugs with the Import UI.
• Fixed Pivot Tables where they would sometimes fail to load with large files.
• Fixed the Find/Replace pane option button keystrokes. This meant some changes to prevent conflicts:
  • Case Sensitive : alt+a
  • Regular Expressions : alt+/
  • Match Whole Word : alt+shift+w
  • Match Whole Cell: alt+shift+l
  • Match Only in Selected Cells : alt+shift+s
  • Highlight Matches : alt+shift+h
  • Preview Replace : alt+shift+p

Performance

• Mac: Drastic performance improvement with the Unique Values feature. Slight performance improvement on Windows and Linux, but they were already fast to begin with. All platforms now perform at the same speed for this feature.

Aesthetics

• Highlight Main Selected Cell's Row/Column: Increased the contrast for better visibility.
• Minor aesthetic improvements.

Major Features

• Import JSON and XML files.
• Export to JSON and XML.
• Pivot Table (Premium Business)

Minor Features

• Select Entire Row(s)/Column(s) (Header Excluded) commands.
• Increment/Decrement numerical values via mouse drag. Use the middle mouse button to click on a cell with a number. Drag it and hit a number and/or the '-', '+', or '=' (for '+') buttons.
• Snap to Column/Row After Scrolling settings.
• Preference window: Added a search field to "Settings" and "Keyboard Shortcuts".
• ASCII Separated Values parsing standard. Uses ASCII Unit Separator and Record Separator.
• Improved handling of numbers to take into account regional differences, thousands separators, and currency symbols.
• Add or Update ID Column command. (Premium)
• Added Statistics - Selected Cells and Statistics - Selected Cells by Columns commands. (Premium Business)
• All File Analysis tabs (Statistics, Column Analysis, Unique Values, Pivot Table): Added a "Use Thousands Separators" option. (Premium Business)
• Statistics: option to exclude columns without numerical data. (Premium Business)
• Sum and Mean of selected cells in the status bar. (Premium Business)

Bug Fixes

• When the read-only setting is enabled, new files created by the user are editable.
• Improved representation of values in the File Analysis tabs so it wouldn't show scientific notation until the number is exceptionally large (i.e. 10^15 or higher).

Aesthetics

• Windows: Removed native Windows chrome and integrated the title bar into the theme.
• Mac: Blended the title bar color with the theme.
• General aesthetic improvements.

Bug Fixes

• Fixed Column Lookup when filters are present.
• In View/Edit Filter(s), fixed an issue where some filter phrases wouldn't display fully.
• Fixed column width resizing when changing number of header columns and Auto-Fit Column Widths is enabled.
• When Find All returns many matches, set the scroll bar handle's minimum height to an acceptable size.
• Fixed column resizing when removing columns in some situations.
• Miscellaneous bug fixes and stability improvements.

Bug Fixes

• Fixed navigation keys not working when a new file is pulled up.
• Fixed shift selecting working only intermittently.
• Fixed an issue with the config file where in rare cases, it could cause it to stall on startup.
• When reloading a large file via that command launcher or menu, ensured that the table doesn't render which can sometimes cause a crash. It was previously fixed only for reloading from the File Metadata pane.

Usability

• Improved trackpad handling, especially on Mac. Simplified the interface so only shift causes horizontal scrolling.
• Added tool tips to the file tabs to show the full file path.

Bug Fixes

• Find/Replace: Fixed a crash when doing a Find in some circumstances.
• Find/Replace: Fixed a bug when doing a Find when filters are on or rows/columns are hidden.
• Find/Replace: When the table's been transposed, Highlight Matches and Preview Replace was highlighting the wrong cells.
• Unique Values: Applied the Case-Sensitive Sorting setting when sorting the values column.
• Unique Values: Fixed filters so they work when a cell starts or ends with a space character.
• Mac and Linux: In Unique Values, fixed the filter buttons being squashed together.
• Fixed the Join commands in the case where the last cells they're joining are empty. Before, it was not leaving separators for those cells.
• Fixed a sorting issue when sorting numbers mixed with "nan" strings.
• Hid table rendering while it reloads a large file just like when it loads it fresh.

Performance

• Improved general performance when rows/columns are filtered out or hidden.
• Minor performance improvements.

Bug Fixes

• File Metadata Pane: In large files (>24 MB), fixed the Load Parameters fields so they're not disabled.
• Fixed Select From Main Cell To .... It was selecting entire rows or columns in some cases where it should not. Also, fixed where it was sometimes highlighting the wrong range as the user typed.
• Blocked some messages from printing to the console unnecessarily.

Bug Fixes

• Fixed a crash in the sidebar.
• Solved a sort issue with UTF-16 encoding.
• Fixed BOM handling with UTF-16 and UTF-32.
• Solved a crash when sorting empty cells.
• Solved a crash with the Convert Date/Time Format command.
• Fixed an issue with filters where it wouldn't recognize edits to the filter after a regular expression filter was set.
• Fixed a bug, introduced in 2.0.3, where in some cases, it wouldn't allow the user to save a file.
• Changed the default keyboard shortcut for Switch to Tab 10 from alt+10 (or cmd+10 on Mac) to alt+0 (or cmd+0 on Mac).

Misc

• Changed the name of the Edit Preferences command to Preferences.
• Mac: The Preferences command now appears in the Modern CSV menu rather than the Preferences menu.

Bug Fixes

• Fixed a crash with the Lower Camel Case command on empty cells.
• During file save, a backup file wasn't always saved in the event something went wrong. This has been resolved.

Bug Fixes

• Made the Move Column(s) to the Left of Column ... command work.
• When a new file was created and saved, the tab bar now shows it as saved.
• Fixed an issue where it wouldn't sort timestamps of a certain format.
• The Find feature, under some circumstances, was unable to find some data in the first row. That has been fixed.
• Prevented a crash in Append Cell Contents with the Different Text option.
• In the Preferences window, fixed issues in the Keyboard Shortcuts tab regarding shortcut conflict detection and setting commands to (none).
• Fixed a bug with pasting certain data from Excel.
• Minor typo fixes.

Bug Fixes

• In the Unique Values feature, it now properly escapes characters that need to be escaped.
• Fixed the Open Recent Filepath feature so it avoids duplicate and empty entries.

Overview

• Improved UI and user experience.
• Faster performance.
• A ton of powerful features, mostly requested by current users.
• Native Apple Silicon (ARM - M1, M2) compatibility.
• Updated comprehensive documentation (see here).

UI and User Experience Improvements

• Context (right-click) menus in tabs and on side bar.
• Preference window. Changes no longer have to be made by editing a text file, but that option's still available.
• File Metadata pane to easily change file parameters and settings

Performance

• Improved app loading time
• Improved performance for files with many columns
• Improved performance for sorting numbers
• Mac: ARM (M1/M2) compatibility

Features

• New themes: Dracula, Solarized Light, Solarized Dark
• Filter with regular expressions
• Column Lookup feature (similar to VLOOKUP in spreadsheet programs) [Premium Business license]
• Statistics (Number of data points, sum, mean, variance, standard deviation, median, min, max, quintiles) [Premium Business license]
• Column Analysis (number of fields, empty vs. non-empty fields, minimum/maximum field length, data type) [Premium Business license]
• Unique Values (histogram, frequency count, filter in and out) [Premium Business license]

New Settings

• Save With Trailing Delimiters
• Text Editor
• Remove Extraneous Rows/Columns on File Save
• Case Sensitive Sorting
• Show File Metadata
• Represent Columns as Letters
• Search Engine
• Online Map

New Commands

Misc

• Minor bug fixes
• Small aesthetic improvements
• Changed the name of Add or Remove License to Open License Manager.