topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Monday September 20, 2021, 9:14 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: What are some good free CSV editor programs?  (Read 701 times)

CarmeloLabadie

  • Participant
  • Joined in 2021
  • *
  • default avatar
  • Posts: 1
    • View Profile
    • Donate to Member
What are some good free CSV editor programs?
« on: July 21, 2021, 05:31 AM »
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?

rjbull

  • Charter Member
  • Joined in 2005
  • ***
  • default avatar
  • Posts: 3,149
    • View Profile
    • Donate to Member
Re: What are some good free CSV editor programs?
« Reply #1 on: July 27, 2021, 03:15 PM »
Review this DonationCoder thread:  Looking for Standalone CSV Editor like CSVPad

Some editors can deal with CSV files, e.g. EmuraSoft's EmEditor, but only the payware version of EmEditor, not the free one.
« Last Edit: July 27, 2021, 03:38 PM by rjbull »

flamerz

  • Supporting Member
  • Joined in 2011
  • **
  • Posts: 151
    • View Profile
    • Donate to Member
Re: What are some good free CSV editor programs?
« Reply #2 on: July 28, 2021, 05:23 PM »
Grab Rons editor. It's soooo great. Not expensive.

dnm

  • Charter Member
  • Joined in 2005
  • ***
  • default avatar
  • Posts: 25
    • View Profile
    • Donate to Member
Re: What are some good free CSV editor programs?
« Reply #3 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?
-CarmeloLabadie (July 21, 2021, 05:31 AM)
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.
« Last Edit: August 06, 2021, 12:03 AM by dnm »