CSV Editor Pro Changelog

What's new in CSV Editor Pro 28.0

Mar 18, 2024

Paste Column/Paste New File: the Sort Method of each column will be auto-detected by examining the contents of the first 100 rows.
Graph/Histogram/Pie Chart: the numeric formats of the CSV data is now expected to match the system's "Region and Language" settings. For example, a Greek number is formatted like "12.345,67".
Graph: the system's "Region and Language" settings are now used to interpret the date format. This allows the system to interpret non-English dates better than how it was done previously, such as "Diciembre 20, 2023" for a Spanish user. If the date cannot be interpreted, it will fallback to the old method, so this should not cause any problems.
Histogram: added the ability to change the background color.
Preferences: added an option to control what portion of the filepath is displayed on the Welcome Panel's Recent Files list. Previously, only the filename was displayed.
Preferences: added an option to alphabetize the Welcome Panel's Recent Files list. Previously, the list was always in order of recency.
Preferences: the "Full Path On Caption" option has changed from a checkbox to a combobox named "File On Caption" with a third option to show the filename without the extension.
Histogram: past entries in the Bottom Label field are now remembered in a drop-down list.
Pie Chart: the "Add Slice" tool now remembers past color settings. Previously only the original set of slices would remember their colors.
Because CSV Editor Pro is now a 64-bit app, the memory limit for the Undo tool has increased from 10 MB to 100 MB.
Set Entire Column: this tool now remembers all settings.
Preferences: added the "Enter Moves Down" option. Previously this was only located on the Options menu.
Export To JSON: added the ability to select which columns will be exported.
Command Line: if the file doesn't exist, and doesn't have an extension, and there is only one file with that name, it is assumed the user is referring to that file.
Preferences: moved the "Reopen Files From Last Session" option to a new tab named "Welcome".
Pie Chart: moved the Digits field to the second window where changes can be observed instantly.
Histogram: the "Title" and "Bottom Label" fields are now controlled by a checkbox.
File Properties: when pasting a password, if the length of the password is over the limit, an error will now appear. Previously the password would be truncated and the user would have no idea why it wasn't working.
Graph: when opening the example csv file for the first time, the column names will be automatically populated.
Redesigned the "Blues" skin.
The Multiline editor and Warnings no longer have a 3D border.
Fixed: the Column Sort Method and Alignment toolbar icons were affecting the last column heading that was right clicked on rather than the column with focus.
Fixed: right clicking on a column heading and changing the Alignment was only working if a cell in the column had input focus.
Fixed: selecting text in a cell with mouse, then right clicking without releasing the left mouse button, would prevent switching to other tabs until giving focus to another cell.
Fixed: Histogram: if the "Maximum Value" was creating one or more empty datapoints, the rightmost value was incorrect.
Fixed: Graph: when "X-Axis Input" is set to "Text", the value on the graph is now the total of all rows that have the same text, rather than ignoring all but the first one.
Fixed: Graph: there could be a hang if the date range was extreme, or if dates are not interpreted correctly.
Fixed: Graph: a row could be omitted from the graph if it contained a date with an invalid time.

New in CSV Editor Pro 27.0 (Nov 14, 2023)

CSV Editor Pro is now a 64-bit app, and will not run on 32-bit windows. This allows it to open larger CSV files.
Set Entire Column: added the ability to convert the letters in the column between lower and upper case.
File Properties: if the "No Column Names" box is checked, the old column names will be copied to a new first row.
Graph: thin faint horizontal and vertical lines are now drawn centered on the datapoint that the mouse is hovering over. This can be disabled on the "Mouse Tracking" submenu.
Graph: added the ability to control the number of digits after the decimal point on the right Y-axis.
Histogram: added the option to make the Y-axis labels horizontal. Previously they were always vertical.
Histogram: the preview's Mouse Tracking setting is now remembered.
Pie Chart: the "Format" field has been moved to the second dialog, so that changes to it are immediately apparent.
Pie Chart: the second dialog will now remember the window position and the widths of all columns.
Export To JSON: numeric values with a leading period will automatically have a "0" inserted to conform with JSON standard (e.g. ".45" -> "0.45").
Toolbar: added the ability to place an "Import From Database" icon on the toolbar, although it is hidden by default.
Encryption: added detection if the file length is incorrect, which indicates the file is corrupt.
After pasting columns with no names into an empty file, the "No Column Names" option will automatically be turned on.
Added the "Cerulean" skin. Redesigned the "Purples" skin and renamed it "Purpendicular".
When an error popup window is visible, the taskbar button will now be red.
Updated PCRE2 from 10.40 to 10.42
Graph: the "Appearance" drop-down lists are now alphabetized.
Reduced trial from 30 days to 21.
Fixed: the encryption salt was not being randomized properly.
Fixed: after closing a tab, input focus might not be restored to the current tab.
Fixed: Paste Columns: if it was necessary to add rows because the clipboard contained more rows than the table, the Undo tool was not removing those rows.

New in CSV Editor Pro 26.0 (Jul 5, 2023)

Added the ability to encrypt and password protect a CSV file. Open the file, launch the File Properties tool, check the "Password" box, enter a password, and then save the file.
Export To HTML: added the ability to select which columns will be exported.
Pie Chart: on the second dialog, a "Value" and "Final Label" columns have been added. The Final Label column is calculated from the contents of the Label and Value columns, which are editable. This makes it easy to customize the pie chart.
Pie Chart: added the ability to add a new slice that was not in the source data.
Graph: added the ability to control the number of digits after the decimal point on the left Y-axis.
Graph: Units Position: added a third option to hide the units.
Histogram: added the ability to control the number of digits after the decimal point on the Y-axis.
Set Entire Column: Perform Math: this now obeys the operating system regional numeric format settings.
Multiline editor: Added the Ctrl+Shift+Del hotkey, which deletes everything until the end of the line.
Multiline editor: Ctrl+Del no longer deletes the newline if the next word extends to the end of the line.
Paste Column: the "Insert After" field is hidden if the file has no columns.
Search Table: if a regex replacement string refers to a nonexistent substring (e.g. $1), this will now display an error.
Quick Text: added the ability to sort the list.
Quick Text: the Rename tool now has a hotkey, F2.
Jump To Row: this now ignores the thousands separator, per the operating system regional numeric format settings.
Spell Check Table: this now reports the total number of words that were added to the dictionary.
Toolbar: added the ability to place a "Column Alignment" icon on the toolbar, although it is hidden by default.
Graph: it is now possible to check the "Bottom Label" box, but leave the text empty, to eliminate the Bottom Label completely.
Histogram: the "Title" field will now remember past inputs in a drop-down list.
Added the ability to delete an item from the File History at the bottom of the File menu.
Graph/Histogram/Pie Chart: clicking the "Copy" button now shows an animation to indicate that something happened.
Removed the "Don't Print" column option since the columns can now be selected on the Print dialog.
Fixed: Paste New File: removed the unnecessary "Insert After" field.
Fixed: Export To HTML: removed the unused "Print Preview" checkbox.
Fixed: when a batch file opens multiple CSV files all at once, more than one instance could open.
Fixed: Set Entire Column: Insert Prefix/Append Suffix: this was broken in 8-bit character mode.
Fixed: menus did not support fixed-pitch fonts.

New in CSV Editor Pro 25.1 (Mar 3, 2023)

New in CSV Editor Pro 24.1 (Sep 8, 2022)

New in CSV Editor Pro 24.0 (Aug 9, 2022)

Added the "Quick Text" tool for the cell editor. This allows you to create, and later insert, snippets of text.
Added the "Always 'Save As' To Folder" preference, which allows you to specify the default folder for saving new files. Previously, the default folder was always wherever the last file was opened or saved.
Shift Cells: added the "Distance To Shift" setting. Previously the distance was always 1.
Shift Column: the preview now shows the row numbers. This is useful when specifying a pivot row.
Shift Column: added the ability to change which column the tool is operating on. Previously it always acted on the column with focus.
Filter: the "Conditional" mode's == operator is now case insensitive unlike the = operator.
Graph: added the ability to change the background and foreground colors.
Graph: added the "No values on dataset 1" option.
Graph: the X-axis values will now use 0, 1, or 2 digits after the decimal point as appropriate. Previously it was always 0.
Pie Chart: this now remembers settings on a per-file basis.
The Pie Chart is now anti-aliased.
Open Nonstandard: the file settings are now recorded as soon as the file opens. Previously, they were only recorded if the file was saved. This is important for restoring the session.
Open File: after asking if comments should be ignored, and the user agrees, this choice is now remembered and the question is not asked again. This is important for restoring the session.
A file named "Example Pie Chart.csv" is now installed. It is useful for testing the Pie Chart tool.
Histogram: added the ability to change the color of the dataset.
Histogram: added the ability to display a label below the histogram.
When dragging a tab to rearrange them, the tab bar will auto-scroll if the mouse is over a scroll arrow. Also, the tab will not move until the mouse button is released, resolving some odd behavior.
Export JSON: if a column has numeric sorting, then it is exported as numbers rather than strings.
Removed the divider bar above the buttons at the bottom of all windows.
Graph: the "No labels on y-axis" setting has been renamed "No values on dataset 2", and will no longer prevent the axis label from appearing.
Groupboxes now have separate colors for text and border.
Improved the mouse-over effect on the tab bar's buttons.
When choosing a file from the history at the bottom of the File menu, if it does not exist, the error window now contains a "Explore" button that will open File Explorer to that folder.
Updated PCRE2 from 10.22 to 10.40
The Duplicate Row tool now has a hotkey, Ctrl+Shift+I.
Drag column: holding down the shift key will now cause the Copy/Move menu to appear.
The graph, pie chart, and histogram dialogs will now remember the window position.
The "Reopen files from last session" preference is now enabled by default.
Fixed: failed to properly read a CSV cell that contains tabs after the separator, followed by quoted data that contains newlines.
Fixed: the uninstaller was failing to delete several files.
Fixed: the "Column widths: default" tool was not working correctly. It now matches the same method used when the file is opened.
Fixed: a file with space separators was not handling empty columns correctly.
Fixed: Open Nonstandard: if the file is already open, an error is now reported instead of opening the file a second time.

New in CSV Editor Pro 23.0 (May 10, 2022)

Added a tool for generating a Histogram from CSV data.
Added support for Print Preview. The Print Preview window also adds some new capabilities, such as Landscape orientation, customizable header and footer, and adjustable margins.
Added the "Import From Database" tool.
Added to the Options menu tools for resetting the toolbar to two themes, one with text labels and one without.
Set Entire Column: added the ability to perform a mathematical operation on each cell.
Paste Column: there is now an option to paste data starting at the row with focus rather than the top.
Graph: added an optional third dataset.
Graph: each CSV file now maintains a separate set of the settings that appear on the Graph configuration window.
Split Column: added an option that controls if the separator is deleted, left in the source column, or left in the new column.
Graph: added the "Y-Axis Range" option. This allows you to force the Y-Axis for dataset 2 to cover the same range as dataset 1.
Set Entire Column: the dialog now allows the user to choose which column will be affected.
Graph: added the "No Labels On Y-Axis" option for dataset 2.
If there is a single row selected, it can now be deselected by clicking on the cell in the "#" column.
Import From CSV: if the "No Column Names" box is checked, the user can now choose the column mapping as normal. Previously the Column Mapping window would not appear and the mapping was assumed to be in the same order.
Pie Chart: on the second window, added the ability to delete a slice.
Added the "Cell Edits Affect All Selected Rows" preference. When this feature was added in 22.0, there was no option to disable it.
Drag and drop text: when the mouse cursor is near the top or bottom edge, the table will now automatically scroll in that direction.
Graph: split the "Data" tab into separate "X-Axis" and "Y-Axis" tabs. Other settings have been rearranged as well.
Graph: the Top/Bottom/Left/Right labels will now be omitted if unchecked rather than using a default. Previously there was no way to have a blank label.
When the mouse moves over the "#" column, if the row is selected, the mouse cursor will change to indicate that the row can be dragged to a new position.
Spell Check Table: this now reports the total number of misspelled words that were ignored.
A file named "Example Graph.csv" is now installed. It is useful for testing the Graph tool.
Reopen Files From Last Session: this now also remembers the focus order of the documents.
Graph: the active tab is now remembered between sessions.
Shift Column/Row: the meaning of the Pivot Column/Row has changed, it is now the last to be unaffected.
The table's horizontal scrollbar's slide button is now a width that is proportional to how much of the table is visible.
Help: the layout is now tighter. Numerous improvements to the Search tab.
The File menu will now use a smaller font if it is not fitting on the screen.
The Pie Chart tool can now appear on the toolbar, although it is hidden by default.
Fixed: Combine Columns: No Column Names + Delete Source Column: the column names were not being auto-generated.
Fixed a bug that was causing an unnecessary usage of memory in many situations.
Fixed: Destructive Paste: the preview was incorrect if the number of pasted rows was equal to the number of rows in the table, or if pasting on the first row.
Fixed: Print would print a blank page if the filename of the CSV file contained unicode.
Fixed: the Interface Editor was messing up the Skin Elements list if any element was changed.
Fixed: the out-of-memory mitigation mechanism was not working (since 22.0).
Fixed: if "Lock File" is checked, and the file lacks write access, it would refuse to open. It will now open without locking.

New in CSV Editor Pro 22.0 (Nov 4, 2021)

Added the ability to edit multiple rows in one column in one step. First, select the rows that should be modified. Then click on a cell in one of those rows. Type your changes, then click away to any other cell. The new text will be applied to each selected row.
Added the ability to drag and drop multiple selected rows.
Added the ability to duplicate a column by dragging it with the right mouse button.
Added the "Export To JSON" tool.
Filter: Conditional Expression mode: added the "@" operator, which tests for a Regular Expression.
Import From CSV File: this now allows you to specify the file format on a window that is identical to the Open Nonstandard File window. Previously only the Character Set could be specified.
Added the "Close All" tool to the File menu.
Graph: added the option to make the Y-axis labels horizontal. Previously they were always vertical.
Shift Column: added the "Distance To Shift" field, which is the number of cells to shift the column by. Previously it would always shift by 1 cell.
Drag and drop column: when the mouse cursor is near the edge, the table will now automatically scroll in that direction.
The "Lines Per Row" file preference is now remembered for the 100 most recently opened files.
The command line can now specify multiple files to be opened.
Graph: the Lines, Pearls, Diamonds, Curves, and Solid appearances now employ anti-aliasing for improved quality.
Pie Chart: added the ability to specify a title that will appear above the pie chart.
If "Lines Per Row" is > 1, the cell editor will now have a vertical scrollbar.
Clicking on the Pie Chart now takes it fullscreen, just like the Graph.
Undo: added the ability to undo the "Make Sorting Permanent" tool.
Pie Chart: added the ability to change the font.
Pie Chart: added the ability to rearrange the order of the pie slices.
Shuffle Rows: Undo will now restore the original column sorting.
Graph: the numeric values are now localized according to the system's "Region and Language" settings.
Graph: there is now a splitter above the preview.
When choosing a file from the history at the bottom of the File menu, if it does not exist, the error window now contains a "Remove" button that will remove the file from the history.
Create Column: the new column will now be at least an inch wide. Previously it was always just wide enough to fit the column name.
Multiline editor: added the "Duplicate" tool, which duplicates the selection or current line. The hotkey is Ctrl+I.
Graph: the context options have been moved to the Appearance tab.
Graph: the Font field is now controlled by a checkbox.
The tab bar is no longer allowed to have input focus.
The "Don't Export To HTML" option has been renamed to "Don't Export" since it now affects the new "Export To JSON" tool.
Minor visual improvements.
Fixed: drag & drop row: when using the right mouse button to copy, and the target row is below the source, the copy was 1 row too high.
Fixed: when the column to the left of the focus column is hidden, the column divider to the left of the focus column was not being highlighted.
Fixed: Graph: going into fullscreen was not honoring the Font override.
Fixed: when editing a cell and then launching the Graph tool, the Graph Preview was not reflecting the change to the cell.
Fixed: upon launching the Search Column tool, any edits in the current cell were not undoable.
Fixed: "Restore Backup" would fail with an error if the file to be restored was already opened and the "Lock File" option was enabled.
Fixed: when reopening a file that was changed by an external app, if the reopening fails, the file was closing and all changes were lost.

New in CSV Editor Pro 21.0 (Jun 17, 2021)

Added the ability to drag and drop columns to rearrange them.
Graph: there is now a preview of the graph below the settings. The settings are now divided into two tabs to make room for the preview area.
Added the ability to change the number of lines of text that each row will display. For files that have lots of multiline cells, some users may prefer this to the Multiline Editing Mode.
Open Nonstandard File: this now supports opening multiple files at the same time.
Pie Chart: there is now a second window where you can manually customize the pie slice descriptions and colors.
Unicode Character Map: added the ability to select and insert an emoji unicode character.
Filter: the "Conditional Expressions" mode now supports the !~ operator, which evaluates to true if the column doesn't contain a substring.
Undo: added the ability to undo the "Shuffle Rows" tool.
Graph: added the ability to change the color of the datasets.
File Properties: added a new tab named "Content" that reports the number of rows and columns, the row and column with focus, the number of selected rows, and the number of visible rows.
Added the "Caret Position After Vertical Movement" preference.
All tabs are now listed at the bottom of the Window menu.
Paste Column: if the clipboard contains a CSV file, it is now pasted as new columns.
Graph: added the ability to change the font.
Pie Chart: the pie slice values are now localized according to the system's "Region and Language" settings.
Reopen Files From Last Session: this now also remembers which file last had focus.
The "Go To Warning" tool now supports the "Duplicate Column Name" warning.
There is now a "splitter" control between the Multiline Editor and the Warnings.
File Properties: the active tab and window position are now remembered.
The first-time greeting window now has an "Update" button that will install the latest version if necessary.
When closing a tab, the tab that was most recently active now becomes the current active tab.
Reopen Files From Last Session: this now works even when a file to open is specified on the command line.
Minor memory usage and speed improvements.
Added the /new command line switch, which immediately launches the New File tool.
Added the /sep5 command line switch, which indicates the file uses the space as the column separator.
Ctrl+Shift+Tab will now cycle through tabs in the reverse direction.
Multiline editor: pressing the Escape key will now clear the selection.
The Rename Column tool now has a hotkey, Ctrl+Shift+E
When undoing "Dismiss Warning", this will now show the warnings if they are not visible.
Welcome: added a "Remove All CSV Files" tool.
Improved the fade out effect for a tab's X button.
There is now a reported error if the user tries to save a file with an Excel extension.
Fixed: Table Statistics: if the column name contained a tab character, no statistics for that column would appear.
Fixed: the context button on the Graph window was not working.
Fixed: when switching from an ASCII file to a unicode file, the unicode characters in the Filter field could be lost.
Fixed: Alt hotkeys will now work when the Filter has focus.

New in CSV Editor Pro 20.1 (Feb 15, 2021)

New in CSV Editor Pro 20.0 (Jan 10, 2021)

Added the ability to open Excel spreadsheets.
Added support for the space character to act as a separator. This can be chosen on the "Open Nonstandard File" and "File Properties" windows. However, separator auto-detection does not support the space.
Undo: added the ability to undo changes to the File Properties.
Filter: the "Conditional Expressions" mode now supports the ~ operator, which evaluates to true if the column contains a substring.
Filter: Conditional Expressions: multiple expressions can now be chained together with the & or | operators (and/or).
Graph: the X-axis can now represent numeric data. Previously it was limited to dates. In the Date Format field, choose "Numeric".
Graph: it is now possible to specify a date range for the data. Rows having a date that is outside the range are ignored and do not appear on the graph.
Added the "Enter Moves Down" option to the Options menu.
Set Entire Column: added the ability to insert a prefix or suffix into each cell's existing contents.
Pie Chart: added the ability to control the format of the pie slice labels.
Undo: added the ability to undo the "Dismiss Warning" tool.
Copy/Cut Column: added a "Ignore Hidden Rows" options. Previously, hidden rows were always ignored.
Search Column: this now informs you when the bottom of the column has been reached, and asks if you want to resume at the top.
Paste Rows: added support for the pasting of a file.
Welcome: Rename CSV File: this no longer loses the remembered settings for the file.
Added the "Paste Rows: No Mapping If Exact Match" preference.
Added the "Seraph" skin.
Preferences: Character Set: added UTF-7.
Column heading buttons now support the backslash character.
While deleting a large number of rows, undo records are now pruned if the undo memory usage becomes excessive. This avoids an "out of memory" crash.
File Properties: the owner of the file is now reported.
The File Properties tool now has a hotkey, F8.
Search and Replace: when "Prompt on Replace" and "Replace All" are unchecked, the replacement string is now selected. Previously, the caret was positioned at the end of the replacement but it was not selected.
The Escape key will now deselect if there is a selection, and only close the cell editor if there is no selection. Previously, it would always close the cell editor immediately.
Shift Column: the preview table will now obey the "Fixed Width Font" option.
When clicking on a control that is disabled because of an unchecked checkbox, the checkbox will flash briefly.
Set Entire Column: added a "Help" button.
Improved the appearance of the first-time Greeting window.
Fixed: if a file is open in CSV Editor Pro, and the file is deleted externally, and the user closes the file without making any changes, the user was not being asked if changes should be saved.
Fixed: the "Auto-Open Last File" preference was not working. Also, this has been renamed "Reopen Files From Last Session".
Fixed: rarely, balloon help on toolbar icons might not work immediately.
Fixed: after opening a file, the window caption might not dim after switching focus to another app.
Fixed: Graph: if one dataset has the Bar appearances and the other does not, the x-coordinates of the data points were not aligning correctly.
Fixed: Clipboard Inspector: the CSV format was not displaying any content if the clipboard only contains a single column.
Fixed: the "Import From CSV File" tool could not be undone properly.

New in CSV Editor Pro 19.0 (Sep 7, 2020)

The tab bar now has a Close button on each tab, instead of a single Close button on the far right.
Added the ability to open multiple files at one time: hold down the Ctrl key while clicking.
Drag row: there is now a visual indicator of where the row will be moved between.
The "#" column is now a different color to indicate that it is not editable and not in the file.
Preferences: the "Hide Extension On Tabs" checkbox is now a combobox with a third option: "Hidden if .CSV"
The "changed" asterisk now appears on the tab. Previously it only appeared on the caption.
Paste New File: this now supports multiple files.
Spell Check: added a tool for looking up the word in a dictionary.
Added a preference to disable the Secondary Sorting feature.
Undo: added the ability to undo the "Column Widths: Maximize", "Column Widths: Minimize", and "Column Widths: Default" tools.
Print, Export To HTML: added a setting to control the thickness of the outer border.
Undo: when undoing a deleted row, this will also restore any warning that existed for that row.
Insert Date/Time: added the ability to specify a custom date/time format.
Detect External Changes: when the file is reopened, all changes to the column widths and settings are now remembered.
Deduplicate Rows: this now offers to select the duplicate rows. Previously they could only be deleted.
You may now drag and drop one or more files onto the Welcome panel to open them.
File Properties: Character Set: added a "Preview" button that shows what characters are in the character set.
Paste New File: now supports multiple files in the clipboard. This also affects the Welcome panel when pressing Ctrl+V.
Paste Rows: in the "CSV Column" column, there is now an "X" button that deletes the column selection, preventing that column from being pasted.
Split Column: this now ignores rows that are hidden by the filter.
Added a new "Tools" tab to the Preferences window. The "Copy Rows: Ignore Hidden Columns" option has been moved there. The "Don't Confirm Row Deletion" option has been renamed "Delete Rows: Confirm" and moved there. The "Copy Rows: No Column Names" option has been added, although it already appears on the Options menu. Added the "Shuffle Rows: Confirm" option.
After using the Insert/Duplicate Row tool, the row numbers in the Warnings list will now update accordingly.
Multiline Editing Mode: if the focus row is selected, the focus cell is no longer highlighted. Previously, in this situation the user could not see which cell they were editing.
Added the F9 hotkey for creating a new file.
Added the Ctrl+W hotkey for closing the file in the active tab.
File Properties: the Info tab now shows the file's attributes (Hidden, Read-Only, etc).
Detect External Changes: when the file is reopened, it's tab will now remain in the original position rather than moving to the end.
Insert Row: this now allows a single row to be selected. Previously, there was an error if no cell had focus.
Preferences: Character Set: added a help button that takes you to the corresponding article on Wikipedia.
Paste Column: the "First row contains column names" option is now remembered.
Pie Chart: the window that shows the pie chart will now remember its size and position.
Shift Cells: the preview table will now obey the "Fixed Width Font" option.
Pie Chart: added a Help button to the first dialog.
Shift Column: if this tool is run more than once, Undo will now undo the entire series of shifts. This is important for saving memory on large CSV files.
Preferences: the active tab is now remembered.
Paste Column: the new column will now have a minimum width, in case the column name is very short.
Fixed: the Print tool was leaving an empty temporary file on the hard drive.
Fixed: when opening a file where the focus cell is remembered, the caret was never appearing.
Fixed: drag and drop of text was broken when the table was sorted.

New in CSV Editor Pro 18.0 (Apr 17, 2020)

Added the "Shift Column" tool. This allows you to move cells in a column up or down by one row.
Added the ability to rearrange tabs by clicking and dragging them.
Added the "Make Sorting Permanent" tool to the Table menu.
Added the "Save All" tool.
Export To HTML: this now allows the user to specify the font, padding, and cell borders.
Pie Chart: if the Label column contains duplicates, they will be combined into one pie slice.
Undo: changes to the column settings on the Column menu or context menu can now be undone.
Undo: changing the Character Set on the File Properties window can now be undone.
Added the "Tab Name Ellipsis" preference. When a filename is too long to fit on a tab, this determines where it is truncated with an ellipsis.
Paste New File: if the clipboard contains a file rather than CSV data, the file will be opened as if it was chosen in the Open File tool.
Added a "+" button on the tab bar which creates a new file.
Added the "Hide Extension On Tabs" preference.
Welcome: Ctrl+V now supports CSV data in the clipboard. Previously it only a supported a copied file.
Added the Ctrl+Home/End hotkeys, which will jump to the first/last column in the current row.
Graph: when there are two datasets, and both datasets have "Bar" appearance, then the bars will be side by side.
Added the "Copy Rows: Ignore Hidden Columns" preference.
Graph: a "month/year" date format is now supported. Also, "year/month" is supported as long as the year is 4 digits.
Detect External Changes: if the CSV file originally had a Byte Order Mark but no longer does, it is now assumed to be 8-bit ASCII, not unicode.
Table Statistics: this window is now a table of stats rather than a text report.
Added support for dropping multiple CSV files on the window caption.
Export Select Columns: if the export file is later opened, the "No Column Names" option is now remembered.
File Properties: there is now a tab named "Info" that shows some information about the CSV file.
Graph: improved the "Bar" graph appearance.
File Properties: Character Set: added a help button that takes you to the corresponding article on Wikipedia.
Copy Rows: this no longer copies the column names if "No Column Names" is checked.
Shuffle Rows: this now preserves the row selections.
Destructive Paste: the preview now obeys the "Fixed Width Font" option.
Shuffle Rows: this now prompts the user for confirmation since the operation cannot be undone.
Customize Toolbar: it is now possible to force a row-break.
Open File: the Progress Window won't appear until it's taken more than one second to open the file.
Drag-Select will now continue to auto-scroll even if the mouse moves up onto the column headings or down onto the horizontal scrollbar.
The toolbar will no longer lose the user's customization when a new version is installed and new icons have been introduced.
Small reduction in per-row memory usage, allowing larger files to be opened.
The toolbar is no longer visible if no files are open.
Restore Backup: this no longer closes the current file first.
Fixed: Move Column: if "No Column Names" is enabled, the column names were not being recalculated.
Fixed: Shift Cells: the error sound was playing if the dialog was canceled.
Fixed: Destructive Paste: the preview was not populating the "#" column.
Fixed: the Ctrl+Up/Down hotkeys were not working in the multiline editor.
Fixed: right clicking on a column heading and changing the Sort Method was not working if no cell had focus.
Fixed: when a new process is tasked with opening a CSV file, but it finds an existing process to open it in instead, the settings that the file was saved with were not being remembered.
Fixed: Drag-Select: if no rows are selected, they were all becoming selected at the beginning of the operation.

New in CSV Editor Pro 17.0 (Oct 25, 2019)

Added a tool that displays the CSV data as a pie chart.
It is now possible to "drag-select" a range of rows quickly. Move the mouse cursor to the "#" column of the first row. Press and hold the left mouse button. Move the mouse up or down. You will see rows being selected. If the mouse is at the top row, the table will automatically scroll up. Likewise, if the mouse is on the bottom row, the table will automatically scroll down. Release the left mouse button when you have reached the last row that you wish to select.
Filter: the Advanced mode now supports subexpressions enclosed in parenthesis.
The Tabbed Document Interface can now be disabled on the Options menu.
The "Import From CSV File" tool can now be undone.
The "Column Settings" tool can now be undone.
The Row Filter is now remembered for each tab independently.
Export To HTML: added the ability to copy the HTML document to the clipboard. Previously, only the raw HTML source code could be copied to the clipboard, as text.
Print: added the ability to hide the column and row dividing lines.
Graph: added the ability to control the appearance of the second dataset independent of the first.
Detect External Changes: this no longer detects changes for all tabs when the main window becomes activated. Instead, it detects changes only for the current tab, while other tabs will not detect changes until they are selected.
When using Shift+Click to select a range of rows, if there are no selected rows, this will start from the row with focus.
Paste New File: if the clipboard contains characters that are not present in the Default Character Set, the new file will default to UTF-8 instead.
When undoing the Delete Column or Combine Columns tool, the column's Alignment and Sort Method are now recovered.
Preferences: Character Set: added a "Preview" button that shows what characters are in the character set.
New File: the File Properties window that automatically appears now has a Cancel button.
Graph: added the "Diamonds" appearance option.
Export to HTML: added an "Explore" button, and the size of the file is now reported.
Welcome: Recent Projects: added a context menu button.
Copy Column: the "Include Column Names" option is now remembered.
When opening a file or creating a new one, the splitter above the Warnings/Multiline Editor will remember its position from the last file that was closed.
There is now a visible divider between the tabs.
Welcome: Recent Projects: added a "Copy Filepath" tool.
The "Paste New File" tool now appears on the File menu. Previously it only appeared on the Welcome Panel.
The Create Row tool now has a hotkey: Ctrl+Alt+Insert
Import From CSV File: this now moves focus to the first imported cell.
The installer now registers CSV Editor Pro on the "Open With" shell menu for .CSV and .TSV files.
Welcome: if the clipboard contains a CSV file, you can now press Ctrl+V to open the file.
Print: added a "Help" button.
Save As: this no longer allows you to save over a file that is open in another tab.
It is now possible to enter csvedit.exe into the "Run" system dialog (Win+R) without a path.
Fixed: after opening a file, creating a new file, or closing a file, the Multiline and Warnings toolbar icons were remaining highlighted.
Fixed: the "Fixed Width Font" option was not taking effect when opening a file.
Fixed: when undoing the Combine Columns tool, the column's original Don't Print and Don't Export settings were overwriting the next column's settings.
Fixed: Export To HTML: this was specifying width=100 instead of width=100% for the table. This also affected the Print tool.

New in CSV Editor Pro 16.0 (Jun 21, 2019)

CSV Editor Pro now uses a Tabbed Document Interface. It can have multiple files open for editing at the same time. Each opened file appears as a tab below the toolbar.
Filter: Advanced mode: added support for the "|" operator.
The table now supports mouse tilt wheel.
Graph: Appearance: added the "Curves" mode.
The table now obeys the operating system's mouse wheel speed.
Dragging and dropping a file onto the table will now launch the "Import From CSV File" tool.
Graph: the inner box between the data and the labels is now optional, and is hidden by default.
Graph: the "Solid" Graph Appearance now has a dark border along the top, and is a lighter color.
The open/save dialog will now show .TSV files by default without having to switch to "All Files".
Search Column: if no column is selected, this will now display a window that allows you to choose the column, with an alternate option of searching the entire table instead.
Spell Check: pressing the Enter key when the Misspelled Word field has focus is now equivalent to clicking the Change button.
Open Nonstandard File: if the file has a Byte Order Mark, the "Character Set" field is now disabled. Previously it was enabled but ignored.
Destructive Paste: added a Help button.
Graph: the mouse hover balloon has changed from a simple rectangle to a rounded rectangle with a triangular tip.
Table Statistics: the report now supports unicode characters.
Help File: added a chapter on Character Sets.
There is no longer a border around the table.
Fixed: Trim Column Whitespace: the Column field was not supporting unicode column names.
Fixed: UTF-7 was available to the Open Nonstandard File tool but did not appear on the File Properties window.
Fixed: when the column sort method is "Memory", sorting was not tolerating leading whitespace, and the Table Statistics tool was not showing the correct total and average.
Fixed: the Clipboard Inspector could display all zeros in the hex data for unsupported data types.
Fixed: unminimizing on a secondary monitor was moving the window to the primary monitor.
Fixed: error when saving a file to Google Drive.
Fixed: the "2 columns have the same name" warning was displaying garbage for the column name on 8-bit files.
Fixed: Deduplicate Rows: this was not accounting for changes made to the current cell being edited.
Fixed: Help: Print: some hyperlinks were not followed by the page number.
Fixed: rare crash when right clicking on an editbox.
Fixed: Table Copy/Move Mode: this could corrupt non-ASCII characters when editing an 8-bit file.
Fixed: when using both "No Column Names" and "Preserve Comments", the comments at the beginning of the file would be duplicated each time the file is saved.
Fixed: copy/paste could fail if another window has the clipboard open. Now it will retry many times over a brief period.
Fixed: the Character Set setting on the Options menu was not being properly supported by many tools if set to anything other than "System Default".

New in CSV Editor Pro 15.0 (Feb 19, 2019)

Added the "Cell Swap Mode" tool. This enters a special mode that allows you to quickly swap cells. Click on the two cells that you want to swap, repeat as desired, then press Escape.
Save File is now 40% faster.
The "Newline" file property now affects newlines within cell data, not just the newlines at the end of each row.
The "Hidden" column option is now remembered for the 100 most recently opened files.
Print: added the ability to specify the cell padding.
Undo Delete Column: this now restores the Hidden, Don't Export, and Don't Print column settings.
Undo Cut/Delete/Deduplicate Rows: this now restores each row's selection state.
Destructive Paste now ignores hidden columns.
Most windows now calculate their width as a factor of the interface font size. Previously they were a factor of the screen size. This ensures that windows are the optimal size, even when the font is very small or very large relative to the screen.
Visit Hyperlink: this now supports unicode, and is tolerant of HTML encoding.
Added the "Paste New File" tool to the Welcome panel.
Added the "New File Launches File Properties" preference.
Welcome: if the file cannot be opened, the error window now has a "Remove" button that will remove the file from the Recent CSV Files list.
Import From CSV File: this will now recall the Code Page if it was remembered from an earlier save.
Calculator: added the "Convert Units" tool.
Move Column: this will now move past hidden columns.
The "Destructive Paste" tool can now be placed on the toolbar, although it is hidden by default.
Insert Date/Time: added ISO 8601 formats.
Added a button to the bottom right corner of the table that opens the table's context menu.
Increased the undo depth to 25 changes.
Column Settings: if a column is hidden or unhidden, the filter will be automatically reapplied.
Clipboard Inspector: numerous improvements.
Destructive Paste: the preview window now scrolls the focus column into view.
The Welcome Panel is now documented in the help file.
Export Select Columns: if the "No Column Names" File Property is enabled, then the tool's "Export Column Names" option will be unchecked by default.
Undo Cut Rows: the Tools menu will now read "Undo Cut Rows" instead of "Undo Delete Rows".
Split Column: this no longer requires that a column be selected first.
Cut/Copy Column: the OK button is now disabled if nothing is selected.
Welcome: if the Recent Projects List has two projects with the same filename, now both of them will be listed by their full filepath.
Welcome: Delete File: the file is now moved to the Recycle Bin.
Added the hotkeys Ctrl+Alt+Pageup/PageDown which will move a row to the top/bottom.
The Insert Row Above tool now has a hotkey: Alt+Shift+Insert
Warning/Go: this will now scroll to the row so that it is vertically centered.
Fixed: when a duplicate column name is found, there was a mistake in the warning message (ASCII files only).
Fixed: Duplicate Rows: afterwards, the numbers in the "#" column could be non-sequential.
Fixed: Ctrl+Left and Ctrl+Right now work properly across cells.
Fixed: after hiding the column with focus, the multiline editor continued to edit the cell that is now hidden.
Fixed: Check For Update: when installed to a portable drive, installing an update was installing to the hard drive rather than the portable drive.
Fixed: when reopening a UTF-8 file with no Byte Order Mark, it was not remembering that the file was UTF-8.
Fixed: using the left/right arrow keys to move past a hidden column was not working.

New in CSV Editor Pro 14.0 (Oct 18, 2018)

Added the "Undo" tool. This powerful feature can undo the action of any other tool except Import From CSV File and Shuffle Rows.
Writing the Byte Order Mark is now optional. It can be disabled on the File Properties window. When saving after using the Open Nonstandard Document tool, the Byte Order Mark is not written unless it was present originally.
When moving vertically from one cell to another, the caret will now try to maintain its horizontal position within the cell.
Column Settings: it is now possible to edit the contents of the "Column" column if you want to rename a column.
Import From CSV File: it is now possible to specify an alternate Code Page for the file. For example, you can specify UTF-8 for a file that has no Byte Order Mark.
Filter: added an "Auto-Complete" option. This is unchecked by default to match the old behavior.
Search Column: continuing the search will now look for the next occurrence within the current cell. Previously it continued the search in the cell below.
The toolbar can now have more than one row of tools.
Multiline editor: the block selection (Alt+Drag) is now compatible with most editbox tools.
Graph: when using the "Monthly" division, if the data is all in the same year, the x-axis will now display the month name such as "May" instead of "5/18".
When saving, a field that begins with a # is now delimited to prevent the line from being mistaken for a comment.
Spell Check Table: this now reports the total number of misspellings fixed.
The Customize Toolbar window now remembers preferences such as its position and the table column widths.
Added the "Export Select Columns" tool to the File menu. It can now also be added to the toolbar. Previously this tool could only be launched from the table's context menu.
Moved the "Import From CSV File" tool from the Tools menu to the File menu.
Reduced the table's memory usage by approximately 10%.
Welcome: there is now an icon next to the title.
The "Find" tool is now referred to as "Global Find".
Fixed: Cut Columns: in No Column Names mode, the column headings were not being updated.
Fixed: after inserting or deleting a column that occurs before the sort column, the sort was no longer correct.
Fixed: Spell Check Table: the reported number of words spell checked was inaccurate if misspelled words were found.
Fixed: Split Column: when "No Column Names" is enabled, the "New Column Name" field will be disabled since it does not apply.
Fixed: moving to any cell with multiple lines in Multiline Mode was causing the "file changed" flag to be set, even if no changes were made.
Fixed: Search Column: fixed some issues related to Regular Expressions.
Fixed: Cut Columns: when cutting multiple columns, incorrect columns were being cut after the first.

New in CSV Editor Pro 13.0 (Jun 4, 2018)

Global Find/Replace: added support for Regular Expressions.
Added support for 16-bit big endian unicode CSV files.
Filter: added support for conditional expressions, such as "amount < 50".
Added the "Column Settings" tool. This adds the ability to edit the settings for all columns at one time. It also adds a new ability to hide one or more columns.
Added the "Cell Copy Mode" tool. This enters a special mode that allows you to quickly copy cells from one to another. Click on the cell that you want to copy, and then click on the cell that you want to copy it to. Repeat as desired, then press Escape.
Added the "Fixed Width Font" box to the Options menu. If checked, the table data is displayed in a font where all the characters are the same width.
Create Column: added the "Don't Print" and "Don't Export To HTML" options to this window.
Added the "Welcome: Alphabetize Files" option to the Options menu.
The Search Column tool no longer needs to exit Multiline Editing Mode.
Reduced memory usage, allowing for larger files to be opened.
Added the "Regex Tester" tool to the Interface menu.
Rename Column: the error that appears when there are no column names now includes a button that opens the File Properties window where you can enable column names.
Import From CSV File: added support for files that have a 16-bit unicode byte order mark.
Export To CSV File: this now obeys the File Properties, and allows you to change the encoding of the export file.
Paste Column: this now supports a UTF-8 byte order mark.
Print: the first window now has better tools for changing the font. After clicking the Print button, there is now an abortable window that describes what is going on.
Clipboard Inspector: the "CSV" format now properly displays unicode.
Added the /trim command line switch, which overrides the "Trim Cells" option.
Greatly improved the speed at which the "Print" and "Export To HTML" tools generate the HTML file.
The Destructive Paste tool now appears on the Row menu. Previously it could only be activated by Ctrl+Alt+Shift+V.
Help: added the "Rectangle" Selection Mode, which is useful for copying columns of text.
The toolbar's size can now be adjusted by hovering the mouse over it, holding down the Ctrl key, and spinning the mouse wheel.
Numerous skin improvements.
Trim Column Whitespace: added a "Help" button to the dialog.
Help: the "Speak" tool no longer has a verbal pause at the end of each line.
The Preferences window now remembers its position on the screen.
Fixed: Spell Check Table: when spell checking just one row, it was not ignoring numeric and date type columns.
Fixed: function keys were not working if the Filter has focus.
Fixed: Paste Column was not working if the clipboard contained only plain text and the table was in ASCII mode.
Fixed: changing a file from 8-bit to 16-bit or vice versa, then saving the file, was resulting in the comment lines being corrupted.

New in CSV Editor Pro 12.0 (Jan 8, 2018)

Added the "Cell Move Mode" tool. This enters a special mode that allows you to quickly move cells around. Click on the cell that you want to move, and then click on the cell that you want to move it to. Repeat as desired, then press Escape.
Filter: added support for Regular Expressions.
Cell/Multiline editor: Search/Replace: added support for Regular Expressions.
Saving a CSV file is now approximately 5 times faster.
Added the ability to control whether or not cell data is trimmed when a file is opened. Previously, cells were always trimmed, meaning that leading and trailing spaces and tabs are removed. Added a "Trim Cells" option to the Preferences window, which controls the default behavior when opening files for the first time. Added a "Trim Cells" option to the Open Nonstandard File tool. This option is remembered for the 100 most recently opened files.
The Destructive Paste tool now displays a preview window of the pending changes. Previously it blasted your data ready or not.
The "Don't Export To HTML" and "Don't Print" column options are now remembered for the 100 most recently opened files.
Added the "Lock File" option to the Options menu. Use this if you wish to prevent other applications and users from modifying a CSV file while you have it open.
Graph: Capture: Save To File: added support for saving to an HTML file.
Graph: when the Division is "Daily", and the date range is greater than a year, the labels on the X-axis will now display the year.
Added the "Preserve Comments" File Property. Uncheck this box if you want to discard all comments. Check this box if you plan to add comments to the file.
Added the "Unnamed Column Format" preference. Previously, the "No Column Names" option would name columns "A", "B", "C", etc. Now they can be numbered instead.
Paste Columns: if there are many columns in the clipboard, the dialog might not be tall enough to display all of the Column Name fields. Now there is a scrollbar.
Clipboard Inspector: added support for the "CSV" clipboard format.
Added a Search tool to the Welcome panel.
Delete Column: the total number of columns selected is now displayed at the bottom of the dialog.
Split Column: the Separator field is now remembered.
Now supports installation to a path that contains unicode.
Trim Column Whitespace: it is no longer required that a column be selected prior to launching this tool.
Rename Column: this tool now balks if the "No Column Names" option is checked.
Open Nonstandard File: this tool now has a hotkey, Ctrl+Shift+O.
Added a "Speak" tool to the Help viewer.
Export To CSV File: added the "Export only selected rows" option.
The "Print" tool can now be placed on the toolbar, although it is hidden by default.
Filter Settings: added a Help button.
Associate File Type: added a Help button.
Removed the "Default Encoding" field from the Preferences window. The "Character Set" field is now used for new files. Also, Character Set now has options for UTF-8 and UTF-16.
The "Preferences" window now contains tabs as it was getting too tall for some screens.
Added the "Hyperborean" skin.
Fixed: the "Duplicate Column Names" warning was displaying garbage instead of the column name when opening a file in any character set other than "System Default".
Fixed: Destructive Paste was not working correctly when the table is sorted.

New in CSV Editor Pro 11.0 (Aug 14, 2017)

Added support for CSV files that have the Unicode Byte Order Mark (UTF-16 with 16-bit characters).
When no file is open, the window interior is now occupied by the "Welcome Panel". This allows you to choose a recently opened file and launch several tools.
Delete Column: this window now contains a checklist of all the columns, so that you can delete more than one at a time.
Open Nonstandard File: this now allows you to specify UTF-8 or UTF-16 for a file that has no Byte Order Mark.
Preferences: it is now possible to specify that comment lines (beginning with the # character) should always be ignored when opening a file for the first time.
Numerous interface improvements, especially regarding 4K monitors.
Text drag and drop: an excerpt of the selected text is now shown beneath the mouse cursor as it moves. Previously the word "Text" inside a balloon appeared beneath the mouse cursor.
Split Column: it is now possible to specify if the column should be split at the first or last occurrence of the separator.
Column menu: added the "Column Width: Maximize" and "Column Width: Minimize" tools.
Completely empty files will no longer refuse to open.
The table will now only scroll horizontally far enough that the only thing visible is the final column divider.
Trim Column Whitespace: it is now possible to specify which column should be trimmed. Previously it was always the column that contained the cell with focus.
The "Don't Export Or Print" column property is now two separate options.
Added the ability to disable support for multiple lines in the editbox search/replace tool that was added in version 10.0.
Filter Settings: added the "Don't Remember" option. If checked, a history of past inputs is not remembered in the drop-down list.
Warnings now support unicode in column names.
Create column: the Enter key is now a hotkey for the OK button.
While saving, there is now an animated hourglass effect.
Added the "/cp" command line switch, which can be used to override the Code Page (character set).
Added the "/min" command line switch, which will cause the window to be initially minimized.
When applying the Filter and the current row is hidden, this will no longer turn off Multiline Editing mode.
CSV Editor Pro now obeys the "Run" shortcut property, which can instruct the window to be initially minimized or maximized.
Added the "Clipboard Inspector" tool to the Interface menu.
Paste Rows: added a Help button.
Improved file opening speed by 6%.
Upon launching CSV Editor Pro for the first time, the user will now get the chance to customize the skin, font, and interface zoom.
During uninstallation, all associated extensions are reverted to their previous association.
Fixed: when maximized, the window's border could possibly be visible on a secondary monitor.
Fixed: when sorting a text column, dashes and apostrophes are now treated like other symbols.
Fixed: possible window flicker on 4K monitors, or when many System-G windows are open, or when kernel memory becomes scarce.
Fixed: toolbar: the text of the "Filter" checkbox was not always being vertically centered correctly.
Fixed: Copy Rows: unsaved changes to the current cell were not appearing in the clipboard data.
Fixed: Paste Columns: was unable to paste columns immediately after the "#" column.
Fixed: Paste Columns will now work correctly when "No Column Names" is checked.
Fixed: Paste Rows: when the table is in 8-bit character mode, extended ASCII characters were not converting according to the Character Set chosen on the Options menu.
Fixed: if a CSV Editor Pro instance is locked up for some reason, trying to open a file in another instance would cause it to lock up.
Fixed: Table Statistics: the totals for numeric columns were incorrect.
Fixed: when the editbox line spacing is set to more than 1.0, the text in the cell editor was being pushed down.
Fixed: Preferences: the appearance of the table was not correct after changing the "Font Size" setting.
Fixed: double clicking was selecting to the beginning of a word instead of the whole word.

New in CSV Editor Pro 10.0 (Mar 13, 2017)

Implemented a new backup system Added the "Restore Backup" tool to the File menu Backups no longer clutter the same folder as the original file
Added support for installing CSV Editor Pro on a USB drive
Added the ability to specify a secondary sorting column First click on a column heading to set the secondary sort column Then click on a column heading to set the primary sort column Click again on either to reverse the order
Added the "Split Column" tool For example, this allows you to split a "Name" column into separate "First Name" and "Last Name" columns
Multiline editor: Search and Replace: added support for search/replace strings that contain multiple lines
Multiline editor: added support for selecting columns of text Hold down the Alt key while selecting with the mouse
Import From CSV File: this tool now gives you the option to import as new columns Previously it always imported as new rows
New File: the dialog is now identical to the File Properties window Previously, the dialog only allowed you to edit the encoding and separator
The "Ignore Comments" option is now remembered for the 100 most recently opened files
Print: added a Preview tool for the Font Face field
Graph: added a "Hour of Day" division
Preferences: added the Character Set field This determines which character set is used by default when a new file is created, or a new file is opened that has not been opened before
Added a button in the bottom right corner of the multiline cell editor that opens the editbox's context menu
Added the ability to control the width of the Filter field on the toolbar
Added the /com command line switch, which controls the "Ignore Comments" property
The "Don't print or export" option now appears on the Column menu Previously, it was only accessible by right clicking on a column heading
Added "New" and "Open" icons to the center of the client area when no file is open
Create Column: if you specify a column name that already exists, the warning that appears is now possible to ignore
Create Column: when the "No Column Names" file property is checked, it is no longer possible to specify a column name After the column is created, all of the column names will be recalculated Likewise, "Delete Column" will now recalculate all column names
Trim Column Whitespace: it is now possible to trim whitespace from the beginning and/or end of each line in each cell
CSV Editor Pro will now appear on the "Open With" context menu for CSV and TSV files
Associate: added the "TSV" extension to the drop-down list
Insert Row: this no longer produces a "choose a row" error when there is 0 or 1 rows in the table
Added the Filter Settings option to the Options menu
Import From CSV File: added support for import files that contain unicode characters in their filepath
The F1 hotkey (Help) is now supported on the Create Column, Delete Column, and Rename Column dialogs
Graph: added a Help button to the dialog
Preferences: added a Help button next to the Default Encoding field that opens the Wikipedia article on UTF-8
The table's context menu tools are now on the main menu rather than on a submenu
The uninstaller now cleans up the registry a little better
The Filter Mode now defaults to "Advanced"
Fixed: some minor installation problems on Windows Vista/2008
Fixed: Associate File Type: the "Install to 'New' menu" option was not being obeyed when CSV Editor Pro had to be restarted with admin rights to complete the association

New in CSV Editor Pro 9.0 (Oct 24, 2016)

Added the ability for the Filter to act more like a search engine, with multiple keywords, quoted phrases, and negative keywords. To the right of the Filter editbox is a button that opens the Filter settings. Choose the "Advanced" mode.
It is now possible to drag and drop text from one cell to another.
Comment lines (beginning with '#') are now preserved when saving the file.
Added the ability to swap the contents of two cells. Hold down the Alt key and left click on the first cell. Then repeat for the second cell.
When a global setting is changed, it will now be automatically applied to all other running instances. Previously, each instance held an independent copy of the global settings, and the global settings file was completely overwritten when an instance closed. If a global setting was changed while multiple instances were opened, the change would not affect the other instances, and might not be permanent depending on the order that the instances were closed.
It is now possible to right click and drag a row, then choose "Copy" from a popup menu. Previously, dragging a row always resulted in a "Move".
The "No Column Names" and "Backslash Escape" options are now remembered for the 100 most recently opened files. Previously it was necessary to use the Open Nonstandard File tool and enable these options manually.
Preferences: added the "No Column Names", "Delimit All Cells", and "Backslash Escape" options. These only apply when opening a file for the first time, since these properties are remembered for the 100 most recently opened files.
Print: the font face can now be changed.
Most of the tools on the Cell menu can now be placed on the toolbar.
Graph: added the ability to override the labels that are displayed along the X and Y axes.
Graph: added the "Appearance" field to the graph configuration window.
Graph: added a "Day of Week" division.
Trim Whitespace: it is now possible to control if whitespace is trimmed from the beginning and end of the cell. Previously these were always performed. Also, it is now possible to trim whitespace from the beginning of each line in each cell.
Numerous improvements to the Spell Checker. Download the latest version of the Spell Checking Module from Gammadyne.
Added the "Backslash Escape" option to the File Properties window. Previously, it was only possible to choose this setting when opening an existing file, and it could not later be changed.
Added the "Destructive paste: no column names" option to the Preferences window.
Backslash Escape: when this option is checked, carriage returns are saved to the file as "r" and linefeeds as "n".
Drag and drop: there is now an image behind the mouse cursor.
Save Document: the "some characters could not be converted" warning window now offers to switch to UTF-8 and re-save.
Added the /ncn command line switch, which controls the "No Column Names" property.
Added the /be command line switch, which controls the "Backslash Escape" property.
A file's configuration is now only saved if the file itself is saved. Previously, it was saved when the document was closed.
Added a "Help" button to the File Properties window. Added a help file chapter on Drag and Drop.
File Properties: Newline: added a help button that takes you to the "Newline" article on Wikipedia.
Improved the appearance of the table icons.
Delete Column: this window now supports the Enter and Escape hotkeys.
The "Ignore: Export To HTML" column option has been renamed "Don't print or export" since it actually does both.
Customize Toolbar: added a new column that contains an overview of the tool.
Added 32 tools to the System Tools tool.
Fixed: Filter: when applying the filter, and no changes to row visibility occur, the current cell was losing focus.
Fixed: the Filter drop-down list was not remembering entries that were created while an ASCII file was opened.
Fixed: after dragging and dropping a row, the file was not recognized as "changed".
Fixed: incorrect "extra column" warning if the last field in the CSV file is quoted and does not end with a newline.

New in CSV Editor Pro 8.0 (May 19, 2016)

Unicode Character Map: added the ability to create a list of favorite characters.
Open Nonstandard File: when you choose a character set, the file will now be saved in the chosen character set and not UTF-8. You can still change it to UTF-8 on the File Properties window if you like.
Open Nonstandard File: if a character set is chosen, the next time the file is opened, that choice is remembered. This allows you to later use Open File instead of Open Nonstandard File.
File Properties: you may now choose a particular Code Page. Previously you could only choose between ASCII and UTF-8.
Added support for opening files that contain unicode characters in the filepath.
When a file is opened, CSV Editor Pro will now detect what character or characters are used to terminate lines. When the file is saved, this convention will be honored. On the File Properties window, there is a new option named "Newline" where you can alter this.
Added the ability to move an entire row with drag and drop (drag on the cell in the "#" column).
Unicode surrogate pairs are now supported.
Print: added the ability to specify the font size.
Added the "Cell" menu. Previously it was necessary to right click on the cell to get access to these tools.
Added the "Delimit All Cells" option to the File Properties window. If checked, when a file is saved, every cell is surrounded by quotes.
Added a "Destructive Paste" tool. This overwrites cells with the clipboard data, starting at the cell with focus. This tool does not appear on a menu, its hotkey is Ctrl+Alt+Shift+V. Use with care.
Improved file opening speed by 25%. Reduced memory usage.
Added the ability to increase the padding between the rows of the table. Interface Menu > Configuration Editor > Tables > Vertical Row Padding.
Graph: added the ability to specify the title that appears at the top of the graph.
Graph: added a "Yearly" division.
Added the ability to exclude columns from the "Export To HTML" tool.
While tabbing or arrowing through cells, focus will now wrap to the next row. Previously, focus would stop at the left/right edge of the table.
Trim Column Whitespace: added the "Reduce Multiple Spaces" option.
Double clicking on a word to select it will now support non-ASCII letters. Previously this was only supported in UTF-8 files.
Added the "Jump To Row" tool to the Table menu.
Find: if the original search was backwards, Find/Next will continue in that direction. Previously, Find/Next always went forwards.
Spell Check: while the Spell Checker window is visible, the highlighted selection will now flash between light and dark.
Added the Table menu, and moved some options from the Tools menu there.
Added the "/sep" command line switch, which allows you to specify the CSV separator.
Added the "/a" command line switch, which allows you to associate a file type with CSV Editor Pro.
Added the "Sort On Column" sub-menu to the Table menu.
Added the "Current Cell" option to the "Spell Check Table" and "Trim Whitespace" windows.
Rename Column: there is now a warning if the column name already exists. The Enter key is now equivalent to clicking the OK button.
A file can now be dropped on the window caption, causing the file to be opened.
Added a "Help" button to the Trim Whitespace window.
Fixed: Associate File Type: this was not always reporting the existing association, and prompting if it should be changed.
Fixed: rarely, balloon help was not appearing promptly, or not at all.
Fixed: the executable was not signed with a SHA256 certificate, which could cause it to not be recognized as signed.
Fixed: Print/Export To HTML: the characters & and newlines were not being encoded.

New in CSV Editor Pro 7.0 (Jan 15, 2016)

Added the "Print" tool.
Graph: added the ability to display two independent datasets.
Added the "Shuffle Rows" tool.
Added the "Direction" field to the Find And Replace window.
Graph: the "Amount" column is now optional. Instead, the Y-axis can display the total number of rows in each division.
Move Rows Up/Down: this tool can now operate on all selected rows. Previously, the selections were ignored and only the row with focus would move.
Added the "No Column Names" option to the File Properties window. This is useful when you open a file with column names, but want to save it without them.
Graph: negative totals can now be graphed on the Y-axis.
Graph: added the ability to control if the date interpretation is American (month-first) or European (day-first).
Export To HTML: on completion, a popup window will now report the exported size and number of lines, and offer to open the file.
Added support for opening a CSV file by dragging and dropping it on the table, assuming it's empty.
Create Column: added the "Insert After" field.
The "File Properties", "Explore Folder", and "Export To HTML" tools can now appear on the toolbar, although they are hidden by default.
Settings for opened files are now remembered for the 100 most recent, up from 40.
The "Import From CSV File" tool will now ignore comment lines if the first character in the file is "#".
Trim Column Whitespace: there is now an option to trim the beginning, and an option to trim the end (of each cell).
Export To HTML: the target of the export is now remembered.
The Interface menu now has two choices for Character Map: one for ASCII and one for Unicode.
The Unicode Character Map now inserts characters into an editbox located below the character table, where you can either copy them to the clipboard, or insert them into the originating editbox.
Save File As: if a file is open, its filename will appear in the Save dialog so you can edit it or type over it. Previously, the filename was blank.
Insert Row: if the table is sorted, the error popup now has an "Unsort" button. If clicked, the table will become unsorted, then the user will be asked if the row should still be inserted.
The "Trim Whitespace" tool will now ignore rows that are hidden by the filter.
The "Trim Column" tool will now report the total number of whitespace characters trimmed.
The "Customize Toolbar" window now allows you to change the toolbar size.
Open Nonstandard File: Ignore Comments: a warning is now generated that comments will be lost if the file is saved.
Upon launching CSV Editor Pro the first time, the user will be asked if CSV files should be associated.
Improved reaction to launching a tool when no file is open.
A warning is now reported if two columns have the same name.
Fixed: a DLL injection security vulnerability.
Fixed: some pairs of characters, in certain fonts, were displayed too close together.
Fixed: a rare but serious problem could cause a window to render incorrectly.
Fixed: when creating a new file, the "No Column Names" and "Backslash Escape" options were carrying over from the previous use of the Open Nonstandard File tool. They are now reset to false.
Fixed: Find And Replace: the search was not obeying the sorted order of the rows. It was moving through the unsorted order.

New in CSV Editor Pro 6.0 (Jul 21, 2015)

Added the ability to generate a graph from the CSV data.
Improved the appearance of icons. Changed from 8-bit GIF's to 32-bit PNG's. Many icons have been redesigned.
Added the "Export To HTML" tool.
Numerous improvements to pasting/dropping files in the multiline editor. The user is now asked if the file contents, filenames, or filepaths should be used, and how this will affect the editbox's existing contents (insert, append, or replace). Unicode characters in the filepath and/or file contents are now supported.
The alignment of each column is now remembered for the 40 previously opened files.
The "Convert File To UTF-8" tool has been replaced with the "File Properties" tool. This adds the ability to convert a file from UTF-8 to ASCII, and to change the separator character.
Added the "Filter: Whole Word" option to the Options menu.
The "Create Column" window now has a field to set the column alignment.
If the first character of a file is a number sign (#), the user will be asked if comments should be ignored.
If the user tries to move a table row and the table is sorted, they will now be asked if sorting should be disabled. Previously, nothing would happen.
Trim Whitespace: added an option to reduce runs of multiple spaces to a single space.
Paste: added support for pasting non-ASCII characters into an ASCII file so long as the characters are present in the chosen Character Set.
Paste Rows: Column Mapper window: added two buttons that allow you to reset the columns or use the original order.
Paste Rows: if the clipboard contains only one line of text, the "Clipboard Contains Column Names" option will be disabled.
Duplicate Row: this will now operate on all selected rows. Previously only a single row could be duplicated.
Added a "Revise" button to the Find tool's "No Occurrences Found" window.
Added the "Delete Source Column" option to the Combine Columns window. Previously the Source Column was always deleted.
Table Statistics: hidden rows are now excluded from the column totals.
The "Choose Scope" window (used by Spell Check Table and Trim Whitespace) will now remember the last choice.
Unicode Character Map: double clicking on a filter will now take you to the first character in that filter.
Added a Help button to the Shift Cells window.
Fixed: the Alt+Arrow and Alt+Page hotkeys were only working in multiline editing mode.

New in CSV Editor Pro 5.0 (Dec 6, 2014)

Added the "Combine Columns" tool.
The toolbar now has labels under each icon.
Added support for keyboards that generate unicode characters.
Added the ability to set the alignment (left, center, or right) of a column.
Behavior change: the backslash is no longer treated as an escape character, which matches the behavior of Excel. Added the "Backslash Escape" option to the Open Nonstandard File window.
Improved the appearance of the table. The column dividers no longer extend all the way down.
Numerous improvements to the Search Table tool. It is now possible to search in the reverse direction.
Added the "Ignore Comments" option to the Open Nonstandard File window.
Fields with a single quote mark can now be interpreted properly, even though this is technically illegal syntax.
The Shift Cells tool can now operate on all selected rows. Previously, it would only operate on the row with focus.
The Shift Cells tool now allows you to choose the pivot column. Previously, the column with input focus was always used.
Added the ability to change the table's relative font size on the Preferences window.
Added the "Integer/Decrement" and "Integer/Increment" editing tools.
The "Paste Rows" tool now allows you to configure the column mapping when the clipboard does not contain column names, like when rows are copied from Excel.
Added the "Copy Rows: No Column Names" option to the Options menu. This is useful when pasting rows into Excel.
Added the "Filter: Case Sensitive" option to the Options menu.
Added the "Explore Folder" tool to the File menu.
Added the "Copy Extra Data" tool to the Warnings list's context menu. This will copy the extraneous data for the "Row has extra columns" warning.
The sorting of date columns now obeys the user's regional settings with regard to the date format (e.g. 12/31/2014 vs. 31/12/2014).
The "Import From CSV File" tool now handles UTF-8 files better.
Macros now work with window-level hotkeys. Previously, they only worked with editbox-level hotkeys.
Trim Whitespace: added an option to trim spaces and tabs from the end of each line within each cell.
Added the "Warn If Too Few Columns" option to the Options menu.
After pasting rows, the table is now re-sorted.
Save File: fields that begin with a tick mark (a.k.a. single quote) are now quoted.
Paste Rows: the dialog that asks where to paste the rows will now remember the previous choice.
Added the Alt+Delete hotkey which deletes a row. Added the Alt+P hotkey which opens the Preferences window.
Small improvement to the "Open File" speed.
Added a "Help" button to the Copy Column window.
Fixed: in multiline editing mode, it was possible to edit the contents of the "#" column.
Fixed: Paste Column/Paste Row: cells would be merged together if they contain a backslash followed by a quote mark.
Fixed: hang and eventual out of memory crash if the last row has no line-break, and the last column is quoted.

New in CSV Editor Pro 4.0 (Feb 25, 2014)

Added the "Spell Check Table" tool to the Tools menu.
Added the "Convert File To UTF-8" tool to the File menu.
Added the "Cut Column" tool to the Column menu.
Paste Rows: the user is now given the option of pasting above or below the current row, or at the beginning or end of the table.
Improved the "Open File" speed when the table is sorted.
When the file is changed, an asterisk will now appear at the end of the window caption text.
Added the "Hide Index Column" option to the Preferences window.
Numerous improvements to the "Search Column" tool.
The Filter field will now remember past inputs in a drop-down list.
Copy Column: multiple columns can now be copied and pasted into Excel. Unfortunately, to make this work, the clipboard data is now tab separated instead of comma separated.
The "Create Column" window now allows the user to set the sorting method.
Added the "New File Launches Create Column" option to the Preferences window.
Set Entire Column: this tool can now be set to change only blank or non-blank cells. Previously, it always affected all cells.
Added the ability to adjust the font size of the table relative to the interface font size. Right click on the table and open the "Font Size" sub-menu.
After checking the "No Column Names" box on the "Open Nonstandard File" window, if the user renames a column, then saves the file, the column names will now be written to the file.
Behavior change: the "Copy Column" tool now ignores rows that are hidden by the Filter.
The row/column with focus is now remembered for the 40 previously opened files.
Added the "Open File" button to the "A new file must be created first." error window.
Added the F4 hotkey for Bookmark-Return and Shift+F4 for Bookmark-Set.
Added a Help option to the bottom of the Options, Column, Row, and Tools menus.
The "New File" window now has a Cancel button.
Added a Help button to the Paste Column window.
Paste Rows: the table is now scrolled to show as many of the pasted rows as possible.
An example CSV file is now installed.
Redesigned the Default skin. The old skin was renamed "Air".
The synthetic "Row" column has been renamed "#" and is now referred to as the "Index" column. Calling it the "Row Column" was too confusing.
The Table Statistics tool will now report the earliest and latest dates in each date type column.
The "Shift Cells Left" and "Shift Cells Right" tools have now been combined into one menu option. The icon for this tool now appears on the toolbar by default.
Fixed: not all tools were available to be placed on the toolbar.
Fixed: when opening a new file, the table's scrolling was not always resetting to the top.
Fixed: holding down the F2 key could cause the "No occurrences were found" window to appear multiple times.
Fixed: the Copy Column tool was not reflecting changes to the current cell.
Fixed: when creating a new column, and no file is open, the Create Column window would appear twice.
Fixed: when opening a tab-delimited file, if the first cell in a row is blank, it would be ignored.
Fixed: pasting certain invisible ASCII characters (codes 0-31, excluding tabs, line feeds, and carriage returns) would cause the program to hang.

New in CSV Editor Pro 3.0 (Nov 13, 2013)

Added the "Copy Column" and "Paste Column" tools. These are compatible with some other programs, including Excel.
Added the "Open Nonstandard File" option to the File menu. This allows you to open files with no column names, a specific field separator character, or a specific character set.
For large files, greatly improved the "Open File" speed, and the speed at which the table scrolls.
Minor interface improvements.
Added the "Import From CSV File" tool.
The "Copy Rows" and "Paste Rows" tools are now compatible with Excel.
The "Shift Cells" tool now allows you to specify if the entire row is shifted, or just those cells to the left or right of the current cell.
The "Paste Rows" dialog now allows you to specify that the clipboard does not contain column names.
The "Set Entire Column" tool now supports unicode characters.
Added the "Another" button to the Create Column dialog. This speeds up the creation of multiple columns.
Added the "Default Encoding" setting to the Preferences dialog.
Added the Ctrl+Enter hotkey for toggling the Multiline Editing Mode.
Added the Ctrl+Shift+D hotkey for the "Insert Date/Time" tool.
Improved support for non-English keyboards.
When the system launches CSV Editor Pro to edit the same file more than once, instead of opening a second instance of CSV Editor Pro, the first instance will be brought to the foreground.
When using Open File, if the file is already opened in another instance, the user is warned, and offered the chance to switch to the other instance.
Added the "Select All" tool to the Tools menu.
The "Multiline Editing Mode" option is now remembered for the 40 previously opened files.
When double clicking to select a word, now all unicode letters are supported.
After creating a new file, the Create Column tool will launch automatically.
Added a help file chapter on the File menu.
Added the "System Tools" launcher to the Interface menu.
The "Table Statistics" tool now reports the number of visible and hidden rows, and the number of empty cells in each column. Also, this tool now appears on the Tools menu.
The distance that the table's horizontal scrollbar moves is now calculated according to the table's current width.
After product activation, the user is now given the opportunity to download and install a free upgrade to the latest version.
The column title context menu is now alphabetized.
The "Export to CSV file" tool no longer offers to export the "Row" column.
Fixed: when creating a new UTF-8 file, the "Row" column was too narrow.
Fixed: closing the file was not causing the table to redraw.
Fixed: several dialogs were not supporting column names that contain unicode characters.
Fixed: a CSV file with a single column now saves a blank cell as "" so that the line will not be ignored when the file is later opened.
Fixed: file corruption if you start with a UTF-8 file, then begin to open a second file that is ASCII, then cancel the open, then save the original file.

CSV Editor Pro Changelog

What's new in CSV Editor Pro 28.0

New in CSV Editor Pro 27.0 (Nov 14, 2023)

New in CSV Editor Pro 26.0 (Jul 5, 2023)

New in CSV Editor Pro 25.1 (Mar 3, 2023)

New in CSV Editor Pro 24.1 (Sep 8, 2022)

New in CSV Editor Pro 24.0 (Aug 9, 2022)

New in CSV Editor Pro 23.0 (May 10, 2022)

New in CSV Editor Pro 22.0 (Nov 4, 2021)

New in CSV Editor Pro 21.0 (Jun 17, 2021)

New in CSV Editor Pro 20.1 (Feb 15, 2021)

New in CSV Editor Pro 20.0 (Jan 10, 2021)

New in CSV Editor Pro 19.0 (Sep 7, 2020)

New in CSV Editor Pro 18.0 (Apr 17, 2020)

New in CSV Editor Pro 17.0 (Oct 25, 2019)

New in CSV Editor Pro 16.0 (Jun 21, 2019)

New in CSV Editor Pro 15.0 (Feb 19, 2019)

New in CSV Editor Pro 14.0 (Oct 18, 2018)

New in CSV Editor Pro 13.0 (Jun 4, 2018)

New in CSV Editor Pro 12.0 (Jan 8, 2018)

New in CSV Editor Pro 11.0 (Aug 14, 2017)

New in CSV Editor Pro 10.0 (Mar 13, 2017)

New in CSV Editor Pro 9.0 (Oct 24, 2016)

New in CSV Editor Pro 8.0 (May 19, 2016)

New in CSV Editor Pro 7.0 (Jan 15, 2016)

New in CSV Editor Pro 6.0 (Jul 21, 2015)

New in CSV Editor Pro 5.0 (Dec 6, 2014)

New in CSV Editor Pro 4.0 (Feb 25, 2014)

New in CSV Editor Pro 3.0 (Nov 13, 2013)

New in CSV Editor Pro 2.1 (Feb 15, 2013)

New in CSV Editor Pro 2.0 (Feb 15, 2013)

New in CSV Editor Pro 1.1 (Sep 6, 2012)