Datasette plugin for uploading CSV files and converting them to database tables
datasette install datasette-upload-csvs
The plugin adds an interface at /-/upload-csvs for uploading a CSV file and using it to create a new database table. The interface provides an option to append rows to an existent table in the database.
By default only the root actor can access the page - so you'll need to run Datasette with the --root option and click on the link shown in the terminal to sign in and access the page.
The upload-csvs permission governs access. You can use permission plugins such as datasette-permissions-sql to grant additional access to the write interface.