Overview
This guide shows how to export your data from Adalo and import it into Xano, preserving collections, fields, and relationships.By the end, your Xano database will contain the same records that powered your Adalo app, ready for scalable APIs.
1. Prepare Your Adalo Data
1.1 Identify Collections
In the Adalo builder:- Go to Database → Collections.
- List every collection you want to migrate (e.g.,
Users,Orders,Products).
1.2 Export as CSV
For each collection:- Click ⋮ next to the collection name.
- Select Export CSV.
- Save the
.csvfile to a folder on your computer.
Keep each file name clear (e.g.,
users.csv) to make mapping easier later.2. Import CSV Files into Xano
For each collection:- Open the database in Xano.
- Click Add Table → Import Data → CSV Import.
- Upload the matching CSV file.
- Click Import and wait for the confirmation message.
If you have foreign key relationships (e.g.,
Orders → Users), these will
need to be resolved either manually or with a workflow.3. Validate Your Data
After all imports:- Browse each Xano table and confirm record counts match your Adalo CSVs.
- Spot-check a few records to verify data and data types, especially long text fields or special characters.