Import data

Importing data is typically one of the very first actions you take inside Dropbase. Importing data allows you to bring tabular data or flat files such as CSV or Excel files into Dropbase. You can import data to Dropbase using the Database Manager, or through external data requests, using a Dropzone or Dropmail request.

Note that importing data is different from loading data to the database. Importing data simply brings your data to a secure sandbox, but the data will not be loaded to your Database until you explicitly click on "Load to Database". The reason we break this down into two phases is that importing data to a sandbox allows you to add and apply cleaning steps to process your data before loading it to the database.

From Database Manager

You can Import data to Dropbase by drag-and-drop (or file upload) action within Database Manager. You can drag-and-drop files directly to a folder name, inside a folder, or directly on top of an existing table grid

Import data to load to a new table

You can load data to a new table by simply drag and dropping a CSV or Excel file to the database manager.

Drag and drop to folder name

Screen Shot 2021-12-09 at 12.43.55 PM.png

Drag and drop inside folder


Import data to load to an existing tables

You can load data to existing tables directly using Database Manager. To load more data to an existing table in your database, simply select the table you want to load data to. We refer to this as the destination table. Then drag and drop CSV or Excel file that contains the data you want to load to this table.