10

Expanding on several questions asked 10 years ago on Stack Overflow, I'd like to elaborate what's the best CSV Viewer Editor in 2021.

What makes a good viewer (for me):

  • Displays CSV in Grid view, not as plain text (as it would be in Notepad++)
  • Has CSV centric features, like skipping the first x rows, define headers, etc.
  • Allows editing of the file
  • Allows advanced searching and find / replace
  • Bonus: Allows advanced editing like column splitting, date / locale transformations, filters, ...
  • Saves the CSV without additional whitespace
  • Handles different codecs well (UTF-8, ANSI, ISO, different line endings, etc) and allows conversion
  • Is open source!
  • Runs on Windows (for me) or is cross-platform
  • Probably more, feel free to suggest features.

Software I have looked into:

  • CSVed (powerful, but really slow and old)
  • "Edit CSV" Plugin for VS Code (nice, but sometimes a bit notchy)
  • Excel (urgs)

Old questions:

1
  • 1
    Welcome Harper! The title of your post was for a CSV viewer, but the contents of your post indicated an editor. I've adjusted the title accordingly. Again, welcome! Aug 30, 2021 at 23:07

4 Answers 4

5

I like OpenRefine.

According to the documentation :

OpenRefine is a Java-based power tool that allows you to load data, understand it, clean it up, reconcile it, and augment it with data coming from the web. All from a web browser and the comfort and privacy of your own computer.

TSV, CSV, *SV, Excel (.xls and .xlsx), JSON, XML, RDF as XML, and Google Data documents are all supported. Support for other formats can be added with OpenRefine extensions.

The latest stable release of OpenRefine 3.4.1, released on September 24, 2020. The first beta release of OpenRefine 3.5, released on May 29, 2021.

Not sure for all functions.

  • [✓] Displays CSV in Grid view, not as plain text
  • [✓] Has CSV centric features, like skipping the first x rows, define headers, etc
  • [✓] Allows editing of the file
  • [✓] Allows advanced searching and find / replace
  • [✓] Bonus: Allowes advanced editing like column splitting, date / locale transformations, filters, ...
  • [✓] Saves the CSV without additional whitespaces
  • [✓] Handles different codecs well (UTF-8, ANSI, ISO, different line endings, etc)
    • [?] and allows conversion
  • [✓] Is open source! OpenRefine is licensed under the BSD license.
  • [✓] Runs on windows (for me) or is cross-platform It's availaible on Linux, MacOS and Windows.

Probably more, feel free to suggest features.

  • [✓] regex search
1
  • 1
    This is not exactly what I was looking for, but instad so much more. I've been looking for a simple viewer, but this tool is a powerhouse for data cleaning, which I previously did in Excel Powerquery or Pandas. I'll definetly give this one a closer look, thank you for the recommendation.
    – Harper
    Sep 1, 2021 at 11:41
3

AlternativeTo.Net lists a bunch of alternatives to CSVed but they all seem to be VERY VERY unmaintained/outdated.

Since you mentioned Notepad++, There is a maintained plugin for it called CsvQuery

Although you specified a GUI application, in case a command line solution might interest you, you can use PowerShell's built in ConvertTo-CSV and ConvertFrom-CSV which might be useful, as well as an interesting command line too named csview

1
  • 1
    The NP++ plugin is really interesting, I'll keep that one. A shame that it can't alter the files, but looking at it is sufficient, most times.
    – Harper
    Sep 1, 2021 at 11:29
1

LibreOffice would check all your boxes I suppose.

4
  • Specifically, LibreOffice Calc, the spreadsheet. Aug 31, 2021 at 14:27
  • 1
    Doesn't Calc have the same problems as Excel? For instance, formatting numbers based on the locale and not displaying the plain text? In Germany, we use a "," as decimal sperator and a "." as thousands seperator, this is often a problem when dealing with non-localized sql-exports...
    – Harper
    Sep 2, 2021 at 6:54
  • 2
    LibreOffice Calc allows specifying the separators when importing a CSV, as well as other option like e.g. single or double quotes to delimit strings. In addition it has various other global formatting options. I suggest trying it with your specific use case, as I have no idea what issues you consider blocking or not.
    – Sebastian
    Sep 2, 2021 at 19:08
  • @Sebastian I had tried for a few days to find solution to my problems with Excel and its likes when trying to sort my lines by the size of resistors on my list (it's clueless with prefixes and decimal points it seems), and it was almost impossible without using some complex formulas from the net, plugins or scripts. I figured if Excel and its likes were finished products, they should have had these capabilities built-in without requiring the user to learn complex math and programming. That's why I'm also looking for something specific for sorting CSV file lines. Sep 10 at 5:47
1

Just found these:

  1. https://www.tadviewer.com/ which links to a github page here https://github.com/antonycourtney/tad ; MIT License; screenshot:

tad screenshot

  1. https://kothar.net/csview with source code linked at https://bitbucket.org/mikehouston/csview ; seems to be Java as it distributes .jar for Linux ; screenshot:

csview screenshot

1
  • 1
    Just a quick heads-up for anyone who might come across this in the future: These are both PURE viewers with zero editing capabilities.
    – MaxD
    Jun 2 at 20:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.