Skip to content

Exporting

Base can export data to the following formats:

  • .sql files
  • Delimited text
  • JSON
  • Excel

To begin importing, select the table or view you would like to export from, then select File ▸ Export… from the menu bar. If you want to export the whole file, it doesn't matter which table is selected.

Once you have selected an export format and set any options, click Export… to choose where to save the exported data.

SQL files

This is the only format that can export multiple entities at once. You can select which tables to include, and whether to include schema, data or associated indexes and triggers.

Info

Similarly to importing, Base will write SQL files which use the SQLite dialect of the language. These many not import directly into other database engines (such as MySQL or Microsoft SQL Server) without modifications.

You can read more about the SQLite dialect in the SQLite documentation.

Other formats

Other formats (CSV, JSON, Excel) can only export one table or view at a time.

As well as any format-specific options, you can choose which columns are included in the exported data.