Move records into a new base
If you redesigned your schema, here are reliable ways to bring data over.
Best overall: Sync then copy
- In the source base, share a view → “Sync data to another base”
- In the target base, create a new synced table from that source
- Once synced, copy/paste the synced table’s data into your native table (preserving field types)
- Optionally turn off sync; the copied data remains
Pros: preserves types better than CSV; low friction. Docs: https://support.airtable.com/v1/docs/getting-started-with-airtable-sync.
CSV export/import
- In the source, open the view → “Download CSV”
- In the target, use CSV Import (extension) or create a new table from CSV
Notes:
- You must recreate non‑data field types (Formulas, Rollups, Lookups, Links)
- Rebuild links after import by matching key fields
Copy‑paste
- In the source, select all (Cmd/Ctrl+A) and copy (Cmd/Ctrl+C)
- In the target, paste into a new table
Notes: same caveat—recreate computed/linked fields. Useful for small tables and quick tests.
When relationships are involved
- Import parent tables first, then children
- Keep a stable natural key (e.g., email) to rebuild links via lookups after import
- Consider temporary helper fields for matching and validating referential integrity
References
Community guidance on copying data across bases, including Sync and CSV approaches: How do I copy the data from one database to another?