CSVEditor 2 for Pc

It’s clear that whoever wrote this app expected every CSV to be perfectly formatted, with every row having the exact same number of columns. At least for me, that’s never the case. The CSVs I work with may have only 4 values in the first couple of lines and 20 in the next few. There may be empty rows to separate blocks. This application won’t allow that. As soon as you load a CSV that isn’t a perfect square block of data, it refuses to edit anything until you convert it into a block with hundreds of unnecessary commas. The result is that every time I edit one of my custom laid out CSVS with this app, I then have to load it into a text editor to clean out the extra commans and add back the blanks rows. If all of your CSV data is in perfectlty formatted blocks, this may be the perfect app for you. I do find it annoying that it has an enormous default size for the cells, so if you’re working with a lot of numbers and small amounts of data in the cells, you’ll have to tell it to resize the columns every time. (It does have a menu option for that, I just wish it were default.) But if you’re like me and your CSVs do have a level of formatting to them with blanks rows and rows with different numbers of columns, make sure you also get a goot text editor to clean up all the commas this app will force into your file.

This is a simple app, but that is what I needed. It is incredibly iritating to have a program like Excel, Pages, or Libre Office import csv files then I spend a bunch of time manipulating the data and then when I export the data back to a csv I find that these programs have completely botched the csv format. It is for this reason that this simple app shines. I like tools that do basic functions and do them well. This is it for csv. I have to manipulate files from 10,000 to hundreds of thousands of records. I have only tried this app on files of 25,000 records and smaller so I am not sure if it will scale up to a million records or higher, but I can say it handled 25,000 records quickly and efficiently on my Macbook Air. It imported quickly and reported what it thought were inconsistencies. I color coded those inconsistencies and I think it did a great job and trying to help me, but my files were fine. Still, I agree that some areas of my csv files could have been a problem. This app does what it does well, but it should do more. The one thing I would like is search and replace on a single column. I work with sensitive information and I would like to take one column and do lots of scrambling to obfuscate it. I did love finding that I could completely replace the contents of a column to one text value and then fill it again with a sequential number. That was a good workaround. This app could do more, but it does what it does without surprises. I like it!