The Ultimate CSV Editor/Viewer for Windows, Mac, and Linux
Edit CSV Files with Ease
Why should it be difficult to move a column around, duplicate a row, or split cells? With Modern CSV, editing is easy.
With most commands, you can operate on multiple rows, columns, or cells at once. Need an entire column to show the same string? Just select the whole column and start typing. Need to delete several rows at once? Simply select them and delete. You can call most commands with a keyboard shortcut.
Find and Arrange Your CSV Data
The Find/Replace feature has all the options you need to find what you’re looking for. It can also highlight matches as you type or preview Replace operations before you do them.
If you need to sort a column, double click the column label. Need a descending sort? Just double click again. You can even sort horizontally by double-clicking on row labels.
Filters use a powerful syntax that is clearly described in the filter query. You can also manually hide whichever rows or columns you want.
View Large CSV Files Quickly
Modern CSV is not only a powerful CSV editor, it’s also a power CSV viewer. It comes with a read-only mode that loads large files quickly and with a small memory footprint just a fraction of the file size. In fact, it can load up to 11 times faster than Excel. Furthermore, Excel can only read about 1 million rows. Modern CSV can read billions.
A CSV Editor That’s Customizable to Your Needs
We designed Modern CSV to be comfortable to use. For the keyboard ninjas, we gave most commands keyboard shortcuts that you can set to your liking. For an easy CSV viewing experience, you can set the theme (light or dark), change cell sizes, shade every other row or column, or set the text size and font. You can also tell it how to handle files of different extensions. Do your .csv files have semi-colon delimiters in Windows-1252 (Western European) (aka ANSI) character encoding? You can have it open and save accordingly every time.
- Multiple delimiters supported (TSV, PSV, TAB, etc.)
- Multiple character encodings supported (UTF-8, UTF-16, ISO 8859, Windows-125x, CJK)
- Delimiter Auto-Detect
- Drag and drop files or folders
- Freeze header rows/columns so they’re always visible
- Auto-refresh when files are edited externally (optional)
- RFC 4180 compliant (optional)
- Fuzzy search for all commands and files
- Drag and drop cells, rows, or columns
- Handles poorly formatted files
- Convert date/time formats (Premium feature)
- Transpose entire tables or segments of a table (Premium feature)
- Text case conversion (Premium feature)
- Duplicate, rename or delete files from within the program (Premium feature)
What Our Users Say
“An indispensable tool”
I have been using Modern CSV for more than a year now and, as a data scientist in Digital Humanities, I could not live without it.
The ubiquitous open data exchange format is CSV. Excel and LibreOffice Calc are capable to read and save CSV data, but they reach their limits very fast — mostly when dealing with big amounts of data. This is precisely where Modern CSV has carved its niche: dealing with vast amounts of CSV data, transform them fast, and extract them to another data set.
An indispensable tool, highly recommended.
“… the most consistent and wonderful experience.”
Having tried almost every CSV editor I could find, Modern CSV by far gives the most consistent and wonderful experience.
If you’re a programmer (who uses keyboard more often), you will be happy to find out there is a quick access to the command list you can type in and the ability to customize every shortcut, which makes editing so blissful.
“… superbly designed and highly functional”
Sometimes, “more” is not “better”.
Over the years, I’ve often had to deal with tables of data, I’ve used many different programs to deal with them, including Microsoft “Excel”, Open Office “Calc” and even Libre Office “Calc”; they all work – sort of, anyway.
They’re all large, “Swiss Army Knife” solutions. Kind of like using a handgun to kill a mosquito.
Earlier this year, I was drafted into yet another project where I had to edit and organize a large amount of textual data, and those “big programs” kept corrupting the data by adding their own information.
In frustration, I searched (again!) for a better solution for working with files of “comma separated values” and I stumbled on Modern CSV.
There was a trial available, so I gave it a try, especially since they have a FREE version.
It was amazing! It did pretty much exactly what I needed, although there were a few things that would have made my job easier, so I sent a note to the Evan– a feature request.
If I remember right, he responded the very same day, and my request was added to the next version. It does what is needed better than anything else I’ve ever seen.
While I had not reason to buy a license (the free version did what I needed), I strongly believe in acknowledging work that is above and beyond the expected. Modern CSV certainly did that, and the license wasn’t prohibitively expensive, so I bought one – my way of saying “Thank You” to Evan.
If you deal with CSV files, try this program. It is superbly designed and highly functional, with a small system footprint.
– Rob W.
“I can recommend this tool for everyone working with CSV files on a regular basis.”
I came upon ModernCSV when looking for a better altenative to Google Sheets/Apple Numbers for CSV editing. Modern CSV is a specialised tool for the job and it don’t try to interpret/format data from the file. You see what you get. I can recommend this tool for everyone working with CSV files on a regular basis.
– Torben S.
“… an impressive array of features.”
An incredibly useful program!
Let me tell you some highlights: I like how a Selected Column can be filtered with the selected cell content. This can even be adjusted with a custom shortcut to a one keystroke action! There are many useful other actions like ‘Remove Empty Columns’ or ‘Remove All Filtered Out and Hidden Data”. Other extraordinary tools offer unexpected abilities: E.g. applying ‘Filter Selected Row’ on the header row filters the columns only with the field name pattern searched for. When selecting the header row, ‘Sort Selected Row – Ascending’ sorts all data according to ascending field names. Sorting generally is great and does everything intuitively correctly. These are only a few highlights of an impressive array of features.