# 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.

{% hint style="info" %}
We currently support data import from **CSV** and **XLSX** files.
{% endhint %}

Below is the step-by-step procedure for generating a new database by importing data from an external source.

1. On the app **homepage**, head to the **My Work** tab on the left sidebar.
2. All the folders you have created, as well as those created by others, will be listed.
3. If you cannot locate the folder in the list, type in the folder name under **Search Folders.**
4. Click on the folder you wish to open.
5. Go to the **Databases** tab.
6. Click **+** button.
7. Select **Import Data** option.
8. Drag and drop your data file onto the marked area, or click on the area to pick the file.
9. Once the file is uploaded, the data will be displayed in a spreadsheet format.
10. Select the sheet from the data file that contains the information you need.
11. Select only the columns you're interested in to include in the database.
12. Click **Continue**.
13. Provide a suitable name for the database.
14. Click **Create Database.** A new database will be created related to the respective folder.
15. Click **View Database** to open the database in a new window.

<figure><img src="/files/ARS7Gjt9ZU7wODMM6ZvM" alt=""><figcaption><p>Selecting Columns</p></figcaption></figure>

<figure><img src="/files/QTyEK4yYxZq823saUHQ4" alt=""><figcaption><p>Creating the Database</p></figcaption></figure>

Below is a preview of the newly created database.

<figure><img src="/files/4ToSj9sHtow4HajLkglS" alt=""><figcaption><p>Database Preview</p></figcaption></figure>

Watch the video below to gain more insights on creating a database by importing data from an external source.

{% embed url="<https://drive.google.com/file/d/10Uaq6SpBRXhEsYfJfC0OWZMwUetj8GUc/view?usp=drive_link>" %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.iviva.com/lucy/my-work-folders/databases/creating-and-editing-databases/creating-a-database-by-importing-data-from-an-external-source.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.