Overview
This guide walks you through exporting data from Google Sheets and importing it into Xano, where you can manage your data as structured database tables and expose it through APIs.1. Prepare Your Google Sheets Data
1.1 Clean & Organize
Before exporting:- Ensure each sheet represents a single logical dataset (e.g.,
Users
,Orders
,Products
). - Confirm that the first row contains column headers.
- Remove blank rows, merged cells, or formulas that may cause import issues.
Xano supports CSV files. If you have multiple sheets, export each one
individually or as separate CSVs.
1.2 Export as CSV
For each sheet:- Open your Google Sheet.
- Go to File → Download → Comma-separated values (.csv).
- Save each sheet as a separate
.csv
file.
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.
3. Validate Your Data
After importing:- Open each Xano table and check that record counts match the rows in your Google Sheet.
- Spot-check a few records for accuracy and formatting.