Easy CSV Editor is one of the best editors for CSV and TSV files youll find on the market.
In a clean and user-friendly interface it offers simplicity and flexibility to edit both small and large documents.
The app is built entirely using the native technologies provided by Apple for the macOS and seamlessly integrated in the environment. Thats why youll feel right at home from the moment you open the app.
We greatly value your privacy, so everything you do in the app is done locally, nothing leaves your computer. No analytics, no servers, no phoning home. You can even use the app when you have no internet connection.
• Open, create, edit & save CSV files even if they are not properly formatted, like dont have the same number of fields in each row
• Data preservation - your data remains unchanged, just like you expect, including numbers with leading zeroes
• Auto-detect CSV format, while providing you the option to adjust the detected parameters
• Progress indicator along with a time estimate when loading huge files
• Visualize & change the properties of an opened CSV document
• Detect CSV comment lines & treat them differently
• Easily navigate in the document using well established shortcuts (check "Help -> Keyboard Shortcuts" for all of them)
• Copy, cut or clear a group of cells or entire rows or columns
• Set as header rows up to 10 rows & up to 10 columns as header columns. Choose if they stay frozen or not.
• Resize rows & columns so you can easily see the whole content of the cells
• Hide rows & columns
• Drag & move entire columns or rows
• Autofill by dragging the right corner of the selected cells
• Move cells by dragging the selections margins
• Shuffle selected cells by row
• Text transformations for the selected cells: trim, enclose, HTML escape/unescape & more
• Fill the selected cells using text of your choice
• Find duplicate or unique data
• Merge or split the selected cells or columns
• Split documents by number of rows or document size
• Status bar at the bottom of the window, showing various statistics & calculations
• 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.
• Full support for Undo & Redo
• Print
• Support for tabs
• Dark mode
• A lot of options available in the Preferences to make the app look & behave exactly the way you want
• Auto-detect numbers & dates
• Change the format of dates & numbers
• Provides a compact interface which lets you explore & manage the columns from the document in a very easy & intuitive way
• Drill down to get more statistics for those columns which are of interest to you
• Focus on the very specific data that you want to check by using the powerful filtering capabilities existing in the app
• Filter by multiple columns & choose from the many rules which are available
• Save & (re)load the filter rules - handy when you want to apply them to multiple files with the same structure
• Sort the entire document or selected rows or just specific cells
• Fine tune the sorting by including multiple columns
• Find and replace text using a familiar, yet powerful, interface
• For power users theres support for ICU regular expressions (both for find & for replace) but theres also support to search for built in patterns (i.e. email addresses, phone numbers or web addresses)
• Choose where to search: in the entire document or specific columns, rows or cells
• Export CSV as: Excel files, Markdown, HTML, XML, JSON, PLIST
• Import CSV from: Excel files, XML sources (local files or remote URLs), RSS feeds, JSON data, HTML tables in web pages, tables in (Multi)Markdown files, .vcard files, macOS Contacts
• Import & Export is available as an in-app purchase, but a trial is available for free
For more info & screenshots please visit https://vdt-labs.com/easy-csv-editor
