# Export your data

> Every way to take data out of Artavolo: a view as CSV or Excel, a base as SQL, a table in Airtable formats, the API, and backups when self-hosted.

Source: https://artavolo.com/page/export-your-data

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

1. Open the table and the view you want: its filter, sort and hidden fields decide what goes in the file.
2. Click the **All tables** list at the start of the tab bar.
3. 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.

![The All tables list open over a grid: the Tasks and Campaigns tables, then Import a file as a table, Download this view as CSV, Download this view as Excel and Download as SQL](https://artavolo.com/site/templates/default/assets/img/help/all-tables-menu.webp)

## 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 as `checked`, links by the linked records' names and attachments as `filename (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](https://artavolo.com/page/rest-api-and-tokens) reads every table a page at a time, with filters and sorting. See [the data API](https://artavolo.com/docs/data-api).
- The [Airtable-compatible API](https://artavolo.com/page/airtable-compatible-api) answers Airtable's paths and shapes, so scripts written for Airtable can read your records here.
- [Zapier, Make and n8n](https://artavolo.com/page/zapier-make-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](https://artavolo.com/page/scheduled-backups) and [Backups and restore](https://artavolo.com/docs/backups).

## 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.

## Related

- [REST API and tokens](https://artavolo.com/page/rest-api-and-tokens)
- [The Airtable-compatible API](https://artavolo.com/page/airtable-compatible-api)
- [Scheduled backups](https://artavolo.com/page/scheduled-backups)
- [Delete your account](https://artavolo.com/page/how-to-delete-your-account)
