Open Source Java CSV Software

jdbc2csv is a small command-line tool written in JAVA and can be used on all platforms, for which JRE 8 or higher is available. To connect to a specific DBMS the tool uses its JDBC driver. The result of the executed 'select' query is displayed in CSV format ( different standards are supported ). When there is an error the tool stops with exit code 1 and the error message is output on stderr. jdbc2csv is created with a main purpose to be used in shell-scripts. Relatively easy to configurate, this tool is suitable for queries ‘select’, ‘update’ and ‘delete’. I think that is not suitable for a large number of requests, like 'insert'.

Super CSV is a fast, programmer-friendly, open-source library for reading and writing CSV files with Java. PLEASE NOTE: As of January 2015 we have now moved to GitHub (https://github.com/super-csv/super-csv). This SourceForge page will remain, but with limited functionality (please go to GitHub to report issues and for project downloads). It is highly configurable, and supports reading and writing with POJOs, Maps and Lists. It also has support for deep-mapping and index-based mapping with POJOs, using the powerful Dozer extension. Its flexible 'Cell Processor' API automates data type conversions (parsing and formatting Dates, Integers, Booleans etc) and enforces constraints (mandatory columns, matching against regular expressions etc) - and it's easy to write your own if required. Super CSV is actively maintained, and the developers are ready and willing to help out if you get stuck :) Please check out the project website for examples and help getting started

CSV Comparator is a tool for comparing files which contain CSV-Data. It was created for performance engineers to be able to have a easy way to compare data from two testruns and be able to automate the comparing process of various files with scripts. There is a command line tool as well as a user interface. In case you need to compare .xml-Files you can convert them to .csv-Files with my other project CSV Transformer. The advantages by using CSV as input and output are the following: - Many applications allow an export of its data to CSV or Excel(were it could be saved to CSV) - It is possible to pre- and postprocess the data, e.g removing version numbers before comparing - It is easy to create CSV data from logfiles and other resources by using unix tools like sed or awk - CSV can be loaded into other applications, especially Excel, were it can be formatted by macros for analyzing.

This software allows for a user to generate test data. This is useful for testing Hadoop or other data processing clusters.

xml2csv is a small command-line tool written in JAVA and can be used on all platforms, for which JRE 8 or higher is available. Examples: 1. Help java -jar xml2csv-1.0.jar --help 2. Extract nodes from xml: java -jar xml2csv-1.0.jar --nodes test/cd_catalog.xml The result is the full node name and number of repetitions: /CATALOG=1 /CATALOG/CD=26 /CATALOG/CD/TITLE=26 /CATALOG/CD/ARTIST=26 /CATALOG/CD/COUNTRY=26 /CATALOG/CD/COMPANY=26 /CATALOG/CD/PRICE=26 /CATALOG/CD/YEAR=26 3. Convert all xml nodes to csv java -jar xml2csv-1.0.jar test/cd_catalog.xml 4. Convert xml to csv, like extract only nodes /CATALOG/CD/TITLE, /CATALOG/CD/ARTIST, /CATALOG/CD/PRICE in format PostgreSQLCsv java -jar xml2csv-1.0.jar -f PostgreSQLCsv -o '/CATALOG/CD/TITLE, /CATALOG/CD/ARTIST, /CATALOG/CD/PRICE' test/cd_catalog.xml

Map CSV records to Java Objects and back again (a la hibernate).

JFling provides tools for (un)marshalling fixed length string data to and from java objects with typed properties. It's codegenerator uses plain csv files to generate fixed-length-string wrapper classes. (see our wiki 'Hosted Apps/Trac' for more info)

Omni is a Java package for reading and writing a variety of data file formats. Currently, Omni supports formats such as CSV, tab-delimited, pipe-delimited, and fixed-width files. There are future plans for more formats.

This projects has the intent to take any file that has a header and any number of lines, take out the blank lines, the carriage return and the line feed, given as delimitation the "project number" format and generates a new clean file.