Download Modern CSV
You may download Modern CSV and use it for as long as you wish without a license. If you want access to the Premium features, you can buy a license here.
If you have a version 1 license key, you will have to upgrade to use version 2. You can do so here. Upgrading is optional.
To download version 1, click here.
Changes
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
- Fixed the Snap to Column/Row After Scrolling settings in the Settings window.
- Fixed the Go to Cell command so it won’t immediately scroll to the top of the file when it’s called.
- Fixes Statistics to not count empty fields in the Number of Data Fields metric.
- Windows: Fixed an issue where in some situations, the window couldn’t be moved or resized.
- Windows: Fixed sizing issues when working on multiple monitors with different DPIs.
- Mac: Fixed rare cases where external windows were not appearing.
- Mac: Fixed an issue where the window would not show when cmd+tabbing to it from another program.
- Minor bug fixes.
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.
Version 2.1
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.
Version 2.0.8
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.
Version 2.0.7
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.
Version 2.0.6
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.
Version 2.0.5
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.
Version 2.0.4
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(orcmd+10on Mac) toalt+0(orcmd+0on 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.
Version 2.0.3
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.
Version 2.0.2
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.
Version 2.0.1
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.
Version 2.0
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 | Shortcut | Shortcut (Mac) | License |
|---|---|---|---|
| Add Next Match to Selection | ctrl+d | cmd+d | |
| Column Analysis (All Columns) | Premium Business | ||
| Column Analysis (Selected Columns)/(All Columns) | Premium Business | ||
| Column Lookup | Premium Business | ||
| Convert Number Format | Premium | ||
| 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 | Premium | ||
| Edit Preferences | |||
| Email Selected Email Addresses | Premium | ||
| Hide All But Selected Row(s)/Column(s) | Premium | ||
| Insert Cells, Move Rest of Column Down | |||
| Insert Cells, Move Rest of Row Right | alt+enter | alt+enter | |
| Insert Row(s)/Columns(s) Before Multiple Times | |||
| Invert Selection by Rows/Columns (Header Excluded) | |||
| Join Selected Cells Horizontally, Move Rest of Row Left | Premium | ||
| Keep Only Left/Middle/Right Part of Selected Cells | Premium | ||
| Move File | Premium | ||
| New Window | ctrl+shift+n | cmd+shift+n | |
| Open File Analysis Window | Premium Business | ||
| Open File in Text Editor | Premium Business | ||
| Place Current Date/Time Stamp (Now) in Selected Cells | Premium | ||
| Random Decimals (Floats) in Selected Cells | Premium | ||
| Random Integers in Selected Cells | Premium | ||
| Refresh Filters | Premium | ||
| Reload File with Different Parameters | |||
| Remove Duplicate Columns (Based on Selected Rows Only) | Premium | ||
| Remove Duplicate Rows (Based on Selected Columns Only) | Premium | ||
| Remove Empty Columns (Based on Selected Rows Only) | Premium | ||
| Remove Empty Rows (Based on Selected Columns Only) | Premium | ||
| Remove Leading Zeros | Premium | ||
| Remove Selected Cells and the Rest of Their Columns | ctrl+k,ctrl+j | cmd+k,cmd+j | Premium |
| Remove Selected Cells and the Rest of Their Rows | ctrl+k,ctrl+k | cmd+k,cmd+k | Premium |
| Remove Selected Cells, Move Rest of Column Up | Premium | ||
| Remove Selected Cells, Move Rest of Row Left | alt+delete|alt+backspace | alt+delete|alt+backspace | Premium |
| Reshape Selected Cells Row-Wise/Column-Wise | Premium | ||
| Scroll Up/Down/Left/Right One Screen | |||
| Scroll to Top/Bottom/Far Left/Far Right | |||
| Select All Matches | ctrl+shift+d|alt+f3 | ctrl+shift+d|alt+f3 | |
| Select Down to Bottom of Column | ctrl+shift+end | cmd+shift+end | |
| Select Duplicate Columns (Based on Selected Rows Only) | Premium | ||
| Select Duplicate Row(s)/Column(s) | Premium | ||
| Select Duplicate Rows (Based on Selected Columns Only) | Premium | ||
| Select From Main Cell To … | |||
| Select Left To Start of Row (Header Excluded) | shift+home | shift+home | |
| Select Right to End of Row | shift+end | shift+end | |
| Select Up to Top of Column (Header Excluded) | ctrl+shift+home | cmd+shift+home | |
| Set Number of Decimals | Premium | ||
| Set Parameters for File Save | |||
| Statistics of Selected Columns/All Columns | Premium Business | ||
| Switch to Tab | alt+ | cmd+ | |
| Unique Values of Selected Column | Premium Business | ||
| View Changelog | |||
| Web Search for Selected Places in Map | |||
| Web Search for Selected Terms | Premium |
Misc
- Minor bug fixes
- Small aesthetic improvements
- Changed the name of Add or Remove License to Open License Manager.
- 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.
- 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.