Easy CSV Editor
Mac OS Productivity
Easy CSV Editor is one of the best editors for CSV and TSV data files you'll find on the market. In a clean and user-friendly interface, it offers simplicity and flexibility to edit both small and large documents.
• Open, create, edit and save CSV & TSV documents even if they are not properly formatted, like don't have the same number of fields in each row!
• Sort the entire document or a range of rows, based on multiple sorting rules.
• Merge or split the selected cells or even entire columns. Multiple options lets you configure how the merge or split is performed!
• Fill the selected cells using text of your choice.
• Find and Replace text using a familiar, yet powerful, interface.
• Find and Replace is supported in the entire document as well as in selected columns/rows/cells. To search in your desired range you right click on the selection and choose "Find in" menu item or click the "search" image in the find bar and then access the options from "Find In" submenu.
• Find also lets you configure where in the cells' text to look for matches: "Contains", "Equals To", "Starts With" and "Ends With".
• Use "Clear" menu item to "cut" the last fields from a row (or even entire rows!). This way you can produce beautiful documents, without the usual clutter produced by the in excess field separators.
• Auto-detection of CSV format, while providing you the option to adjust the detected parameters.
• Select a group of cells to copy, cut or clear. This is in addition to selecting entire rows and columns!
• Full support for Undo & Redo.
• Copy & Paste data between Easy CSV Editor and other applications (i.e. Excel, Numbers). Works the other way around, too!
• Text transformations which allow you to cleanup and beautify your documents.
• Customize the font used to display the CSV data. You can even increase or decrease the font size per document window (from "View" menu). These changes are persisted between application relaunches!
• You can configure, from "Preferences" -> "General" tab, whether or not you want to be prompted for CSV input properties each time you open a file that has been opened before. If you choose to not be prompted then the application will use the last known properties for that file to open it.
• Status bar at the bottom of the CSV window. On left, it shows the following: number of rows, columns and cells, either for the entire document or for the selection. Also shows the number of cells which are empty and nonempty. On the right, it shows a calculation performed on the selected cells. You can choose one of the following calculations: Sum, Average, Min, Max, Count Numbers.
• Customize the CSV properties when the document is saved.
• Quickly visualize and change the properties of an opened document - just hit Command + I or tap "Inspector" button in the toolbar.
• Use first row from the CSV as table's header.
• Drag & Move entire columns and rows.
• Select a range of columns or rows by clicking the first column/row header in the range, and then hold down Shift key while you click the last column/row in the range.
• Change the width of individual columns by dragging the column separators.
• Double click the column separator so the column to the left to resize its width to fit the content.
• Add rows or columns, via existing shortcuts or menu items, to the left/right/up/down of selection.
• Insert copied rows/columns above or below the selection.
• Quickly jump to a row (Command + L).
• Quickly jump to the cells which are selected (Command + J).
• Quickly move, via existing shortcuts or menu items, to document's left/right/top/bottom margin.
• Preferences - among other things you can change the visibility of gridlines, headers, footers and line numbers.
• Print - among other things you can customize if the headers and line numbers are printed or not.
• Full screen support.
• Tabs support (macOS Sierra and above) - hit Command + T to create a new tab in the current window.
• Fixes a crash introduced by the previous update of the application, which happened when opening a CSV document.
Introduced in Version 1.19
• Adds support to transpose the rows and columns. This action is available from "Table" -> "Transpose Rows and Columns" menu item.
• Performance is greatly improved when performing a "Replace All", especially when dealing with tens (or hundreds) of thousands of replacements.
Introduced in Version 1.18
• Enables the selection of non-consecutive rows or columns. Just like other popular editors, simply use Command key to include (or exclude) rows or columns in the selection.
• Adds support to select every nth row or column from the document. This action is available from "Edit" -> "Selective Selection..." menu item
• Adds one more action you can perform on the matches of the Find. This is "Select All Rows Containing Matches" and is available in the find bar (Command + F), by clicking the gear/cogwheel button.
Introduced in Version 1.17
• Fixes an issue where sorting is not working as expected if the cells in the columns you're sorting on contain negative numbers or floating point numbers.
• Fixes an issue where the text from the status bar moves to the right of when you try to copy it.
Introduced in Version 1.16
• Fixes a crash which happened when opening a CSV document which has only one row and that row is set as the header of the CSV.
• Fixes a crash which happened when setting a row to be the header of the document and that row is the only row from the CSV.
Introduced in Version 1.15
• Adds a status bar to the CSV window.
• The left text from the status bar shows the following information: number of rows, columns and cells, either for the entire document or for the selection (when you have selected more than one cell). It also shows the number of cells which are empty and nonempty.
• The right text from the status bar shows a calculation performed on the selected cells. You can choose from the following calculations: Sum, Average, Min, Max, Count Numbers. This calculation is shown only when you have more than one selected cell in the document.
• Both the text from the left and the one from the right are selectable, so you can easily copy and paste the information in other places.
• Adds two more actions you can perform on the matches of the Find: "Cut All Rows Containing Matches", "Copy All Rows Containing Matches". These actions are available in the find bar (Command + F), by clicking the gear/cogwheel button.
Introduced in Version 1.14
• When opening a document, the columns are resized in a way that reasonably accommodates the text from them.
• When double clicking the separator of one of multiple selected columns then all selected columns are "resized to fit content". This is just like Numbers does.
• Fixes a crash which rarely happened when splitting the columns.
• Fixes a wrong behavior which happened when splitting the columns.
Introduced in Version 1.13
• Column resizing is now an undoable operation. Additionally, similar to Numbers, resizing a column won't mark the document as "edited".
• Adds a blue border around the cells which are being edited.
• Fixes a rare issue which caused a white blank rectangle to appear after editing a cell.
• A cell which is being edited is now properly positioned and resized when resizing a column.
Introduced in Version 1.12
• The cells containing numbers are now right aligned. This is especially helpful because decimal points would line up.
• Merges "Paste and Fill Selected Cells" command into "Edit" -> "Paste". As a result, Easy CSV Editor now behaves just like Numbers or Excel when pasting something in a single cell or multiple selected cells.
• The Inspector side tab now opens inwards, so the size of the window no longer changes. This matches the behavior of many other applications.