1. Home
  2. Documents
  3. Manual
  4. Use SeaTable
  5. Data import and export
Print

Data import and export

SeaTable's import functions make it possible to switch from other solutions to SeaTable with little effort. The same applies to switching from one SeaTable system to another, e.g. when migrating from SeaTable Cloud to a self-hosted SeaTable system. You can continue to work seamlessly on a base imported from another SeaTable instance.

How to export bases and tables from SeaTable and which file formats you can import into SeaTable are the topics of this article.

Export base

As the owner, you can export the current status of your bases including all tables, views, web forms, statistics, scripts and even plugins. The export contains all table values including file attachments in columns of type image and file. However, as a snapshot of a base, an export does not contain the history of the base. Snapshots and the change journal are not included in the export file. Comments are also not exported.

You start the export of a base via the advanced functions in the Bases library. Move the mouse pointer to the name of the library to be exported and then click on the three-dot icon that appears on the right. You will find the menu item Export in the menu that opens. Exporting a base may take some time depending on its size. After completing the preparations, you will be asked where you want to save the export file. Select a suitable location and confirm the selection. This completes the export of the base.

In SeaTable Cloud, bases up to 100MB in size can be exported. In larger bases, file attachments must be deleted to enable the export.

The export takes place in a file with a DTABLE file extension. Such a file can easily be re-imported into SeaTable. Be prepared that this file can become very large if you have made heavy use of file and image columns in the exported base. (Read more about the DTABLE export format in the Expert Knowledge section).

Export table

You can export individual tables to XLSX files from each base to which you have access. The contents of text, number, date, selection and formula columns are copied as values into the target file. Contents of type multiline text are written to the XLSX file in Markdown format. Image and file values are also exported, but not in their binary format, but as a share link including file metadata. Comments and the change history are not transferred to the target file.

You start the export of a table from the table view. Click on the small arrow to the right of the name of the table to be exported. Now select Export table to Excel to start the export. As soon as the preparation of the export is complete, you can select the storage location of the XLSX file. The export is completed when you confirm the storage path.

Import base

SeaTable supports import from its own DTABLE as well as from the generic CSV format. When importing a DTABLE file, the base is restored to its state at the time of export. When importing a CSV file, the values of the CSV file are copied into text columns of a new base.

The procedure for importing a base is independent of the file type of the import file and starts at the same point as the export: The Bases Library. Select Add Base in the area or group to which you want to add the base. Then select Import Base from File (*.csv or *.dtable) and select the file to import. When the import is complete, the file appears in the area where you clicked Add Base. The import of a file as a base is completed.

Import table

In existing bases, you can fill individual tables by CSV import. During the import, the comma-separated values from the file are copied into text columns of a new table.

The import is done via the table view of the target base. Click on the + icon to the right of the table tabs and select Import CSV. In the file manager that opens, navigate to the CSV file you want to import and confirm the selection. The import is completed in a few moments.