« on: August 05, 2021, 11:46 PM »
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?Hello there,-CarmeloLabadie (July 21, 2021, 05:31 AM)
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:
- CSVed by Sam Francke: https://csved.sjfrancke.nl/index.html
- Runtime Table by Kostas "Bad Sector" Michalopoulos: http://runtimeterror.com/tools/table/
- CSVFileView by Nir Sofer (NirSoft): https://www.nirsoft.net/utils/csv_file_view.html
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.
- Spread32 by Bye Design (Stephen Bye): http://www.byedesign.co.uk/
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.
- Textplorer by Moosware (Henry Kellner): http://www.moosware.net/Textplorer/
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.