Import of XLSX files into SeaTable

The following article serves as an overview of the topic of importing data from XLSX files into SeaTable. In the article you will find detailed instructions on how exactly you can import Excel tables into SeaTable. We also present special features that you should be aware of when importing data.

Import XLSX files into SeaTable

With SeaTable's powerful import function, you can transfer worksheets from your Excel workbooks into your bases. Simply import files with the extensions .xls or .xlsx. Even Excel spreadsheets with many thousands of rows are made available in SeaTable in just a few moments.

A total of three different options are available to you:

1. Import an XLSX file as a new table into a new base.
2. Import an XLSX file as a new table into an existing base.
3. Import an XLSX file into an existing table.

Option 1: Import as 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 on 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 that you can check how the imported data will look in SeaTable. Here you can select exactly which columns and which tables you want to import from the XLSX workbook.
7. Click on Submit to complete the import.

Option 2: Import 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 that you can check how the imported data will look in SeaTable. Here you can select exactly which columns and which tables you want to import from the XLSX workbook.
7. Click on Submit to complete the import.

Option 3: Import into an existing table

1. Click on the triangular drop-down symbol to the right of the name of your table.
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 in which you can check how the imported data will look in SeaTable. Click on Submit to complete the import.

Attention

With this option, the column names in the table and the column names in the Excel file must be identical. All columns with different names are not imported.

Frequently asked questions

Importing an XLSX file into the Big Data store

By default, SeaTable allows the storage of up to 100,000 rows, whereby the import function supports a maximum of 50,000 rows in an Excel spreadsheet. If you want to import even larger data sets into SeaTable, you can use the big data storage. Here you can find out how to import an XLSX file into the Big Data store.

More helpful articles about importing data

Depending on the form of the source file, you may encounter difficulties when importing data. If something does not work, the following articles may help you:

• Excel import tips and tricks
• Limitations of Excel import