This program allows a user to modify a CSV file using SQL commands. This program uses a temporary H2 database to contain the CSV file, and accept SQL commands. You can then save this back to a CSV file without any data being distorted. This project only supports CSV comma delimited files. Currently any other CSV files are not supported. When editing the CSV you are sending SQL statements to a H2 database with a single table named CSV.

Example command: DELETE FROM CSV WHERE column=100;

Because this is SQL the possibilities of what you can do with it are only limited by the H2 database engine. H2 is a well-maintained database, and it has many features.

Features

  • CSV editing using SQL commands

Project Activity

See All Activity >

Categories

Database

License

GNU General Public License version 3.0 (GPLv3)

Follow SQL CSV Editor

SQL CSV Editor Web Site

Other Useful Business Software
$300 Free Credits for Your Google Cloud Projects Icon
$300 Free Credits for Your Google Cloud Projects

Start building on Google Cloud with $300 in free credits. No commitment, no credit card required until you're ready to scale.

Launch your next project with $300 in free Google Cloud credits—no strings attached. Test, build, and deploy without risk. Use your credits across the entire Google Cloud platform to find what works best for your needs. After your credits are used, continue with always-free tier services. Only pay when you're ready to scale. Sign up in minutes and start exploring.
Start Free Trial
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of SQL CSV Editor!

Additional Project Details

Operating Systems

Linux, Mac, Windows

Languages

English

Intended Audience

Advanced End Users

User Interface

Java Swing

Programming Language

Java

Related Categories

Java Database Software

Registered

2013-10-12