Open Source CSV Software

This is an Excel based VBA script used to import bulk .VCF files that contain more than 1 Vcard and then convert them to a comma separated .CSV file or Excel xls file that can then be imported into Outlook, Google, or any other application that supports import of contacts using CSV files. This has been written to support VCF 2.0, 2.1, 3.0 and 4.0 formatted files including those with printable encoding (MIME) and has been tested with bulk VCF files from Backupify, Google Contacts (Gmail Contacts), Apple IOS, Samsung Android devices and other platforms. If this doesn't work for you, please email me the VCF file and I'll modify the code to support your specific VCF format. To use, simply download and open the Excel file (xlsm), Enable Macros if prompted, and then select the VCF file you wish to import. Once complete, Excel will create and save new file titled VCFExport.csv that can also be saved in Excel format.

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.

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'.

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.

Bots is a complete translator for edi (Electronic Data Interchange). EDI data formats eg: edifact, x12, tradacoms, xml. Mail: http://groups.google.com/group/botsmail Web-site: http://bots.sourceforge.net Wiki: http://bots.readthedocs.io Develop: https://github.com/eppye-bots/bots

csv2odf can create business intelligence reports from csv data sources with output to ods, odt, html, xlsx, or docx documents. It uses a template file that you design to control the layout, fonts, and colors. Just query your database with output to csv (or tsv), then use csv2odf to insert the data into your template to produce a nice looking formatted output. It is a command line tool and you can automate the generation of reports by using scripts and cron. It can be used to create spreadsheets and documents for LibreOffice, OpenOffice, Microsoft Office Excel and Word. It is open source GPL v3 and crossplatform, it can run on most operating systems that can run Python (Python is required). More details, example files, and online manual at http://csv2odf.sf.net.

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

Still struggling with Excel to setup your pick and place machine ? Cad2Board reads component mounting information from Eagle, Altium Designer and Mentor Expedition PCB designs. Component or component groups can be assigned to feeder slots by drag and drop. Any modifications for PCB population can be defined to generate PCB variants, consider rotations from unusual tape and reel packaging or to account in advance for CAD library or PCB design bugs. Generated setup data is stored in a seperate project file. Succeeding PCB revisions what contain redesign changes can be merged with existing project setup data. Inconsistencies are highlighted to solve them by new assignements and unused feeders can be cleaned up with a single push. Finally a machine program is generated in Heeb HE50 format and downloaded to the machine interface.

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

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.

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.

A CSV mass editor for advanced users, written in PHP. Its purpose is not to edit the data, but to mass manipulate it: re-arrange, join and delete columns, join rows, search and replace using regexes and a bit more.

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.

CSVChecker is a python utility designed to check CSV file for field length and format. Configuration is made on a field basis through YAML configuration file.

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.

Elevations moves data from Excel to Unix systems. It connects VBA with Cygwin SSH, CGI and HTTP POST to deliver to a QuantLib C++ server through pipes. Provides C++ classes to process CSV files and the strings to C++ types. File schema definitions.

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.

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.

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 .

The London Datastore (http://data.london.gov.uk) was created by the Greater London Authority (GLA) as an innovation towards freeing London’s data. This SourceForge Project will be used to Open Source our development efforts surrounding data formats

A script written in pure PHP that can easily generate dynamic surveys based off of included template CSV (comma separated value) files. Setting up the script is as simple as editing the template file and transferring the directory to a server.

Row-Bean is a CSV-Bean JAVA API . Row-Bean provides CSV reader an writer. More ever provides a mechanism to map csv file content to java beans and revers. For each use, a XML description must describe the wished mapping. Another possibility consists in use Annotations. Use under maven : <!-- row bean with annotations --> <dependencies> <dependency> <groupId>net.sf.csv-bean</groupId> <artifactId>row-bean-annotations</artifactId> <version>1.1.0</version> </dependency> </dependencies> <!-- row bean without annotations --> <dependencies> <dependency> <groupId>net.sf.csv-bean</groupId> <artifactId>row-bean-core</artifactId> <version>1.1.0</version> </dependency> </dependencies>