Comma Separated Values (CSV) files are plain text files that store tabular data. Each row of the document represents one of the table rows, and each comma separated value the fields of each row. Commas are not the only separators supported though. You may also encounter tabs, pipe symbols or semicolons for instance.
The biggest advantage of CSV files in comparison to other tabular data files like Excel xls files is that the format is widely supported. A basic example would be most Nirsoft applications which support exporting to CSV but not to Excel.
Excel and other spreadsheet applications support CSV files. Why would someone need a CSV editor then if the file format is supported by programs like Excel or Open Office directly? Easy; CSVed, the CSV Editor, offers more than just displaying the CSV data in a table on the screen.
CSV Editor is offered as a portable version and installer for the Windows operating system. The program interface may look intimidating at first, as it displays a huge number of editing options right on screen.
CSV files are loaded via the File > Open menu or Load button. It is furthermore possible to create a new blank file and fill it with data. The program displays the data of the currently loaded CSV file in a table in the upper half of the interface. A column and row selector is available on the left side to quickly display specific rows or columns on the screen.
A double-click on a row opens all fields of that row in an editor for quick editing. It would be handy if the developer would add direct editing to the program though to speed things up a notch.
A search is provided to find specific values. It is possible to search a specific column. Here it is furthermore possible to find and replace text.
The majority of editing options are displayed in the lower half of the interface. The options are separated into tabs that are packed to the brim. Lets take a closer look at some of the provided options:
Start and Item Edit
Join and Split
CSV Editor has a lot more to offer. It can for instance check and repair CSV files. The option is available under the Tools menu in the program. It will automatically check the currently loaded CSV file for errors and notify the user about errors that were found. Helpful if a CSV file is not loading or importing properly in another program or application.
The Edit menu links to additional tools. Here it is possible to remove blank lines and leading or trailing spaces from the CSV file.
Additional CSV files can be appended or merged with the active file. This option is available under the File menu.
The interface is customizable. It is possible to move toolbars around and change it significantly, both directly and in the Options.
CSVed can export the data sets into HTMl, Excel, Word or XML files.
Users who are looking for a tool to manage and edit CSV files effectively will find CSVed mighty useful. While it is possible to use other programs like Excel for most of the options offered by CSVed, it is usually not as easy to do that in those programs.
Advertising revenue is falling fast across the Internet, and independently-run sites like Ghacks are hit hardest by it. The advertising model in its current form is coming to an end, and we have to find other ways to continue operating this site.
We are committed to keeping our content free and independent, which means no paywalls, no sponsored posts, no annoying ad formats or subscription fees.
If you like our content, and would like to help, please consider making a contribution:
Ghacks is a technology news blog that was founded in 2005 by Martin Brinkmann. It has since then become one of the most popular tech news sites on the Internet with five authors and regular contributions from freelance writers.