Airtable: Copy Data from One Base to Another (Sync, CSV, or Paste)
Move data to a new relational design using Sync, CSV export/import, or copy‑paste.
Insights, tutorials, and updates. Explore our latest articles below.
Move data to a new relational design using Sync, CSV export/import, or copy‑paste.
Download CSV from any view, then automate CSV or direct SQL exports using integrators like Make or dedicated tools.
Use IF with FIND/SEARCH to detect selected options, and reference yesterday’s date reliably.
No direct move exists—use Sync, CSV, or copy‑paste, and preserve field types smartly.
Issue ticket numbers like 2025-0001, 2025-0002, then reset to 2026-0001 using one table + one automation script.
Auto‑increment subgroup numbers per item even when records are added out of order, using a minimal two‑table setup.
Format a number with thousands separators inside a formula field while concatenating with text or currency.
Learn the cleanest ways to check blank vs not blank and format dates correctly in Airtable formulas.
A step-by-step playbook to bulk-identify and clear duplicate records using linked tables, rollups, and formulas.
Three approaches: formula extraction patterns, a simple script using split(), and a normalized data model that avoids splitting entirely.
Understand SET_TIMEZONE, DATETIME_FORMAT, UTC settings, and reliable patterns for filters and automations.
What you can and cannot do when sharing Airtable Interfaces, plus workarounds to publish read-only dashboards without adding paid collaborators.
A practical guide to deduplicating values from lookups using formulas, rollups, and automations—based on common community questions.