Export your data
Updated
Your data is yours to take out at any time, on every plan: download a view as CSV or Excel, a base as SQL, a table in Airtable's import formats, read everything through the API, or, on your own server, take a full backup.
Download a view as CSV or Excel
- Open the table and the view you want: its filter, sort and hidden fields decide what goes in the file.
- Click the All tables list at the start of the tab bar.
- Choose Download this view as CSV or Download this view as Excel.
The file holds the records and fields the view shows, in its order, as they read on screen.
Download a base as SQL
Download as SQL, in the same list, gives one file with the base's tables, links, records, views and automations, ready to load into PostgreSQL or Supabase.
Export a table back to Airtable
A table also downloads in the formats Airtable's own import reads. Open this address while signed in, or call it with an API token, using the base's code and the table's id:
/api/v2/bases/{code}/tables/{id}/export?format=airtable-csv: a CSV with field names as the header, multiple selects joined with commas, checkboxes aschecked, links by the linked records' names and attachments asfilename (url)./api/v2/bases/{code}/tables/{id}/export?format=airtable-json: every record in the shape Airtable's API returns.
A cell a spreadsheet would run as a formula starts with an apostrophe, so it stays text.
Read everything through the API
- The REST API reads every table a page at a time, with filters and sorting. See the data API.
- The Airtable-compatible API answers Airtable's paths and shapes, so scripts written for Airtable can read your records here.
- Zapier, Make and n8n can copy new and changed records to other tools as they happen.
Back up a whole instance
If you run Artavolo on your own server, one encrypted archive holds everything: both databases and the uploaded files. Run php utilities/backup.php from the shell on any edition; the Enterprise edition also runs it on a schedule from the administration and can copy it to S3-compatible storage. See Scheduled backups and Backups and restore.
Good to know
- CSV and Excel downloads are for anyone who can see the view, except through a shared view link. Download as SQL is for owners of the base.
- The Airtable export is for anyone who may read the table, and follows the same table and record rules as the screen.
- The files of attachment fields are not packed into a download; the Airtable CSV lists each one with its link.
- When you leave the hosted service, export first: deleting your account deletes workspaces that only you use, with their bases and files.
