Use the csvbox drop-in widget to collect Excel files from your customers and upload clean data to MySQL Database. Here is how it works.
Define your data model and configure the validation rules with just a few clicks.
Select MySQL 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 MySQL table.
At the end of an import, csvbox will upload the Excel file data to MySQL 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 MySQL table and then your app can take over.
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 Excel 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.