1. Home
  2. Documents
  3. User Manual
  4. Data management
  5. Data import and export

Data import and export

SeaTable's import features make it easy to switch from other solutions to SeaTable with little effort. The same is true when switching from one SeaTable system to another, for example, when you migrate from SeaTable.io to a self-hosted SeaTable. You can continue working 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 owner you can export your bases including all tables, columns, web forms, statistics and even plugins. The export also includes all file attachments. But the export is not completely lossless. The history of the base including all snapshots is not exported. So you only export the current state of the Base without a change journal. 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.

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 2 out of 6 users found this item helpful.