# excel-sql

> Create SQL database from Excel spreadsheet

Latest version **0.0.3** (published 2016-01-25) · MIT license · 0 weekly downloads

## Install

```sh
npm install excel-sql
pnpm add excel-sql
yarn add excel-sql
bun add excel-sql
```

Provides the command `excel-sql`.

## Health

**Score 15/100 (F)** — status: abandoned.

Positive: no vulnerabilities.

Warnings: low downloads; no types; no esm support; pre 1.0.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 0.0.3 |
| Published | 2016-01-25 |
| First published | 2016-01-18 |
| Weekly downloads | 0 |
| License | MIT |
| TypeScript types | none |
| Module format | CommonJS |
| Dependencies | 5 |
| Known vulnerabilities | 0 (+5 in 1 direct dependencies) |
| Install scripts | no |
| GitHub stars | 4 |
| Author | Christopher Brown |
| Maintainers | chbrown |
| Keywords | excel, sql, convert, import, export |

## Links

- npm: https://www.npmjs.com/package/excel-sql
- Repository: https://github.com/chbrown/excel-sql
- Issues: https://github.com/chbrown/excel-sql/issues
- npm.io page: https://npm.io/package/excel-sql

## Dependencies (5)

- [loge](https://npm.io/package/loge.md) 1.0.4
- [xlsx](https://npm.io/package/xlsx.md) ^0.8.0
- [async](https://npm.io/package/async.md) ^1.5.2
- [yargs](https://npm.io/package/yargs.md) ^3.32.0
- [sqlcmd-pg](https://npm.io/package/sqlcmd-pg.md) 1.1.1

## Recent versions

- 0.0.3 (latest) — 2016-01-25
- 0.0.2 — 2016-01-25
- 0.0.1 — 2016-01-18

## README

## excel-sql

[![npm version](https://badge.fury.io/js/excel-sql.svg)](https://www.npmjs.com/package/excel-sql)

Node.js script to read an Excel spreadsheet into a PostgreSQL database.

    $ npm install -g excel-sql

Example:

    $ excel-sql MySpreadsheet.xlsx
    Creating database MySpreadsheet
    Creating table Sheet1
    Inserting 171 rows
    Creating table Sheet2
    Inserting 0 rows

Uses the fabulous [`xlsx`](https://www.npmjs.com/package/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 Christopher Brown. [MIT Licensed](http://chbrown.github.io/licenses/MIT/#2016)

---
_Source: https://npm.io/package/excel-sql · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._