Summary
The spreadsheet-into-a-table job, without a one-off script that then lives forever.
One call takes the file path, the database type, the connection string and the table name, so the same tool covers a Postgres load and a SQLite one — and the notes tool gives you somewhere to record what an import changed while the detail is still fresh.
What it is
A loader that reads a CSV or Excel file from a path you give and writes it into a table on a database you name, plus a small notes tool for recording what was done.
What you get
- CSV and Excel files read, including .xlsx and .xls
- PostgreSQL, MySQL, MongoDB and SQLite as targets
- Connection string, database type, source file and target table all passed per call
- Notes created and kept alongside, for tracking what an update changed
Requirements
A connection string for the target database, supplied on each call rather than configured once, and a file path the server can read. Node, with the project built locally before first use.