Open Source Java CSV Software

A read-only JDBC driver for Java that uses Comma Separated Value (CSV) files as database tables. Ideal for writing data import programs and conversion programs.

Editor for both Csv files and Fixed width files. There is automatic attribute detection for single record Csv Files. You can edit Fixed Width file and Multi-Record Csv / Fixed width files using a Xml Schema. There is also limited editing available for Xml and PO files.

provide Java Record based IO routines for Fixed Width (including Text, Mainframe, Cobol and Binary) and delimited Flat files via a Record Layout (Cobol, CSV or XML). The source is now available at https://github.com/bmTas/JRecord Projects using JRecord include: * https://github.com/thospfuller/rcoboldi - Cobol File in R * https://github.com/tmalaska/CopybookInputFormat - Cobol files in Hadoop * https://github.com/gss2002/copybook_formatter * https://github.com/gss2002/ftp2hdfs has some code that allows ftping RDW files directly from the Mainframe into Hadoop/HDFS as a mapreduce job or standalone client.

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

This converter bridges from the .ahn file format into GEDCOM 5.5.1, It's a command-line tool written in Java. AhnConvert allows family data, laboriously grabbed decades ago surviving into state-of-the art genealogy software products. The software "Familien Chronik" by Reiner W. Dudde was a genealogy software published by Data Becker as part of the "Goldene Serie" series, back in the 1990's. Especially in Germany this tool penetrated the market to some extent. Generating a project and filling in all relatives and ancestors resulted in an .ahn file. Unfortunatelly, this format cannot be imported by any of the current genealogy software. On the other side, GEDCOM can be read without problems by most of today's programs.

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.

Simple Java delimited and fixed width file parser. Handles CSV, Excel CSV, Tab, Pipe delimiters, just to name a few. Maps column positions in the file to user friendly names via XML. See "FlatPack Feature List" under News for complete feature list.

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

CSVboard is a tool for loading CSV files with minimum effort. Since I placed a great importance on its easy of use I implemented a search and filtering engine which provides you with the facility to efficiently find specified rows within a table. DON'T FORGET TO READ THE QUICK TUTORIAL!! Features: Lightweight and portable Set and reset title with Ctrl+q and Ctrl+w Auto-set column widths Auto-detection of delimiters Load files by Dragging&Dropping XML export Powerful search and filtering engine CSVboard was written in Java and JavaFX and actually it is a result of some recycled code collections. I experimentally developed during my time as a hobby programmer. So if you find any dysfunctionalities, errors, bugs, or the like do not hesitate to contact me. I'm further going to publish my code at Github in the near future so that everybody has the chance to improve my code.

Simple tool for converting CSV file. You can easily change file encoding, escaping or separator character. You can split the file into more smaller files as well.

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.

The Time Series Toolbox is a set of software components that simplify the task of building applications that record, process, store and publish time series of observations. Current main application area are sensor networks.

dbUPLoader is a tool to import data from csv or MS-Excel files into a database. You can distribute data across several tables, create relationships between imported data and integrate sub queries to reference existing data.

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

Convert/manipulate csv files, Java / GUI Swing; GPL3. Uses Ostermiller Utils (CSV Java, http://ostermiller.org/utils/CSV.html) Alows to define rules for the conversion (copy or replace the contents). Useful eg. for serial mail.

A simple CSV parser. Very easy to use.

Easy to use ready to go CSV File Reading utility. Read One or Multiple files into a RecordManager, quick access to the file with segmentation into Fields and Records. Merge Multiple CSV files in one. Listener to CSV Files.

This tool is a small tool to upload a csv file to a database. This tool can analyse a CSV file and it can determine the field lenght and the column name.

"Database to CSV" allows to back-up data from database(Oracle, MySQL, SQL Server) in the form of CSV files. Each table data is stored in a separate CSV file. It also allows to load data from CSV files into the database. Program can be run from UI or from command line. There's one more advanced feature which allows merging of data from CSV file to Database. It is only available from command line. (It will take foreign keys and unique keys into consideration and then try to insert data with minimum change as possible). Note: 1) If tables do not exist, this program will not automatically create table while loading data from CSV.

Java library for reading and writing of flat files. CSV, FLR (fixed length record) or mixed structures. Tree-style processing API. Adapters for SAX, Stax and XStream for transformation, data binding or serialization.

Library for parsing of csv files. The project's focus is the flexibility to parser the csv files based at SAX and DOM methods on XML.

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)

To switch historical data quotes, from a format to a other one. For example to move historical data quotes from MetaTrader4 to NinjaTrader. Or to move historical data quotes from NinjaTrader to MetaTrader4 .

A CSV editor written in Java 1.6 Developed using NetBeans IDE 6.0.1