Creating a Database by Importing Data from an External Source
Databases can be created by bringing data from sources outside the system. This approach is efficient, allowing you to quickly populate a new database with existing information. This is super handy, especially when you’re dealing with large datasets or when there is a need to set up a database rapidly.
Importing data also helps to maintain data integrity by reducing the risk of manual errors during the data entry process. This is particularly important for preventing data inconsistencies and ensuring accuracy. Additionally, users have the flexibility to select the required columns they need to create the database.
We currently support data import from CSV and XLSX files.
Below is the step-by-step procedure for generating a new database by importing data from an external source.
On the app homepage, head to the My Work tab on the left sidebar.
All the folders you have created, as well as those created by others, will be listed.
If you cannot locate the folder in the list, type in the folder name under Search Folders.
Click on the folder you wish to open.
Go to the Databases tab.
Click + button.
Select Import Data option.
Drag and drop your data file onto the marked area, or click on the area to pick the file.
Once the file is uploaded, the data will be displayed in a spreadsheet format.
Select the sheet from the data file that contains the information you need.
Select only the columns you're interested in to include in the database.
Click Continue.
Provide a suitable name for the database.
Click Create Database. A new database will be created related to the respective folder.
Click View Database to open the database in a new window.
Below is a preview of the newly created database.
Watch the video below to gain more insights on creating a database by importing data from an external source.
Last updated
