Subscribe
Sign in
Dropbase 2.0 — Import messy CSV/Excel to databases with auto map & validate
Dropbase helps you import data from complex and messy CSV and Excel files to a fully-featured SQL database, with automatic column mapping, error highlighting, and data validation/cleaning. Database setup and hosting included; no technical help required.
76
Replies
Hey 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!
We've also release our new documentations page that has a quickstart: https://docs.dropbase.io/quickstart
@alpesh_modi Sorry to hear that! Try our quickstart guide to help you create your first table and import some data to it! https://docs.dropbase.io/quickstart
@jimmyechan Oh.. Got it. So I have to create table and then import. Do I have to worry about schema as well? Or that will be managed?
Yes! You can create a table with the schema you need as well as any validation checks required. You can then import data to it and we’ll help you manage it
After you import, we automatically keep track of all your data cleaning steps so the next time you import, we apply them for you.
@garymlin Thanks for your support Gary! We're gonna bring more databases you can connect to, build more partnerships with other products that integrate with databases, and keep adding pre-built checks so that our customers can validate their data in even more ways and not having to custom build!
hey guys, AZ here, one of the makers of Dropbase.
Dropbase 2.0 is the result of 2 years of iteration and experimentation. the product evolved over the years driven by user feedback and our vision for the future of data movement. it was built by a team of talented engineers from the four corners of the world. the features we've implemented are unique to Dropbase and designed to simplify laborious tasks while maintaining flexibility.
i'm really excited to see you try Dropbase and hear your feedback. if you have any question, comments or need support, please feel free to email us or DM me directly. i'm happy to schedule support/demo call.
thank you for checking us out and i'll see you at https://app.dropbase.io ;)
the current version supports files up to 50MB, but we're working on increasing this limit for the next release
@stacey_p_
@pablo_patino Thanks! We've been quietly working on this version for a while. We're all super excited to finally release them! And we still have a lot more coming!
@icescallion Yes, we got feedback from some of our users saying that they had a hard time reading in dark mode so we added it in this release!
Thanks! Glad it’s making your daily work less painful! Have you checked out our Dropmail feature yet?
@lisaval Works like magic. It's gonna save you time and make it less painful to repeatedly import data to the database coming from your external email reports!
Dropbase is great! It will save me so much time. The Dropmail feature and handling of Excel files looks incredible. Can I attach multiple files to the same email?
@yizhou_chen YES! You can attach as many CSVs or Excel files as you can fit in an email attachment. It will usually be between 20-30MB per email, depending on your email provider. If you attach multiple CSVs in the same email, we will process each one of them. If you have cleaning recipes set-up, we will also automatically clean each of those files and directly load them to the database for you.
Hey everyone! My name is Freeman, and I'm a software engineering intern here at Dropbase. I worked on redesigning and recreating the pipelines page. Besides being able to import and clean data, I think it's important to have a clear way to view a history of the files you've imported to your tables. I hope it's intuitive and easy to work with. Would love any feedback!
Features are quite impressive and helpful. Congratulations on the launch! 🚀
@thahir_gangireddypalli THANK YOU! Please let us know if you have questions or any feedback!
Hello -- I'm Henry and and I'm a software intern at Dropbase. I'm excited that now you can bring your own database and connect it to Dropbase.
I worked on enabling custom user-provided databases and fast datetime parsing using native code. I hope you check out our product and see the new features.
I'm happy to see any feedback or things that we can do better :).
Hey, I'm Jon and I'm one of the developers at Dropbase. One of the aspects of Dropbase I'm most excited about is how easy it makes cleaning up messy CSV/Excels. Dropbase provides a really intuitive UI that helps users from all backgrounds to find problems with their data and offers them an easy way to fix it. It was challenging to work on because even programmatically it is not that straightforward to clean all types of messy CSV/Excels. I hope you enjoy the new and updated data cleaning experience! Would love any feedback on it and/or to improve it!
Orbital