Import Excel files into SeaTable

Contents

The following article serves as an overview of the topic of importing data from Excel files into SeaTable. In the article you will find detailed instructions on how exactly to import Excel files into SeaTable. Furthermore, we will introduce you to special features that you should consider when importing data.

Import Excel files into SeaTable #

SeaTable's import function allows you to transfer worksheets from your Excel workbooks to your Bases by importing their .xls or .xlsx file. In total, there are three different options available to you:

  • Import an Excel file as a new table into a new Base.
  • Import an Excel file into an existing table.
  • Import an Excel file into an existing Base as a new table.

Option 1: Import as new base #

Importing an Excel file as a new base

  1. Switch to the SeaTable home page.
  2. In the My Bases workspace or within a group, click Add a Base or Folder.
  3. Click Import Base from File (XLSX, CSV or DTABLE).
  4. In the file overview that opens, select the file you want to import from your device.
  5. Confirm either by double-clicking the selected file or by clicking Select or Open.
  6. A preview window will then open so you can check how the imported data will look in SeaTable. Click Submit to complete the import.

Option 2: Import into an already existing table #

Importing an Excel file as a new table

  1. Click the triangle icon to the right of your table name.
  2. Select Import new data from CSV or XLSX file.
  3. In the file overview that opens, select the desired file from your device that you want to import into the table.
  4. Confirm either by double-clicking the selected file or by clicking Select or Open.
  5. A preview window will then open so you can check how the imported data will look in SeaTable. Click Submit to complete the import.

Option 3: Import as a new table #

Importing an Excel file as a new table

  1. Open any base that already exists.
  2. Click the [+] icon located to the right of the name of the last table.
  3. Click Import CSV or XLSX file.
  4. In the file overview that opens, select the desired file from your device that you want to import as a new table.
  5. Confirm either by double-clicking the selected file or by clicking Select or Open.
  6. A preview window will then open so you can check how the imported data will look in SeaTable. Click Submit to complete the import.

Frequently asked questions #

Why does the import preview not show all values?

The import preview shows which data structures will be imported into SeaTable. However, the preview shows a maximum of 201 rows.


Can multiple worksheets be imported from Excel?

SeaTable can handle multiple worksheets and tries to convert each worksheet into a table.


Why is my first row not imported?

The values that are in the first row of an imported Excel table are always automatically used by SeaTable as column names and thereforeremoved from the first row during import. All other data in the table will be moved up one row accordingly.


Does SeaTable detect the column type automatically?

SeaTable tries to determine the column type automatically based on the values in the first rows . Certain data types are automatically recognized by SeaTable. For example, if numbers or dates (year-month-day) are imported, the program automatically adjusts the column type to the imported data.

More helpful articles on importing data #

Importing data can be a tricky business, depending on what format the source file is in. If something doesn't work, the following articles may help you:

How helpful was this article?