Modern CSV Changelog

What's new in Modern CSV 2.0.7

Apr 23, 2024
  • 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 18, 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.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.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 (Jun 5, 2023)

  • 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
  • Misc:
  • Minor bug fixes
  • Small aesthetic improvements
  • Changed the name of Add or Remove License to Open License Manager.

New in Modern CSV 2.0 (May 24, 2023)

  • 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:
  • Add Next Match to Selection
  • Column Analysis (All Columns)
  • Column Analysis (Selected Columns)/(All 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 Duplicate Rows (Based on Selected Columns 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 shift+end shift+end
  • 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)

  • 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 (Jul 30, 2021)

  • Changes:
  • Fixed a rare crash when pening large files (i.e. >256 MB).
  • Fixed the Remve Selected Rws/Clumns cmmands s when unding them, it updates the table size in the status bar.
  • When pening a file that's read-nly in the file system, it'll autmatically lad in read-nly mde.
  • When the prgram is clsed while displaying n a secndary mnitr and later pened when the secndary mnitr is n lnger plugged in the system, it will display n ne f the existing mnitrs.
  • Fixed a bug where license keys with certain nn-ASCII characters wuld be rejected.

New in Modern CSV 1.3.31 (Jun 13, 2021)

  • Fixed a bug where a second instance wouldn’t open.
  • Fixed a bug with the Remove Selected Rows/Columns commands when filters are applied causing the filter to not update properly.
  • Fixed a bug with undoing Remove Selected Columns where it wouldn’t work properly in some circumstances.
  • Minor bug fixes.

New in Modern CSV 1.3.30 (Jun 1, 2021)

  • Fixed the Split by Index commands so they always work as expected.
  • Fixed cell drag and drop so it works on a single cell.
  • Updated the Settings file for clarity.
  • Fixed the Settings file so when updated, it doesn’t change certain settings already set for individual tables.

New in Modern CSV 1.3.29 (May 26, 2021)

  • Fixed a bug with tab and space delimiters defined in the File Extension Options file.
  • In the File Extension Options file, set the default delimiter for .csv files to “(auto)” (i.e. auto-detect delimiter). This only affects new installations.

New in Modern CSV 1.3.28 (May 25, 2021)

  • Improved performance with the Move Rows Up/Down and Move Columns Left/Right commands.
  • Added support for files without extensions to the File Extension Options file, the sidebar, and the Go to File command.
  • Implemented a Sparse Quote parsing standard. When saving a file, it will only include surrounding quotes if the cell contains a delimiter or newline character. It doesn’t affect how it reads a file.
  • Fixed several commands to scroll as the selection moves off the screen so the selection stays visible. Affected commands are: Select Up/Down/Left/Right (shift+arrow), Move Selected Rows/Columns/Cells, and Duplicate Rows/Columns/Cells.
  • Added the following commands in case the user accidentally deletes or ruins one of the preference files: Restore Settings File, Restore Keyboard Shortcuts File, and Restore File Extension Options File.
  • Added an Open Preference File Folder command.
  • Improved the Convert to Title Case command to better handle commas, dashes, and backslashes.
  • Fixed multi-cell editing so it shows the updates in all the cells with each keystroke.
  • Fixed column resizing when the Auto-Fit Column Width setting is on and header rows are frozen.
  • Fixed a bug when the main selected cells is beyond the data and the user selects over in some direction (i.e. shift+arrow).
  • Fixed a crash when the user tries to split cells by delimiter but provides a blank input for delimiter.

New in Modern CSV 1.3.27 (May 25, 2021)

  • Improved the performance of Find and Replace.
  • Improved performance of copying large amounts of data.
  • Mild performance improvement for pasting large quantities of data.
  • Ensured that when changing most settings with command (e.g. Set Theme, Set Font, etc.), the changes are written to the Settings file and persist across sessions.
  • If the user opens a folder that has a lot of files (counting recursively), it’ll pop up a warning message and allow the user to either continue or cancel. Before, it simply wouldn’t open.
  • Fixed issues when it automatically rewrites preference files on version changes.
  • Mac: Fixed Open Terminal to File’s Directory.
  • Fixed opening files from the terminal so the user can cd to different folders and open files into the already existing instance of Modern CSV without having to input the file’s entire path.
  • Windows: Ensured that when double-clicking on a CSV file, Modern CSV will come to the front.
  • Fixed the Replace pane so the keyboard focus always goes to the Find field upon opening it.
  • Fixed right-click on row/column labels so if multiple rows/columns are selected and the user right-clicks on one of them, it won’t deselect the others.
  • Fixed an issue where it wouldn’t always scroll to the main selected cell after applying a filter.
  • Minor bug fixes.

New in Modern CSV 1.3.26 (May 3, 2021)

  • Added a Save Visible Data As command. This will save a separate file containing only the data that is not filtered out or hidden. This also works in read-only mode (where filtering and sorting are allowed).
  • Added a Save After Each Edit setting. It’s turned off by default.
  • Added an “All Quotes” parsing standard option. When saving, every cell will be surrounded by quotes.
  • Improved filtering performance for large files in both edit and read-only modes, especially for number inequalities (e.g. less than, greater than, etc.).
  • Improved sorting performance in read-only mode.
  • Improved performance when deleting many rows at a time.
  • With the Save File As command, the dialog now opens to the current file’s path.
  • Improved the wording of the Convert Date/Time Format command for clarity.
  • Changed the names of a few commands for clarity.
  • Rearranged the menus for clarity.
  • Minor bug fixes.
  • Minor performance improvements.

New in Modern CSV 1.3.25 (May 3, 2021)

  • Improved the sort algorithm for better results.

New in Modern CSV 1.3.24 (Apr 11, 2021)

  • Changes:
  • Status bar now reports how many cells are in the currently selected cell.
  • Fixed delimiter auto-detection on files without file extensions defined in the File Extension Options file.
  • Improved speed of copy operation marginally when copying large amounts of data.
  • Slight improvement in load time.
  • Increased maximum number of files it will allow in a folder that is opened.
  • Fixed pasting cells copied from Excel so non-ASCII characters are displayed correctly.

New in Modern CSV 1.3.23 (Apr 2, 2021)

  • Changes:
  • Improved performance with the Remove All Filtered Out and Hidden Data command.

New in Modern CSV 1.3.22 (Mar 12, 2021)

  • Windows, Mac: Fixed horizontal scrolling with a trackpad.
  • Fixed a bug with parsing the escape character in filter strings.
  • Fixed a bug where it would not always save a file with the correct parsing standard.

New in Modern CSV 1.3.21 (Mar 12, 2021)

  • Fixed bugs related to line endings.

New in Modern CSV 1.3.20 (Mar 9, 2021)

  • Added line endings to the File Extension Options file. The options are "Windows" (CR LF) and "Unix" (LF). The default is set to the machine's platform
  • Enabled the status bar to show the size of the table when filtered or rows/columns are hidden. This is right next to the size of the whole table in the bottom left corner
  • Fixed a bug where in some circumstances, it wouldn't hide a row or column
  • Windows: Fixed issues with opening files from the command line when an instance is already open
  • Fixed Save File As so it saves according to the settings in the File Extension Options file
  • Changed the name of Remove All Filtered and Hidden Data to Remove All Filtered Out and Hidden Data for clarity
  • Minor bug fixes

New in Modern CSV 1.3.19 (Mar 9, 2021)

  • Ensured that when saving a new file, the parsing standard set in the file extensions file is applied.
  • Minor bug fixes.

New in Modern CSV 1.3.18 (Mar 9, 2021)

  • Fixed a bug where the selection would go to the wrong place when rows or columns where hidden in some circumstances

New in Modern CSV 1.3.17 (Jan 7, 2021)

  • Fixed a crash with some commands when a whole row or column is selected.

New in Modern CSV 1.3.16 (Jan 3, 2021)

  • Fixed a bug where the selection could go beyond the visible table in some circumstances.

New in Modern CSV 1.3.15 (Dec 21, 2020)

  • Improved how it handles the selection after calling Remove Selected Rows/Columns.
  • Fixed a bug where after some command calls, it wasn't scrolling to the main selected cell.

New in Modern CSV 1.3.14 (Dec 16, 2020)

  • Fixed filters so empty filter strings work.
  • Fixed table resizing issues when applying filters.

New in Modern CSV 1.3.13 (Dec 16, 2020)

  • Changed the name of the Editor Box to Editor Pane.
  • Fixed a bug with Remove Duplicate Rows/Columns command where it wasn't removing all duplicates in some circumstances.

New in Modern CSV 1.3.12 (Dec 16, 2020)

  • Fixed a bug where the table resizes incorrectly after filtering.

New in Modern CSV 1.3.11 (Dec 5, 2020)

  • Fixed a crash with inserting rows when a whole row is selected or inserting columns with a whole column selected.
  • Fixed issues with frozen header rows/columns not showing correctly in some circumstances.
  • Fixed a bug with Find Previous.
  • Limited the number of recent files in the Recent File menu to 25.
  • Ensured the same file can't appear in two different tabs.

New in Modern CSV 1.3.9 (Dec 1, 2020)

  • Added commands Sort Selected Cells Vertically/Horizontally: Ascending/Descending. These 4 commands will sort only the selected cells. They will not preserve rows or columns.
  • Fixed pasting a single cell to an entire row, column, or table.
  • When copying a single cell, it now copies only as a single cell with no newline character at the end.
  • Fixed column auto-fit when duplicating cells to new columns.
  • Fixed a crash with the Insert Rows/Columns commands in some circumstances.
  • Fixed an intermittent crash with loading very large files.
  • Fixed an issue where very large files were sometime parsed incorrectly in read-only mode.
  • Fixed a bug with copying a whole file where an extra tab character was at the end of each row.
  • Windows: Fixed the Recent Files list so it only shows backslashes.
  • Windows: Fixed portable versions so the config files are all kept within the portable folder.

New in Modern CSV 1.3.8 (Nov 22, 2020)

  • Fixed a bug with filtering negative numbers.
  • Added a Parsing Standard feature to allow the user to parse a file with either the RFC 4180 standard or by delimiter only. This includes a new column in the File Extension Options preference file.
  • Changed the File Extension Options file to not allow the Auto-Detect Delimiter setting to override the Delimiter column. Typing (auto) in the column will enable auto-detect for that file extension regardless of the Auto-Detect Delimiter setting.
  • Changed copy/paste behavior so when the user pastes a single cell, it'll paste into every selected cell, not just the main. The behavior when multiple cells are in the clipboard is unchanged.

New in Modern CSV 1.3.7 (Nov 20, 2020)

  • Added support for Chinese, Japanese, and Korean character encodings.
  • Fixed a bug where Remove All Row(s)/Column(s) didn't work when the whole table is selected.

New in Modern CSV 1.3.6 (Nov 20, 2020)

  • Linux: Fixed a bug causing it to not run in CentOS.
  • Fixed a minor bug with the launcher not always showing all the instructions when the OS's display is scaled.

New in Modern CSV 1.3.5 (Oct 26, 2020)

  • Mac and Linux: In the Find and Replace windows, fixed Highlight Matches and Preview Replace so thet update when scrolling.
  • Fixed a bug where Highlight Matches and Preview Replace weren't always working when the Find or Replace window was closed and opened again.

New in Modern CSV 1.3.4 (Oct 25, 2020)

  • Fixed a bug with filtering rows when a table is transposed.
  • Fixed the launcher's option text sizes so it appears find when the OS's displayed is scaled to greater than 100%.
  • Fixed a bug causing a crash in some circumstances when trying to find a phrase that exists in a cell that's been filtered out.
  • Fixed a bug where in some circumstances, the user's delimiter preference in the File Extensions file to be overwritten with a comma when changing versions.
  • In the Find window when Highlight Matches is selected, enabled it to highlight new matches that appear as the user scrolls. Also ensured that the highlights update if the user edits the table.
  • Added a Preview Replace option to the Replace window with shortcut alt+p. It'll highlight the cells to be replaced and show inside the cells in green what the new values will be if the user selects Replace All. No actual data is being overwritten and the previews will go away when the Replace window is closed or the Preview Replace option is turned off.
  • In addition to the Scroll to Top command, added Scroll to Bottom, Scroll to Left, and Scroll to Right. Made the default shortcuts ctrl+home, ctrl+end, ctrl+shift+home, and ctrl+shift+end respectively (cmd instead of ctrl for Mac).

New in Modern CSV 1.3.3 (Oct 19, 2020)

  • Fixed launcher size so it does not cut off the bottom part of instructions when the OS is configured to scale the display to >100%.
  • Fixed filter syntax bug.
  • Fixed a bug causing it to not start editing cells without clicking the mouse button in some circumstances.

New in Modern CSV 1.3.0 (Oct 14, 2020)

  • Improved filter syntax to accept numerical ranges, negative filters, and AND operators.
  • Added Insert Row(s) After and Insert Column(s) After commands. Their shortcuts are ctrl+enter and ctrl+shift+enter. The old Insert Row(s) and Insert Column(s) commands were renamed to Insert Row(s) Before and Insert Column(s) Before.
  • Added a Prepend Cell Contents command. It behaves just like Append Cell Contents, except it prepends rather than appends text.
  • Added a setting called Behavior When File is Saved Externally. The options are "refresh", "ask", and "ignore".
  • Added a setting called Let Editor Box Consume Navigation Keystrokes. It is set true by default. When it's true, enter and tab keystrokes will be used to navigate the text within a single cell when the editor box is on. When it's false, enter and tab keystrokes will be used to navigate across cells, just like when the editor box is disabled.
  • When doing a find or replace with multiple cells selected, it automatically turn on the Match Only in Selected Cells option.
  • When a file is saved externally and it refreshes in Modern CSV, the scroll bars will stay where they were before unless the file size has shrunk.
  • Added the ability to hide row/column labels with new settings called Show Row Labels and Show Column Labels.
  • In the light theme, changed the color of the selected cells to blue.
  • Changed the licensing model to freemium. Licenses bought before the change will still work.
  • Updated tutorial.

New in Modern CSV 1.2.10 (Oct 14, 2020)

  • Fixed the Zero-Fill Whole Numbers command so it works correctly when an entire row or column is selected and so it doesn't operate on empty cells.
  • Added Show All Hidden Rows/Columns to the right-click menu.

New in Modern CSV 1.2.9 (Oct 14, 2020)

  • Fixed a bug causing frozen header rows to cover up part of the rows below in some circumstances.
  • Fixed a bug causing it to incorrectly parse some improperly formatted files in read-only mode.
  • Windows: Made 32-bit installer and portable versions.
  • Added Remove All Filters and Filter Selected Row/Column with Selected Cell Contents to the right-click menu.
  • Fixed a bug where if a file with an extension set to open in a non-UTF-8 character encoding had a dot in the file name, it would open as UTF-8.
  • Windows: Upon saving, changed the newline from LF (0x0A) to CRLF (0x0D0A).
  • Fixed Duplicate Cell Contents so the new row/column resizes correctly when Auto-Fit Column Widths or Auto-Fit Row Heights is set.
  • Fixed a bug with pasting causing the last cell to be incorrectly surrounded by double-quotes in some circumstances.
  • Fixed a bug with Zero-Fill Whole Numbers so it now works with very large numbers and numbers with leading zeros.
  • Fixed Find/Replace so it finds matches for non-Roman characters with non-Unicode character encodings.
  • Fixed a rare crash with Find.

New in Modern CSV 1.2.8 (Sep 18, 2020)

  • Fixed a bug causing frozen header rows to cover up part of the rows below in some circumstances.
  • Fixed a bug causing it to incorrectly parse some improperly formatted files in read-only mode.

New in Modern CSV 1.2.7 (Sep 18, 2020)

  • Fixed a bug with the Hide Empty Rows/Columns commands.

New in Modern CSV 1.2.6 (Aug 31, 2020)

  • Fixed a bug causing a crash when the user starts editing a cell with a non-Latin character.

New in Modern CSV 1.2.5 (Aug 24, 2020)

  • Open Recent Files: Changed the number of files to 50 and fixed a bug to ensure all files make the list.
  • Fixed a bug to ensure that when both row and column headers are frozen, the top left corner displays correctly.
  • Fixed a bug causing a crash when closing a folder on some conditions.
  • Minor bug fixes.

New in Modern CSV 1.2.4 (Jul 30, 2020)

  • Fixed stability issue with the new Stop Editing command when using large cells.

New in Modern CSV 1.2.3 (Jul 19, 2020)

  • Made alt+i/k/j/l work while editing a cell (move selection up, down, left, or right).
  • Added a command to stop editing. The default shortcut is ctrl+e for Windows and Linux, cmd+e for Mac.
  • Ensured that as filtered rows/columns are moved around, the filter definitions are updated to reflect the moves.
  • Renamed the Revert File to Saved command to Reload File.
  • Moved the Reload File with Delimiter and Reload File with Encoding commands under the File menu.
  • Improved performance/stability for opening large files.
  • Minor bug fixes.

New in Modern CSV 1.2.2 (Jul 9, 2020)

  • Fixed a bug causing it to erase File Extension Options between version upgrades.
  • Stability improvements.

New in Modern CSV 1.2.1 (Jul 7, 2020)

  • Windows: Enabled the user to type Unicode characters with alt+(Unicode decimal typed on keypad).
  • Fixed a bug causing the program to continue owning a file after disabling read-only mode.
  • Fixed a bug causing the context menu in the cell editor to not work correctly.
  • Fixed stability issues when opening empty files.
  • Fixed stability issues when deleting columns in special cases.
  • Fixed the Revert File to Saved command so it now reloads with the correct delimiter and encoding.
  • Minor bug fixes.

New in Modern CSV 1.2 (Jun 29, 2020)

  • Added delimiter auto-detection. It is optional and enabled by default.
  • Added ability to hide individual rows/columns or hide empty rows/columns.
  • Improved the Split Cells Horizontally/Vertically commands. They can now be split with a delimiter or by character index. They will also now insert new rows or columns instead of overwriting old data.
  • Convert Date/Time Format: Added ISO 8601 with date only. Also, for custom formats, characters enclosed within double quotes will not be parsed.
  • Added a Zero-Fill Whole Numbers command.
  • Improved the performance for removing and inserting rows/columns.

New in Modern CSV 1.1.7 (Jun 21, 2020)

  • Changes:
  • Enabled scrolling while editing a cell on the right side of the window.

New in Modern CSV 1.1.3 (Jun 19, 2020)

  • Made portable Windows version store config information alongside the executable.
  • Fixed a bug causing Replace All to not work correctly in some situations.
  • Linux: Fixed a problem in some distributions making the folder/file names unreadable in the Open File, Open Folder, and Save File dialogs.
  • Minor bug fixes.

New in Modern CSV 1.1.2 (May 16, 2020)

  • Fixed an intermittent stability issue in loading files of a certain size.

New in Modern CSV 1.1.1 (May 7, 2020)

  • Added a Convert Date/Time Format command. It can now convert between ISO 8601, Excel, Unix Epoch, and custom formats.
  • When selecting cells, shift-click will now select the cells between the clicked cell and the main cell.
  • Added the ability to join or split cells with newline or tab characters.
  • Mac and Linux: Fixed a bug causing some text to be unreadable in the dark theme.
  • Bug fixes with the preference files.
  • Fixed a bug causing it to crash on some commands when operating on entire columns or rows.
  • Fixed a bug with Replace Next/Previous when the Match Only in Selected Cells option is set.

New in Modern CSV 1.1 (May 1, 2020)

  • Changes:
  • Added a Convert Date/Time Format command. It can now convert between ISO 8601, Excel, Unix Epoch, and custom formats.
  • When selecting cells, shift-click will now select the cells between the clicked cell and the main cell.
  • Added the ability to join or split cells with newline or tab characters.
  • Mac and Linux: Fixed a bug causing some text to be unreadable in the dark theme.
  • Bug fixes with the preference files.
  • Fixed a bug causing it to crash on some commands when operating on entire columns or rows.
  • Fixed a bug with Replace Next/Previous when the Match Only in Selected Cells option is set.

New in Modern CSV 1.0 (Apr 17, 2020)

  • Fixed bugs and improved functionality when filters are applied.
  • Fixed bugs and improved functionality when the table is transposed.
  • For any command that requires a location input (i.e. cell, row, or column), it will scroll to and highlight the location as the user types it in.
  • Added filter status to the status bar.
  • Made the launcher slightly transparent.
  • For highlighted cells, added red lines around the cell borders.
  • Set the default keyboard shortcut for the Transpose Table command to ctrl+alt+t (Windows, Linux) or cmd+alt+t (Mac).
  • Fixed a bug causing the Remove Empty Rows/Columns commands to not work correctly in some circumstances.
  • Fixed a bug causing it to not always load a file properly when there is no delimiter.
  • In read-only mode, the Transpose Table command and all the sort and filter commands now work (only for display. Changes can't be saved).
  • Fixed minor bugs with the replace feature.
  • Fixed minor bugs with the filters feature.
  • Fixed a few bugs causing it to show the wrong table dimensions in some circumstances.
  • Fixed a bug causing the minimum window width to be much larger than necessary.

New in Modern CSV 0.9.0.2 Beta (Mar 30, 2020)

  • Fixed a bug with the Move Row Just Above Row ... command that caused the undo command to work improperly in some circumstances.
  • Fixed a bug causing the program to crash when pasting while the whole table is selected.
  • Included the name of the open file in the window title.
  • Made changes in the About window.
  • Eliminated most of the unwanted console messages when running from the console.

New in Modern CSV 0.9.0.1 Beta (Mar 25, 2020)

  • Fixed a bug so Find now works properly in read-only mode.
  • Fixed a bug so when opening the program from the console, it's now possible to specify a file to open with relative file paths.
  • Set a maximum default height for the Find All results widget.
  • Changed the trial period to 30 days and disabled use after the trial period.
  • Enabled the user to drag and drop a license file into the Add or Remove License window.

New in Modern CSV 0.9 Beta (Mar 16, 2020)

  • Supports multiple text encodings rather than just UTF-8.
  • Added a new preference file: File Extension Options. This can be used to set delimiters and file encodings for various file extensions.
  • When the user clicks on items in the status bar, menus with relevant commands will pop up.
  • macOS: Enabled it to open files from the terminal using the open -a 'Modern CSV' <file path> command.
  • Fixed sort so it preserves the original order as much as possible.
  • Fixed a bug with inserting columns when the whole table has been transposed and columns are filtered.
  • Fixed the Move Cell Contents To... command so it moves the cells to the correct row when the user only inputs the row.
  • Windows: Fixed the Open Terminal to File's Directory command.
  • Selecting multiple rows/columns by clicking and dragging on the row/column labels now works consistently.
  • Fixed a bug so the Set Text Size command now shows the correct text size in the command launcher.
  • Fixed a bug causing problems with search if the main selected cell is past the last row of data.
  • Fixed a bug causing it to crash when undoing a Split Selected Cells command.
  • Minor bug fixes.

New in Modern CSV 0.8.1.2 Beta (Feb 10, 2020)

  • Changes:
  • Mac: Improved the appearance of the main table's scroll bar.
  • Mac: Fixed a bug preventing it from horizontally scrolling when the user holds shift while rolling the scroll wheel.
  • Mac: Fixed the tutorial to be consistent with Mac keyboard shortcuts.
  • When using the Join Cells Horizontally/Vertically, only the cells that end up with data will be selected after the command is complete.
  • Updated the links in the Contact Us and Help menus to fit the new website (older version will still work via 301 redirects).
  • Fixed a bug causing it to not enforce the table size rules (i.e. Minimum Number of Table Rows/Columns and Number of Buffer Rows) when deleting rows or columns.
  • When transposing an entire table, made sure the cells that are selected are transposed as well.
  • Fixed a bug causing it to not transpose the filter range when transposing a table with filters (e.g. a filtered column should turn into a filtered row).

New in Modern CSV 0.8.1.1 Beta (Feb 8, 2020)

  • Improved the row/column drag feature by showing a line where the row or column will be dropped rather than highlighting a row or column next to the destination, which was confusing.
  • Improved the Move Row(s) Just Above Row ... command and Move Column(s) to the Left of Column ... command by also placing a line at the destination rather than using cell highlighting.
  • Merged the Remove Extraneous Rows command and the Remove Extraneous Columns command into the Remove Extraneous Rows and Columns and added functionality. The original command only made the scroll bars shrink back to approximately the size of the file (e.g. if the user used to Go To command to go to row 1,048,576 on a 5x10 file, this command ensured that the scroll bar wouldn't go down that far forever). The new command still does that, but it also removes empty rows and columns at the edge of the file. That way, the file isn't left with a bunch of unnecessary commas.
  • Fixed bugs causing it to incorrectly remove rows or columns in some circumstances.
  • Made it impossible for the user to move rows above the table. Such guardrails were already in place for columns, but not rows.

New in Modern CSV 0.8.1 Beta (Jan 27, 2020)

  • Added a row/column drag feature. While holding shift, click in a row or column header and you can move the entire row or column. If other rows or columns are already selected, they'll move too.
  • Fixed a bug causing it to save to the wrong cell when editing with filters.
  • Improved UI appearance in Mac.
  • Added a close button to the find/replace widget.
  • It now accepts license files that are dragged and dropped into the program.
  • Fixed a bug that caused the tab to be labeled ".csv" when the user starts to save a new table and cancels.
  • Added a row/column drag feature. While holding shift, click in a row or column header and you can move the entire row or column. If other rows or columns are already selected, they'll move too.
  • Improved UI appearance in Mac.
  • Added a close button to the find/replace widget.
  • It now accepts license files that are dragged and dropped into the program.
  • Fixed a bug causing it to save to the wrong cell when editing with filters.
  • Fixed a bug that caused the tab to be labeled ".csv" when the user starts to save a new table and cancels.
  • Fixed a bug causing the Join Selected Cells Horizontally command to not work correctly when filters are applied.
  • Fixed a bug causing the Move Cell Contents commands (alt+up|down|left|right) to sometimes behave incorrectly when moving non-adjacent cells.
  • Fixed a bug causing it to sometimes not change delimiters when the new delimiter is blank (e.g. no delimiter).

New in Modern CSV 0.8.0.5 Beta (Nov 22, 2019)

  • Added the table dimensions in the status bar.

New in Modern CSV 0.8.0.4 Beta (Nov 18, 2019)

  • Added a setting to retain sort and filter information when a file is edited and saved externally (enabled by default).

New in Modern CSV 0.8.0.3 Beta (Nov 13, 2019)

  • Added an editor box so cell editing can be done outside the cell. This feature is disabled by default but can be enabled with ctrl+k,ctrl+e for Windows and Linux and cmd+shift+e for Mac. New lines can be added to cells using ctrl+enter and tab characters can be added using ctrl+tab. These characters can only be added using the editor box.
  • It now updates the settings and shortcuts files when a new version is loaded while retaining the old preferences.

New in Modern CSV 0.7.8.4 Beta (Oct 23, 2019)

  • Fixed a bug preventing it from removing duplicate rows and columns.
  • Fixed the scroll bar handle in the launcher so it doesn't become excessively small with a large number of options.
  • Fixed a bug causing it to sometimes scroll the edited cell off screen when the user begins editing.
  • Fixed a bug causing the esc key to not work in rare circumstances.
  • Enabled it to handle either CR or LF line endings.
  • Rearranged the View->Headers menu to make it clearer.

New in Modern CSV 0.7.8.3 Beta (Oct 14, 2019)

  • Fixed a bug causing the Move Cell Contents To command to sometimes leave the value behind (i.e. duplicate instead move).
  • Fixed a bug so it now enforces the number of buffer rows/columns when a file is saved externally.
  • Fixed a bug that sometimes prevented it from changing the settings or shortcuts when the settings or shortcuts file is saved.
  • Moved the Show [Side Bar|Tab Bar|Menu Bar|Open Files|Folders] settings out of the settings file. Now, they persist across sessions.
  • Added a drag and drop feature to move cells. Cells can be dragged by pressing shift while left-clicking. This is equivalent to the Move Cell Contents To command.

New in Modern CSV 0.7.7.8 Beta (Oct 1, 2019)

  • Fixed a bug preventing it from inserting rows in some situations.