Easy CSV Editor 4+

Elegant & powerful CSV editor

VDT LABS S.R.L.

    • 4.9 • 293 Ratings
    • $9.99
    • Offers In-App Purchases

Screenshots

Description

Easy CSV Editor is one of the best editors for CSV and TSV 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.

The app is built entirely using the native technologies provided by Apple for the macOS and seamlessly integrated in the environment. That's why you'll 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.

# Core Features
• Open, create, edit & save CSV files even if they are not properly formatted, like don't 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 selection's 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

# Data Detection & Reformatting
• Auto-detect numbers & dates
• Change the format of dates & numbers

# Column Explorer
• 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

# Filter
• 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
• Sort the entire document or selected rows or just specific cells
• Fine tune the sorting by including multiple columns

# Find & Replace
• Find and replace text using a familiar, yet powerful, interface
• For power users there's support for ICU regular expressions (both for find & for replace) but there's 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

# Import & Export
• 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

What’s New

Version 2.46

Improvements
• The contrast of selected cells is improved compared with the non-selected ones. This is true for all appearances supported by the app (light, dark, black).
• Holding option (⌥) key while dragging one or more rows or columns will duplicate them instead of moving.
• You can toggle the visibility of the text box at the bottom of the document window by using Command-Backslash (\) keyboard shortcut.
• The alert which appears when a file is changed externally contains an additional option which, when toggled, automatically applies the selected action ("Keep Version" or "Update") until the file is closed or Easy CSV Editor is relaunched.

―――
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

Ratings and Reviews

4.9 out of 5
293 Ratings

293 Ratings

Plaintext ,

If you deal with CSV data, GET THIS!

I have to work with CSV files from more sources than I can count in preparing bulk mailings. There's nothing else like it, and there's nothing like it anywhere other than the Mac. I've used this for every kind of analysis, troubleshooting, data cleaning, database hacking—everything you can imagine a CSV can be used for. This program chews through massive files like no other. There are NO unexpected gotchas such as spreadsheet programs can present when they make assumptions about data types and conversion. If I could give this six stars, I'd give it another just for the ease of using the Transpose command on enormous data files. Yes, you have to wait for a gigabyte to be transposed, but you'll get a progress report and it WILL get done. And can you believe it? Scripting! Command-line integration!
And then go buy their counterparts for JSON and PLISTs in the "Essential Editors Bundle."

Developer Response ,

Plaintext, thanks for the review, it really made my day! Delighted to hear Easy CSV Editor is working well for you and you appreciate the features available in the app.

greensgod ,

Beautiful and capable

As someone who works with a lot of CSV files, I had been looking for a simple, well-designed viewer/editor like this for ages. Excel is a bloated mess with very poor defaults for opening CSV files. I had been using Tad, an open source equivalent, and it was functional but quite clunky.

Easy CSV Editor nails it. The UI stays out of your way and feels very Mac-native. It elegantly handles all of the basic operations stuff like dragging & dropping a column to reorder it. And it has a lot of smarts – auto-detects delimiter characters, escape characters, line break formats, and preserves all of that on save.

The only thing I didn't love was the default behavior of prompting to confirm format when opening new CSV files. (Understandably cautious, but too much friction for me.) That was easily disabled in the Preferences. This guy thought of everything.

Developer Response ,

greensgod, thank you for your review and rating - I really appreciate! If you think of anything else that could be improved , please let me know at easy.csv.editor@gmail.com

Harry Manassas ,

Everything you need; nothing you don't.

A major problem with most programs that are for viewing and editing .csv files is they make assumptions about data in the file for the purpose of presentation. Things like rounding numbers, re-formatting dates, assuming things are phone numbers when they're not. Easy CSV editor more-or-less presents your data completely unmodified from the source file, with the exception of emails becoming links and the settings you put in for how to read the file. This makes it far easier to work with the data when you're trying to build processes that rely on the data being unmodified.

App Privacy

The developer, VDT LABS S.R.L., indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy.

Data Not Collected

The developer does not collect any data from this app.

Privacy practices may vary, for example, based on the features you use or your age. Learn More

Supports

  • Family Sharing

    Some in‑app purchases, including subscriptions, may be shareable with your family group when Family Sharing is enabled.

More By This Developer