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

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.

vcf2csv is a command line tool, written in ANSI-C (C90), converts a vcard (vcf) file to csv. Please note: the ability to generate HTML-files will be removed in the near future.

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

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.

Command-line tool that takes a RimWorld saved game as input, extracts skills and stats information about the colonists in the save, and writes the data out into a CSV file.