With a great deal of skepticism, I downloaded the “free trial” and fired up the editor.

This time, though, SEO worked its magic and ModernCSV came up on the first page. I was loathing the idea of starting a project with this ETL system, and I googled “CSV editor” as I had a thousand times before expecting only disappointment. I found a terminal-based editor, but its keybindings were beyond my comprehension and I frequently destroyed my CSV files. Plaintext editors are a nuisance and I end up playing “count the commas”. Excel and other spreadsheet programs just mangle CSV format. I can chew through 100s of GB of data without batting an eye.īut hand-editing individual rows in CSV files has _always_ been a headache. I can slap together pipelines using xsv, perl, sed, csvkit, awk, grep, and countless other CLI utilities in my sleep. The CSV files varied in size from a 10s to 100s of rows, each one needing to be lovingly entered by hand.

I inherited an ETL system that used a set of CSV files to “program” the ETL process.

For mac download CSV Editor Pro 26.0