Modern CSV is a CSV file editor and viewer with analysis capabilities. I’ve worked hard to incorporate new features and cosmetic enhancements to improve your experience even further. I am now thrilled to present version 2.1. You can download it here: Windows Installer (EXE) Windows Portable (Zip) macOS (DMG) Linux (Tarball)   Changes Major Features Import JSON and XML files. Export to JSON and XML. Pivot Table (Premium Business) Minor Features Select Entire Row(s)/Column(s) (Header Excluded) commands. Increment/Decrement numerical values via mouse drag. Use the middle mouse button to click on a cell with a number. Drag it and hit […]

And I think you’ll love it. I focused on several areas: Improved UI and user experience Faster performance Useful features Updated documentation For Mac users, Native Apple Silicon (ARM – M1, M2) compatibility If that’s all you need to know, you can buy a license here. Or if you already have a version 1 license, you can upgrade here. For those that need more details, here you go. Improved UI and User Experience There are two areas of the user interface that I aimed to improve for usability: Preferences and File Metadata. I also added several new themes and a […]

This article answers the question that man has wrestled with since the days when fire was considered cutting edge tech- how to create CSV files to handle all the data. One way is to open a plain text editor and start typing. Another way is to use a CSV editor like Modern CSV. Finally, you can export a CSV file. By way of example, I’ll use WooCommerce, a popular e-commerce platform for WordPress. I’ll cover how to export a CSV from WooCommerce, build a product list in Modern CSV, and import the modified CSV back into WooCommerce. What is a […]

To sort a series of strings, you need a way to compare two strings to determine which is “less” and which is “more”. The lesser one comes before the greater one (or in an descending sort, after). Modern CSV uses a combination of numerical and lexicographical sort. Here is a super professional looking flow chart to show how it works: Lexicographical Sort Lexicographical sort is ill-suited for sorting numbers. If you have a series of numbers, say 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, and you apply a lexicographical sort, it’ll come up 1, 10, […]

If you’re having trouble with your license key, this blog post is for you. The main thing to check is that you’re copying the entire block, not just the hash (32 random characters) at the end. Here’s what the license manager should look like: Also, you’ll want to make sure you’re on the right version. If you bought a license on or after May 24, 2023, it will be a version 2 license. Version 2 licenses work on version 1.3.36, but not any older version. If you have a version 2 license, make sure you get the latest version here. […]

I’m a huge fan of some of the best text editors out there- Sublime Text, Atom (RIP), and Visual Studio Code. I even used them to code up Modern CSV. I felt there should be a similarly great text editor specifically for CSV files. Of course, you can use them to edit CSV files. In fact, they each have plug-ins specifically for CSVs. However, they still can’t overcome the fact that straight text editors really are not equipped to handle columns. On the other hand, Modern CSV handles columns just as well as rows. Here are three characteristics these text […]

Why would you ever want to transpose a CSV file? One good reason is that CSV files usually have their records arranged in rows and they sometimes have wide columns. That means you have to do a lot of horizontal scrolling if you want to view the fields in a single record. That’s annoying. One remedy is to transpose the whole CSV with the Transpose Table command. The default keyword is ctrl+alt+t. The records are now arranged in columns with the fields shown vertically. Rather than showing just a few at a time, you can view dozens at a time. […]

Most CSV editors assume that the first row of your table will be your data headers. That assumption often holds, but not always. I’ve come across many CSV files where the first few rows are metadata and the data headers are several rows down. For instance, I used to work in industrial automation programming PLCs (Programmable Logic Controllers). These are computers that control the equipment in factories, buildings, oil and gas pipeline stations, etc. I often exported program data to CSVs to quickly make changes and import them back in. Here’s what a typical CSV looks like. Obviously, we want […]