Filling and incrementing (or decrementing) cells in spreadsheets and editors can be cumbersome. Some programs require you to use laser-like precision to click a tiny little square on the corner of the cell, use clumsy formulas, or manually type in values. I strive to make the process as easy as possible in Modern CSV. Here are four approaches you can use to fill cells and increment or decrement their values. Middle-mouse button click dragging When I first developed Modern CSV version 1, I thought it would be cool to use the middle mouse button to click on a cell, drag […]

Modern CSV version 2.3 has several improvements: UUID/GUID Generation JSON and XML Import Performance A bunch of bug fixes You can download it here: Windows Installer (EXE) Windows Portable (Zip) macOS (DMG) Linux (Tarball) UUID/GUID Generation The command is called Fill Selected Cells with UUID/GUID. You can then decide whether they’re upper or lower case and whether they’re contained in braces or not. The default option is lower-case without braces. It also comes with a global setting called UUID Type. The two options are: Random (v4) Time-ordered (v7) In a nutshell, Random (v4) UUIDs look truly random and they mostly […]

Since UUIDs (Universally Unique Identifiers) are so common in databases, Modern CSV has the ability to add them to cells by using the Fill Selected Cells with UUID/GUID command. UUIDs are randomish sequences of 32 hex numbers divided into fields by - characters. An example is 7104f0c7-99a0-40e1-b255-b2bd37b74fac. The number of hex values by field is 8, 4, 4, 4, 12. When calling the Fill Selected Cells with UUID/GUID command, you can decide whether they’re upper or lower case and whether they’re contained in braces or not. The default option is lower-case without braces. It comes with a global setting called […]

In addition to paid versions, Modern CSV has a free version. My goal in designing the free version was to make it functional and not just a de facto trial for the paid versions. Many users have used the free version for years. To quote one user talking about Modern CSV on Reddit: I mean, I’m all for supporting software unless their free version is *exactly* what I need. Goal accomplished. Look at the video running on the home page. This is the video I use to give visitors a strong first impression of its capabilities. Most of the features […]

Modern CSV is a tabular file editor with powerful editing features, large file viewing, and analysis capabilities. Now, with version 2.2, it has print and PDF export capabilities. You can download it here: Windows Installer (EXE) Windows Portable (Zip) macOS (DMG) Linux (Tarball) In addition to the standard printing options (printer, margins, page size, etc.), it has options specific to CSV files: Printer row/column headers on each page Print row/column labels on each page Vertical/horizontal gridlines Center it vertically/horizontally Order the pages row-wise or column-wise Print the file title or page numbers on each page It can also limit the […]

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