<< back

Easy CSV Editor 2.53

Editor for CSV and TSV data files

Category: Productivity
Price: Low
Popularity: Low
Version String: 2.53 (154)
Release Date: 2024-09-10
Architecture: Intel & AppleSilicon(ARM)
Minimum OS: macOS 10.13
Vendor Name: Vlad Badea
Homepage: [Mac App Store]

Version History 2.53 (154)

Improvements
• The app now considers as line separators only the characters Carriage Return (U+000D) and Line Feed (U+000A). In the previous versions, other more "exotic" characters were considered as line separators, too: Vertical Tabulation (U+000B), Form Feed (U+000C), Next Line (U+0085), Line Separator (U+2028) and Paragraph Separator (U+2029). This change brings the app more "in line" with other apps (i.e. Numbers, Excel, Google Sheets).
• "Save As" panel now includes an option which allows the header rows to be saved or not in the new document.
• For the users who purchased "Import & Export" there are additional formats available under "Copy As" menu. These are: Markdown, XML, JSON and PLIST.
• Fill-ing a series of dates (either by dragging the corner of selection or by using autofill) now better matches the behavior of Numbers, Google Sheets and Excel.

―――
If you enjoy Easy CSV Editor and find it useful, please also consider Easy CSV Editor Mobile, the sibling app specifically made for iPhones and iPads.
We constantly want to improve the quality of our apps. For any feedback, questions and ideas please contact us at easy.csv.editor@gmail.com

Description:

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.

KEY FEATURES

• 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!
• Resizable rows and columns so you can easily see the whole content of the cells.
• Set up to 6 rows as header rows. Choose if these header rows stay frozen or not.
• Sort the entire document or a range of rows, based on multiple sorting rules.
• Find duplicate (or unique) data from your documents.
• Merge or split the selected cells or entire columns.
• Split documents by number of rows or document size. This is available from 'File -> Split...'.
• Hide rows and columns.
• Autofill by establishing a pattern from the selected cells, and if no pattern can be determined then simply repeat the selected cells.
• 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.
• Find lets you configure where in the cells' text to look for matches: 'Contains', 'Equals To', 'Starts With' and 'Ends With'.
• Find also lets you search for special patterns, some of the supported ones being 'empty cells/fields', 'emails', 'URLs', 'phone numbers'.
• 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-detect CSV format, while providing you the option to adjust the detected parameters.
• Copy, cut or clear a group of cells or entire rows or 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 the left, it shows various statistics about the selection or document. 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.
• A big, resizable, text box located above the status bar showing the content of selected cell. You can edit the text in this box, too. Use Command + Enter shortcut to quickly put the focus in this box.

OTHER FEATURES

• Customize the CSV properties when the document is saved.
• Quickly visualize and change the properties of an opened document - just hit Command + I or 'Inspector' button in the toolbar.
• Drag & Move entire columns and rows.
• 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, column headers, footers and line numbers.
• Print - among other things you can customize if the column headers and line numbers are printed or not.
• Full screen support.
• Tabs support on macOS Sierra 10.12 and above.
• Dark Mode support on macOS Mojave 10.14