# Move from Airtable

> Bring Airtable bases with records, links, formulas, files and comments, check them record by record, run side by side, then switch.

Source: https://artavolo.com/page/move-from-airtable

Artavolo reads your Airtable bases through Airtable's API and makes each one a base here, with its records, links, formulas, files, comments and Airtable's own ids. It checks every formula against Airtable record by record, and can keep the base in step with Airtable until your team switches. Nothing in Airtable is changed.

## Bring your bases

1. On Home, click **Bring your Airtable base**. It is also a tab, **Airtable**, in the import dialog.
2. Click **Connect Airtable** and allow access in Airtable. If that button is not offered, [create a personal access token](https://airtable.com/create/tokens) in Airtable with the scopes `data.records:read`, `schema.bases:read` and `data.recordComments:read` and access to your bases, paste it, and press **Next**.
3. Under **Which bases?**, tick the bases to bring. Several at once is fine.
4. Leave **Keep them in step with Airtable every hour until I switch** ticked to try Artavolo on live data first, or untick it for a one-off copy.
5. Press **Bring it in** (**Bring them in** for several). The progress shows tables, records, comments and files. You can close the dialog: the import goes on.

## What comes over

- Every record of every table, in the order of each table's first view, with its created time.
- Links between tables, both ways, record by record.
- Formulas, lookups, rollups and counts, in Airtable's `{Field}` syntax.
- Attachments, copied into Artavolo's storage, because Airtable's file links expire within hours.
- Record comments, with their authors matched by e-mail address.
- People in user fields: a workspace member by e-mail, or kept by e-mail until that person joins. Their cells and comments then become theirs.
- Autonumbers with Airtable's numbers; new records carry on from the highest.
- The base, table, field and record ids (`app`, `tbl`, `fld`, `rec`).

## Read the report

When a base is in, **Your base is here** shows the records counted per table and then:

- **Formulas, lookups and rollups, checked against Airtable**: Artavolo works out each computed field itself and compares it with Airtable's value for every record. A line says "matches Airtable on all 5,000 records", or how many differ, with the first few records and both values. A formula that did not translate keeps its last values and is named.
- **What is different from Airtable**: what needs your attention.
- **People**: those named in the base who are not in the workspace yet, with **Invite them as contributors**.

Airtable's API does not give automations, interfaces, scripts, revision history or the filters and sorts of views. Rebuild automations and interfaces here, and set each view's filter and sort again. Record history starts at the import.

## Run side by side, then switch

While a base is kept in step, Artavolo reads Airtable every hour: changed records are updated, new ones added, and ones deleted in Airtable go to the trash. The base says **Synced from Airtable every hour** and takes no edits here, from people, the API, AI chat or automations, so nothing is overwritten. Owners can press **Sync now**, and **Switch to Artavolo** when the team is ready. From then on the base is edited here. Set the Airtable base to read only for a month rather than deleting it.

## The cut-over checklist

An owner of an imported base sees **Moving from Airtable** at the foot of the screen, with ten steps: records, formulas, views, automations, interfaces, integrations, forms and shared links, the team, Airtable set to read only, and the switch. Steps the base can see are ticked for you; tick the rest yourself.

## Good to know

- Only owners of a workspace import, within the plan's number of bases.
- Scripts and the Airtable.js SDK keep working with this site's address and an Artavolo token: see [the Airtable-compatible API](https://artavolo.com/page/airtable-compatible-api).
- A file that cannot be copied stays on its Airtable link and is named in the report.
- To take a table back to Airtable, see [Export your data](https://artavolo.com/page/export-your-data).

## Related

- [Switch from Airtable](https://artavolo.com/airtable)
- [The Airtable-compatible API](https://artavolo.com/page/airtable-compatible-api)
- [Automations](https://artavolo.com/page/automations)
- [Interfaces](https://artavolo.com/page/interfaces)
