Import CSV data directly into MySQL.
Give your users a polished import experience. CSVbox maps their spreadsheet columns to your MySQL table schema, validates every row, and writes clean data — insert or upsert — without any custom ETL code.
- Validated data only
- Column mapping included
- SOC 2 Type II + GDPR
MySQL powers a huge portion of the SaaS ecosystem. If your product lets users manage records — contacts, inventory, bookings, transactions — they eventually need to bulk-load data from spreadsheets. Building that import flow in-house means parsing CSVs, handling encoding quirks, writing mapping logic, and maintaining it forever.
CSVbox replaces all of that. Connect your MySQL database once, configure your target table, and embed the widget. Users upload their files; clean rows arrive in your database.
How It Works
- 1Connect your database
In the CSVbox dashboard, add a MySQL destination. Enter your host, port, database name, username, and password. Connections use TLS by default.
- 2Select your target table
Choose the table to write to. CSVbox reads the column definitions and uses them to guide the mapping step.
- 3Map columns
Map your CSVbox schema fields to MySQL columns. CSVbox auto-suggests matches by name. Override or skip fields as needed.
- 4Choose insert or upsert
Select Insert (append rows) or Upsert (insert or update based on a unique key — e.g., email or external_id).
- 5Embed and ship
Add the CSVbox widget to your app. Your users can start importing immediately. Clean rows land in MySQL; failed rows surface for inline correction.
Configuration Options
| Option | Description |
|---|---|
| Connection | Host, port, database, user, password (TLS) |
| Target table | Any table in the connected database |
| Write mode | Insert or Upsert |
| Conflict key | Column used for upsert (e.g., email, UUID) |
| Column mapping | Map, rename, or skip schema fields |
| Null handling | Empty cells → NULL or default value |
| Charset | UTF-8 (utf8mb4) enforced by default |
Common Use Cases
Users upload contact lists at signup; records land in your MySQL contacts table, ready for use.
Merchants bulk-upload product SKUs, prices, and stock levels.
Help customers switch from a legacy tool by ingesting their CSV export into your schema.
Suppliers or data vendors upload structured files on a schedule; rows append automatically.
Frequently Asked Questions
Does CSVbox support MySQL 5.7 and MySQL 8?
Yes. Both are supported. CSVbox uses the standard MySQL protocol and works with hosted MySQL on AWS RDS, Google Cloud SQL, PlanetScale, and any self-hosted instance.
What charset does CSVbox use for MySQL connections?
utf8mb4 by default, which handles the full Unicode range including emoji. This is the recommended charset for MySQL applications.
How does upsert work in MySQL?
CSVbox uses INSERT ... ON DUPLICATE KEY UPDATE with the column you designate as the unique key. Make sure that column has a UNIQUE index in your table.
Can I white-label the importer so it looks like part of my product?
Yes. CSVbox supports full white-labeling — your colors, logo, and domain. Available on Pro and Enterprise plans.