to-sql
Node.js script to read .csv, .tsv, and Excel spreadsheets
into a series of standard SQL CREATE TABLE and INSERT statements.
$ npm install -g to-sql
Example:
$ to-sql MySpreadsheet.xlsx
Creating table Sheet1
Inserting 171 rows
Creating table Sheet2
Inserting 0 rows
Uses the fabulous xlsx library for parsing the Excel spreadsheet.
It does some simple regular expression-based type inference, automatically distinguishing between TEXT, INTEGER, and REAL, as well as some formats of DATE and TIME.
To-do
- Support more types in the type inference part
- Infer foreign relationships if possible
License
Copyright 2016-2017 Christopher Brown. MIT Licensed