Dropbase 2.0

Import messy CSV/Excel to databases with auto map & validateHey Product Hunt!

We’re excited to be back here and launch Dropbase 2.0 to the PH community first! This is our biggest update since our previous PH launch!

Data is trapped offline inside CSV/Excel files and it’s hard to analyze it or operationalize it without further processing and technical help. We make it easy for spreadsheet users to bring messy data into a fully-featured SQL database that only takes a minute to spin up without engineering, database admins, or custom scripts. Database is included!

With this launch, we are announcing 3 major features:

1. Dropmail, the easiest way to email or forward attachments containing messy Excel/CSV files directly to a cloud database, with automatic column mapping and data cleaning 2. Data validation and checks, to ensure imported data conforms to your requirements, and help you flag and fix data with issues 3. Snowflake Integration for use-cases where companies want to host their own data in their existing database

This release also comes with a ton of improvements that make the data import experience ever better, from handling complicated Excel files which data in multiple sheets or messy header data, remembering cleaning steps, smart column mapping, merging data to database so you can build golden datasets without duplicates rows, and a robust ingestion engine that can open and handle really complicated CSVs/Excel files.

Try it out and share some of your feedback in the comments below!

Thanks for hunting us @mwseibel!