Daily Bits Email

The email you entered is already receiving Daily Bits Emails!

Modern CSVDiscount

Modern CSV

View and Edit CSV Files

v1.3.36 Mac & PC  Download Trial
Platforms: Windows 8+ and macOS 10.14+
Modern CSV ScreenshotOther Utilities Software ScreenshotModern CSV, Other Utilities Software ScreenshotModern CSV, Software Utilities ScreenshotOther Utilities Software, Modern CSV Screenshot

If you think that Microsoft Excel is the only way to view and edit CSV files, well, think again! Now there’s a faster, more effective way to handle your CSV files with today’s discount software promotion, Modern CSV!

Modern CSV is the ultimate CSV editor and viewer for Windows, Mac, and Linux users. With Modern CSV, you’ll be able to easily move columns, duplicate rows, and split cells, including working with multiple rows, columns, and cells at the same time. You can also take advantage of a powerful Find/Replace feature, filters, and the ability to manually hide rows and columns.

Best of all, Modern CSV offers keyboard shortcuts for nearly all commands, plus the ability to make your own shortcuts. With its Read Only mode, you can start viewing CSV files up to 11 times faster than Microsoft Excel!

The Conversation
The Fine Print
Expand All Email Updates Load 4 Older Comments
Dan P One of the best pieces of software I've purchased from Bits Du Jour. Highly recommended if you're in need of a CSV editor.
Mar 23 2023 at 3:03am Copy Link
naveed Can you do any math like summing a column?
Mar 23 2023 at 9:54am Copy Link
Evan User This version does not. Version 2 with a business license will do some math and statistics operations on columns, including summation. I don't have a release date, but it will be in the near future.
Gallium Digital - Mar 23 2023 at 2:04pm Copy Link
Henry User I have a delimited document, that is 6.5 gig in size, has 20 million records and 47 fields.Each record is a different person.

I am using a computer with up to date Windows 11 and plenty of memory and disk space.

To my surprise, Moden CSV was able to load and display it. It started by telling me that, due to the size of the document, it would be read only. It took a few minutes to load.

I knew that a certain last name appears in the document about 25 times. So, I did a search of that field for that last name. About 30 minutes have elapsed and the rotating window circle just keeps rotating without any movement away from the first record.

Can you tell us:

1. What does read only mean in this context? I always thought it only meant that the data could not be changed.

2. What are the practical limitations of Modern CSV with regard to file, record and field size?
Mar 23 2023 at 2:41pm Copy Link
Evan User 1. In read-only mode, rather than loading the file into memory, the app indexes it and reads it straight off the disk. I enabled a few features that aren't "read-only" strictly speaking. These are sort, hide, and filter.

2. In read-only mode, memory usage is approximately 20% of the file size. It loads the file faster, but sort, filter, and find operations run slower than edit mode.

In edit more, memory usage is 3 to 4 times the file size. It's a bit slower to load, but all the operations are faster.

Assuming you have enough memory, it can handle up to 2 billion rows and columns (2,147,483,648 to be exact). For all intents and purposes, there are no limits to field sizes. People have had several MBs in a single field.

For a 6.5 GB file, if you have 20 to 25 GB free, that might be the better way to go.

If you're searching for just last names, you can select the entire column. Then, in the Find pane, enable the "Match Only in Selected Cells" button (2nd from the right). That way, it will only search that column rather than the entire file.
Gallium Digital - Mar 23 2023 at 4:25pm Copy Link
fpi fpi PFOJ Enterprises LLC is an the American author of Modern CSV, but who is Gallium Digital ?
Mar 24 2023 at 3:00am Copy Link
Evan User I recently switched corporations, so PFOJ Enterprises no longer exists and it's now run under Gallium Digital. I apologize for any confusion.
Gallium Digital - Mar 24 2023 at 6:15am Copy Link
Henry User As far as I can tell., this program is very good for viewing and editing delimited data. files and for searching for the presence of words within files. It can also sort and replace.

It does not perform calculations and does not provide for printing or for the creation of macros that will check or reorganize data.

What it does do, it does well and can do so for huge files.

If I have oversimplified it, perhaps Evan can describe it further.,
Mar 24 2023 at 11:26am Copy Link
fpi fpi @Evan User, thanks for the explanation.
But Concerning "Gallium Digital" no details or existence, seems available on the Web.
No mailing address.
Finally, are you the genuine developer ?
Mar 25 2023 at 2:16am Copy Link
MK Good grief: two seconds on the Modern CSV website and found they reference Gallium in their license:
Mar 25 2023 at 6:36am Copy Link
Richard Blake Can a v1.x personal license purchased through BdJ be upgraded to a business license when v2 is released?
Mar 25 2023 at 1:34pm Copy Link
Evan User @fpi fpi If it helps, the website is (As you can see from the site, I don't anticipate much traffic there). Yes, I'm the developer.
Gallium Digital - Mar 25 2023 at 5:16pm Copy Link
Evan User @Richard Blake Yes, licenses bought here are eligible for discounted upgrades, the same as those bought directly from the website. Version 2 will have updated documentation, although most of it will be the same style - more graphics/gifs than words. I find that people (myself included) don't like to read a bunch of words, so I try to get to the point as concisely as possible. I will redo some of the outdated graphics including the transpose commands.
Gallium Digital - Mar 25 2023 at 5:23pm Copy Link
Evan User @Richard Blake To answer your question about the transpose commands, they flip the data so rows become columns and columns become rows. One works on the entire table and the other works only on the selected portion of the table. I'll make sure that's clearer in the new documentation.

Edit: I just remembered I made a blog post about transposing:
Gallium Digital - Mar 25 2023 at 5:35pm Copy Link
Gary User I purchased this in December of 2022. 6 months later they come out with a ew version and want $39 to upgrade. Needless to say I've removed it from my computer and will look elsewhere for a similar program.
Jul 29 2023 at 5:37am Copy Link
Tim Parsons @ Gary User the upgrade price seems to be $39 only if you want the business licence. The personal license upgrade is half that, and v1 of the software seems extremely capable as it is.

For what it's worth, I think you'll struggle to find a competitor, feature for feature. Like you, I'm a bit disappointed that we missed out on the upgrade just by a couple of months, but the upgrade policy wasn't sprung on us by surprise.
Jul 29 2023 at 8:07am Copy Link

Other Utilities Deals

The iStabilizer Dolly: Easily Take Studio Quality Smartphone Video (Mac & PC) Discount
Mac & PC
The iStabilizer Dolly: Easily Take Studio Quality Smartphone Video
Smooth Panning & Tracking Shots on Your Phone
Veshort Url Shortener (Mac & PC) Discount
Mac & PC
Veshort Url Shortener
Increase Conversions Using Short, Trackable Links
iLike (Mac) Discount
for Mac
System Maintenance for Your Apple Devices
LogFusion (PC) Discount
for PC
Real Time Log Monitoring, with Customizable Highlighting
Like BitsDuJour on Facebook
BitsDuJour is for People who Love Software
Every day we review great Mac & PC apps, and get you discounts up to 100%
Follow Us
© Copyright 2024 BitsDuJour LLC. Code & Design. All Rights Reserved. Privacy Policy