The Ultimate CSV Editor/Viewer for Windows, Mac, and Linux
Modern CSV is a powerful tabular file editor and viewer for Windows, Mac, and Linux. Professionals at all levels of technical proficiency use it to analyze data, check files for uploading to databases, modify configuration files, maintain customer lists, and more. We designed it to compensate for the deficiencies of spreadsheet programs in handling CSV/TSV/DSV/etc. files. We strive to create a user experience our customers describe as “blissful”.
Edit CSV Files with Ease
Why should it be difficult to move a column around, duplicate a row, or split cells? With Modern CSV, it’s easy.
With most commands, you can operate on multiple rows, columns, or cells at once. This makes repetitive actions effortless.
Most commands have a keyboard shortcut. If a command doesn’t have one or you don’t like the default, you can make your own 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. It uses stable sort so the order of the other columns is preserved as much as possible.
Filters use a powerful syntax that is clearly described in the filter query.
Finally, you can manually hide whichever rows or columns you want. All you have to do is select and call the hide command.
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.
A CSV Editor That’s Customizable to Your Needs
We designed Modern CSV to be comfortable to use. For an easy CSV viewing experience, you can set the theme (light or dark), change cell sizes, or shade every other row or column.
For the keyboard ninjas, we gave most commands keyboard shortcuts that you can set to your liking.
You can also tell it how to handle files of different extensions. Do your .csv files have semi-colon delimiters in ANSI (Windows-1252, Western European) 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)
- Multiple line endings supported (CRLF or LF)
- 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 groups of cells, rows, or columns
- Handles poorly formatted files
- Save results of filtering, sorting, etc. into separate 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)
Get useful tips and updates in your inbox.
What Our Users Say
“I could not live without it.”
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.
“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.
“A powerful editor”
I have been using Modern CSV editor for several months. It performs the editing that I need. What I need is true editing, e.g. move columns or rows of data or select data that I am looking for. It is powerful enough to turn poorly written letters to proper acronyms. It can also select data you need to keep and remove data you don’t need. For example: a column has both numbers and letters, you want to keep the numbers and eliminate the letters. These features are examples of its many tools. I could provide many more examples, however the best description is: it is a powerful EDITOR of a CSV table/spread sheet.
“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.