Modern CSV Changelog

What's new in Modern CSV 2.0.7

Apr 23, 2024
  • 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.

New in Modern CSV 2.0.6 (Apr 19, 2024)

  • 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:
  • 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.

New in Modern CSV 2.0.5 (Apr 19, 2024)

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

New in Modern CSV 2.0.4 (Oct 18, 2023)

  • 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

New in Modern CSV 2.0.3 (Oct 18, 2023)

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

New in Modern CSV 2.0.2 (Aug 7, 2023)

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

New in Modern CSV 2.0.1 (Aug 7, 2023)

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

New in Modern CSV 2.0 (May 25, 2023)

  • CHANGES:
  • 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:
  • Command Title
  • Add Next Match to Selection
  • Column Analysis (All Columns)
  • Column Analysis (Selected Columns
  • Column Lookup
  • Convert Number Format
  • Copy Cell(s) with Header
  • Copy File Name to Clipboard
  • Copy File Path to Clipboard
  • Copy Folder Path to Clipboard
  • Duplicate Row(s)/Column(s) Multiple Times
  • Edit Preferences
  • Email Selected Email Addresses
  • Hide All But Selected Row(s)/Column(s)
  • Insert Cells, Move Rest of Column Down
  • Insert Cells, Move Rest of Row Right
  • Insert Row(s)/Columns(s) Before Multiple Times
  • Invert Selection by Rows/Columns (Header Excluded)
  • Join Selected Cells Horizontally, Move Rest of Row Left
  • Keep Only Left/Middle/Right Part of Selected Cells
  • Move File
  • New Window
  • Open File Analysis Window
  • Open File in Text Editor
  • Place Current Date/Time Stamp (Now) in Selected Cells
  • Random Decimals (Floats) in Selected Cells
  • Random Integers in Selected Cells
  • Refresh Filters
  • Reload File with Different Parameters
  • Remove Duplicate Columns (Based on Selected Rows Only)
  • Remove Empty Columns (Based on Selected Rows Only)
  • Remove Empty Rows (Based on Selected Columns Only)
  • Remove Leading Zeros
  • Remove Selected Cells and the Rest of Their Columns
  • Remove Selected Cells and the Rest of Their Rows
  • Remove Selected Cells, Move Rest of Column Up
  • Remove Selected Cells, Move Rest of Row Left
  • Reshape Selected Cells Row-Wise/Column-Wise
  • Scroll Up/Down/Left/Right One Screen
  • Scroll to Top/Bottom/Far Left/Far Right
  • Select All Matches
  • Select Down to Bottom of Column
  • Select Duplicate Columns (Based on Selected Rows Only)
  • Select Duplicate Row(s)/Column(s)
  • Select Duplicate Rows (Based on Selected Columns Only)
  • Select From Main Cell To …
  • Select Left To Start of Row (Header Excluded)
  • Select Right to End of Row
  • Select Up to Top of Column (Header Excluded)
  • Set Number of Decimals
  • Set Parameters for File Save
  • Statistics of Selected Columns/All Columns
  • Switch to Tab
  • Unique Values of Selected Column
  • View Changelog
  • Web Search for Selected Places in Map
  • Web Search for Selected Terms
  • Misc
  • Minor bug fixes:
  • Small aesthetic improvements
  • Changed the name of Add or Remove License to Open License Manager.

New in Modern CSV 1.3.36 (Jun 12, 2022)

  • CHANGES:
  • Added a Place Current Date/Time Stamp (Now) in Selected Cells command.
  • Fixed a bug where, upon opening a file, its file extension was not evaluated in a case insensitive manner. This could cause it to ignore the setting in the File Extension Options file.

New in Modern CSV 1.3.35 (Nov 19, 2021)

  • Fixed a crash in read-only mode.
  • Fixed a bug with copying cells to text where it would sometimes leave undesired surrounding quotes around cells.
  • Slight modification to sort.
  • Slight modification to text sizes on displays not scaled to 100%.

New in Modern CSV 1.3.34 (Nov 12, 2021)

  • Improved the size of text and buttons when the screen is scaled to something other than 100%.
  • Added a Check for Updates feature.
  • Fixed an issue with copying cells containing newlines, commas, and quotes.
  • Fixed a bug in the sort commands where in some special cases, it wouldn't order them correctly or consistently.
  • Fixed a bug with the editor pane sizing incorrectly on startup.
  • Fixed a parsing bug in read-only mode when reading extremely large files (i.e. approx. 10 GB or larger).
  • Fixed the Duplicate Selected Rows/Columns commands so the selection is correct after the command.

New in Modern CSV 1.3.33 (Nov 8, 2021)

  • Fixed a rare crash when opening large files (i.e. >256 MB).
  • Fixed the Remove Selected Rows/Columns commands so when undoing them, it updates the table size in the status bar.
  • When opening a file that's read-only in the file system, it'll automatically load in read-only mode.
  • When the program is closed while displaying on a secondary monitor and later opened when the secondary monitor is no longer plugged in the system, it will display on one of the existing monitors.
  • Fixed a bug where license keys with certain non-ASCII characters would be rejected.