1. Home
  2. Documents
  3. User Manual
  4. Data management
  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 what file formats you can import into SeaTable are the topics of this article.

Exporting 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 using the extended functions in the Bases library. Move the mouse pointer to the name of the library to be exported and then click on the three-point icon that appears on the right. You will find the menu item Export in the menu that opens. The export of a Base may take some time depending on its size. When the preparations are complete, you will be asked where you want to save the export file. Select a suitable storage location and confirm your 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 is made to a file with DTABLE file extension. Such a file can easily be reimported intoSeaTable . Be aware that this file can become very large if you have made heavy use of file and image columns in the exported base. (For more information about the DTABLE export format, see the Become a Pro section).

Exporting a table

You can export individual tables to XLSX files from any Base to which you have access. The contents of text, number, date, selection, and formula columns are copied to the target file as values. Contents of multiline text type 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 modification history are not transferred to the target file.

You start the export of a table from the table view. Click the small arrow to the right of the name of the table you want to export. Now choose Export Table to Excel to start the export. Once the export preparation is complete, you can select the location where the XLSX file will be saved. Once you have confirmed the location, the export is complete.

Importing Base

SeaTable supports importing from its own DTABLE format and generic CSV format. When you import a DTABLE file, the base is restored to its state at the time of export. CSV import copies the CSV file values to 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 where 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 Base is complete.

Importing a table

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

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

Was this article helpful Yeah, right! No 4 out of 8 users found this item helpful.