Comment on page
Importing Records from a CSV File
Import large amounts of data to your database by uploading a .CSV file. Format and sterilize text, dates, and numbers so that you get a clean import every time!
Skill Level: Intermediate
- You do not need a paid Adalo plan to use this feature for up to 50 records.
Simple
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 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 to download the CSV file and click here 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 | |
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 [email protected], the Users collection must have a user with this email and have Email set as the first property in the collection. 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
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 to download the CSV file and click here 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 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 [email protected], the Users collection must have a user with this email and have Email set as the first property in the collection. 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
Upon completing the import, you will see all your new records displayed in the database.
You can always clone the example app used in this walkthrough as well as download the example CSV to give it a try yourself.
- The column names of the CSV need not exactly match the property names in Adalo.
- The columns do not need to be in the same order as the collection properties.
- It's typically best to upload records in batches of 10,000 or less, but it's not uncommon for uploads to succeed when uploading far more than that.
- Importing CSVs does not overwrite existing database records, it only adds to them.
If you need additional help with this article, you can always ask in our community forum! Be sure to paste the link to this article in your post as well!
tags: cvs, csv, import, upload
Last modified 8mo ago