Product

Product Feature 05: Imports - Import CSV or Excel files to your database, instantly

We cover all the different ways to import your data in your Dropbase to save you time converting csv's to databases!

This article is part of our Product Feature series. Click here to read the first article.

Hello!

We’re going to cover all the different ways to import data into Drop. We’re going to assume you know what a Dropbase pipeline is and how to set it up. Check out this article for a refresher on pipelines if you’d like.

Importing data by yourself

Drag and Drop (DND)

The first way to import data is the simplest: drag and drop (DND). In order to create a new table, you drop a file into the Table column, give it a name, click upload file, and then click load to database.

That’s the scenario without any cleaning steps. If you do have some cleaning steps you want to apply, check out this article to see how to set them up. All the above steps apply as well, you just have to add the cleaning steps you’d like.

And once you’ve imported in data the first time to create a table, importing newer data of the same schema is almost exactly the same.

The only difference is that you get to see Column Mapper match the newer columns to the source, and apply any cleaning steps.

Creating a new table schema

In addition to DND, you can also manually create the table schema first and then grab your data later. You can use this method to ensure that the schema in Dropbase is exactly what you want. Then, if the first file you import has columns that are spelled or ordered a bit differently, mapping them to the already existing columns in this schema is a breeze.

Importing data from external sources

Now for two fun ways to automatically collect your data whether they’re coming from business partners, customers, or other team members. We covered this topic in depth in a previous article, but read on for a condensed version of it.

Dropmail

Dropmail feels like magic. It eliminates traditional the email workflow of receiving data in an email attachment, downloading it, cleaning, and then uploading it to your database every single time. Here’s how.

Dropmail creates a unique email id that your external data sender (like a supplier) sends the data to, instead of you. When your supplier sends the data as an email attachment to the Dropmail address, the data gets automatically added to a previously created data pipeline. All you have to do is click “Approve”.

https://www.loom.com/share/0f40605ccb22468181f8c242e6f3232b

We talked about Dropmail in detail here and also here if you’d like to learn more. If you’d rather try out Dropmail right now, sign up for a free trial here.

Dropzone

Sometimes, email isn’t enough. Gmail currently has a 25 MB limit on email attachments before it’s linked as a finicky Google Drive link. So instead of going to your email inbox each time, and reminding your data sender for this week’s data, you can use Dropzone instead.

Dropzone gives your data sender the ability to upload data to Dropbase directly without going through email or a online file storage provider. They merely have to drag and drop their file in, and you get an approval notification on your pipeline.

We talked about Dropzone in detail here and also here if you’d like to more of it in action.

Imports, in conclusion

Those are all the way (for now) to get your data into Dropbase. The great about all these import methods is that you can automate the entire ingestion and cleaning process with the help of pipelines. If you’d like to check out these import features and all of the others in Dropbase, sign up for a trial here.

Go back toProduct Feature 04: Dropmail

Newsletter
Insights and updates from the Dropbase team.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
By signing up you agree to our Terms of Service