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: Though extraordinarily subtle, this is not an actual working license. Also, you’ll want to make sure you’re on the right version. If you buy a license after May 2023, it will be a version 2 license. Version 2 licenses work on version 1.3.36, but not any older version. Make sure you upgrade. In rare cases, copying […]

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 […]

Using Excel for CSV files is like using Word for developing code. You could do it if you like suffering and mostly program in Malbolge, but for everyone else, it’s just the wrong tool for the job. Let’s first cover the main functionality Excel has that Modern CSV does not: Figure plotting Formulas Macros Pivot Tables Individual cell formatting (font, color, etc.) Embedding pictures, videos, etc. As a general spreadsheet tool, Excel is great when you need these things, but it’s a poor tool for dealing with CSV files. Here are the main complaints people have about it: Automatically formats […]