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
Categories
DatabaseLicense
GNU General Public License version 3.0 (GPLv3)Follow SQL CSV Editor
Other Useful Business Software
AestheticsPro Medical Spa Software
AestheticsPro is the most complete Aesthetics Software on the market today. HIPAA Cloud Compliant with electronic charting, integrated POS, targeted marketing and results driven reporting; AestheticsPro delivers the tools you need to manage your medical spa business. It is our mission To Provide an All-in-One Cutting Edge Software to the Aesthetics Industry.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of SQL CSV Editor!