Categories
OS X Product Reviews Tips Uncategorized

Quickly Edit CSV Spreadsheets With Easy CSV Editor

What is the Easy CSV Editor?

The Easy CSV Editor is a powerful text editor designed specifically for CSV/TSV tables and spreadsheets. Besides editing, it can also sort, find, find and replace, filter, and much more.

The Easy CSV Editor is not a spreadsheet program. It performs no math functions.

The Easy CSV Editor is for Mac OS X, and is available at the App Store. Quite a bargain at $6.99.

Easy CSV Editor – Video

Features

• Filter the content of the document using a multitude of filtering rules.
• 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.
• Sort the entire document or a range of rows, based on multiple sorting rules.
• Find duplicate (or unique) data from your documents.
• Split documents by the number of rows or document size. This is available from “File…Split”.
• Set up to 10 rows as header rows and 10 columns as header columns. Choose if these stay frozen or not.
• Resizable rows and columns so you can easily see the whole content of the cells.
• 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 the 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, and cells.
• Find lets you configure wherein 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 the “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 that allow you to clean up 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 the “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 the selected cell. You can edit the text in this box, too. Use Command plus Enter shortcut to quickly put the focus in this box.
• Customize the CSV properties when the document is saved.
• Quickly visualize and change the properties of an opened document – just hit Command plus 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, and up 0r down of selection.
• Insert copied rows or columns above or below the selection.
• Quickly jump to a row (Command plus L).
• Quickly jump to the cells which are selected (Command plus J).
• Quickly move, via existing shortcuts or menu items, to document’s left and right, or top and bottom margin.
• Preferences – among other things you can change the visibility of gridlines, column headers, footers, and line numbers.
• Print.
• Full-screen support.
• Tabs support on macOS Sierra 10.12 and above.
• Dark Mode support on macOS Mojave 10.14

Here is a link to the free Symphytum database I have been using with the Easy CSV Editor. Click HERE.

Special Thanks

Music: Superepic by Alexander Nakarada / https://www.serpentsoundstudios.com
Music promoted by https://www.free-stock-music.com
Attribution 4.0 International (CC BY 4.0)
https://creativecommons.org/licenses/by/4.0

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.