April 27, 2023

Modern CSV 2 is now available.

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 […]
July 22, 2021

How to Create CSV Files (WooCommerce CSV Import Example)

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 […]
June 5, 2021

Modern CSV’s Sort Algorithm

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, […]
May 27, 2021

License Issues

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 […]
March 18, 2021

A Text Editor for CSV Files

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 […]
March 12, 2021

Transpose CSV Files

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. […]
February 15, 2021

Leading Zeros in Excel vs. Modern CSV

Everyone knows that disappearing leading zeros in Excel is a problem, yet Microsoft never bothers to address this. It is a giant headache, but Modern CSV will never ever ever do that to you, promise! Here are some visual aids with bad fake data. Excel hides leading zeros Modern CSV always shows them Leading zeros in all their glory (oh yeah, plus Modern CSV has a dark theme, which Excel doesn’t because Excel is old). Adding leading zeros in Excel Now, what if you want to add leading zeros in Excel? Say, every number should be 10 digits long and […]
January 23, 2021

Editing PLC-exported CSVs with Flexible Data Headers

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 […]
December 6, 2020

Why Excel Sucks and Modern CSV is Awesome (at least for CSVs)

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