in the left-hand menu of the Adalo Builder, then click on **Records** 
in the collection you want to import to.
**2.)** To upload a CSV, click the Upload button in the top right 
of the records view, then select your CSV file to upload by clicking **Select a File** 
then selecting the file on your computer. If you do not have a CSV and want to try it with a sample app, [click here](https://drive.google.com/uc?export=download\&id=1dIeebULF67KSOsGQaNnSOvcxfJLJ4Dfk) to download the CSV file and [click here](https://previewer.adalo.com/751a5514-2eda-4317-b40f-e1190b141589) to clone a sample app.
**3.)** Adalo will try to automatically pair up the columns in the CSV file with any properties that exist in your database. You can choose not to import certain columns by selecting **None** in the dropdowns or assign them manually if they were not synced automatically. Most property types can be matched up provided they are formatted correctly in the CSV. See the table below for how to properly format each property type.
| Property | Format |
| ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **Text** | Any formatting will work |
| **Number** | Must be either whole, decimal, or negative. No symbols or letters. |
| **True/False** | Value must either be **`true`** or left blank for false. |
| **Date** | Must be formatted as **MM/DD/YYYY** or **YYYY-MM-DD** |
| **Date and Time** | Must be in [ISO 8601](https://en.wikipedia.org/wiki/ISO_8601) Format such as **2022-07-04T02:00:00Z**. Adalo interprets all datetime as UTC. |
| **Image** | Not supported for import, but storage URL locations can be imported as text. |
| **File** | Not supported for import, but storage URL locations can be imported as text. |
| **Relationships** | One-to-Many: Can be matched up as long as the first property of the records of the other collections are identical. For instance, if importing Trips with a relationship to a user
Many-to-Many: Not supported for import.
| **4.)** Once you have paired up the CSV columns and properties, click **Import Data**
. If all goes well, you will see an **"Import Successful"** message. If you receive an error, here are some troubleshooting steps:
* Try uploading records in batches of 10000 or less.
* Make sure any relationship fields *exactly* match existing records and that the collection's first property (or label) matches the column values in the CSV.
* Make sure the label fields (first property in a collection) are either a text or number field.
* Make sure date formats are correct
{% endtab %}
{% tab title="In-Depth" %}
**1.)** Another way to add records to your database manually is by importing a CSV file to your database. To start, click on the Database button in the left-hand menu of the Adalo editor, then click on **Records** in the collection you want to import to.
**2.)** To upload a CSV, click the Upload button in the top right of the records view, then select your CSV file to upload by clicking **Select a File** then selecting the file on your computer. If you do not have a CSV and want to try it with a sample app, [click here](https://drive.google.com/uc?export=download\&id=1dIeebULF67KSOsGQaNnSOvcxfJLJ4Dfk) to download the CSV file and [click here](https://previewer.adalo.com/751a5514-2eda-4317-b40f-e1190b141589) to clone a sample app.
**3.)** Adalo will try to automatically pair up the columns in the CSV file with any properties that exist in your database. You can choose not to import certain columns by selecting **None** in the dropdowns or assign them manually if they were not synced automatically. Most property types can be matched up provided they are formatted correctly in the CSV. See the table below for how to properly format each property type.
| Property | Format |
| ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **Text** | Any formatting will work |
| **Number** | Must be either whole, decimal, or negative. No symbols or letters. |
| **True/False** | Value must either be **`true`** or left blank for false. |
| **Date** | Must be formatted as **MM/DD/YYYY** or **YYYY-MM-DD** |
| **Date and Time** | Must be in ISO 8601 Format such as **`2021-08-19T17:23:10Z`**. Adalo interprets all datetime as UTC. You can use this [converter](https://app.adastacks.com/iso-converter) to convert dates to this format. |
| **Image** | Not supported for import, but storage URL locations can be imported as text. |
| **File** | Not supported for import, but storage URL locations can be imported as text. |
| **Relationships** | One-to-Many: Can be matched up as long as the first property of the records of the other collections are identical. For instance, if importing Trips with a relationship to a user
Many-to-Many: Not supported for import.
|  **4.)** Once you have paired up the CSV columns and properties, click **Import Data**. If all goes well, you will see an **"Import Successful"** message, then you can click **Done**. If you receive an error, here are some troubleshooting steps:
* Try uploading records in batches of 10,000 or less.
* Make sure any relationship fields *exactly* match existing records and that the collection's first property (or label) matches the column values in the CSV.
* Make sure the label fields (first property in a collection) are either a text or number field.
* Make sure the date formats are correct
{% endtab %}
{% endtabs %}
## Example
Upon completing the import, you will see all your new records displayed in the database.
You can always clone the [example app](https://previewer.adalo.com/751a5514-2eda-4317-b40f-e1190b141589) used in this walkthrough as well as download the [example CSV](https://drive.google.com/uc?export=download\&id=1dIeebULF67KSOsGQaNnSOvcxfJLJ4Dfk) to give it a try yourself.
## Learn More
* The column names of the CSV need not exactly match the property names in Adalo.