I deal with CSV files all the time. I have been using excel, but it's not really made for csv's. Is there a program out there that deals with just csv's and data shaping?
-CarmeloLabadie
Hello there,
This happens to be topical to me for a few reasons, so here's some options I'm aware of that I've used, which may or may not be what you're looking for:
CSVFileView isn't really an interactive editor, in terms of e.g., being able to interactively edit individual cell values, etc. However it does provide a lot of ways to interactively manipulate data in CSVs (like reordering columns and rows, sorting, and saving everything or selected subsets, etc.) as well as a lot of options to save in other formats, like TSV, HTML, XML, JSON, and so forth. Also, be sure to check out the wealth of command line options and switches for batch operation too.
Similarly, this next one, Spread32, isn't CSV-specific, but as a minimalist Excel compatible (to some extent) spreadsheet, it can serve as a handy, lighter-weight option to Excel. I often do a lot of minimalist "use a spreadsheet as a table" style of note taking and small-scale editing in Spread32 and save as either CSV or Excel (XLS) depending; I can always export to CSV for shipping to others or for use in other apps.
Finally, one more suggestion might be Textplorer, which is a text editor that also has support for "structured" text/data files, which can be setup to work with CSVs (as it can be set to work with delimited files). It can be a little unclear on how that support works, you'll have to read through what little documentation there is and fiddle with examples, but it does work.
Hope this helps. Let me know what else you find if you come across other options, and what your experiences are if you try any of the above.
