Customers upload their CSV data, map columns, validate data and you get ready to use data in your PostgreSQL Table.
Use the csvbox drop-in widget to collect CSVs from your customers and upload clean data to PostgreSQL Database. Here is how it works.
Define your data model and configure the validation rules with just a few clicks.
Select PostgreSQL as your data destination. Provide access credentials and specify the table name in your csvbox dashboard. Add the importer JS snippet in your app and start accepting files.
With a simple file picker, the users select a spreadsheet that needs to be uploaded. They then match the file column headers to the predefined data model.
Before submitting the file, the users can fix validation issues right inside the upload widget. This ensures that the uploaded data is clean and ready to use.
Users submit the spreadsheet and monitor the upload. You receive clean data in your PostgreSQL table.
At the end of an import, csvbox will upload the file data to PostgreSQL Database. It doesn't matter if your backend is Ruby, C#, Python, Node.js, PHP, or anything else you could be using. We will give you clean data in your PostgreSQL Table and then your app can take over.
...or any major Javascript framework
Way more than a file uploader - a complete import service.
Accept csv, xlsx and xls - the most common spreadsheet formats.
Let users match the columns of their files with the required data model schema.
Client side validation based on predefined sheet rules allows users to self clean data before upload.
The simplistic widget UI makes a file upload painless and intuitive.
Give your users confidence that their files are on the way to the right destination.
Configure the data model and validation options via dashboard with no change in installed code.
Push CSV data directly to your MySQL database. More destinations coming soon.
Share special links to accept files without the need to embed the widget.
Attach custom fields such as user_id to the incoming data to identify the users.
Setup webhook listeners to receive alerts about widget events such as import complete.
End to end encryption for user data in transit as well as at rest.
GDPR ready with built-in product features for greater privacy and data control.
Contact us or sign up now.